Saturday, July 12, 2014

MySQL Database Table Size 

Query MySQL table sizes

SELECT table_name AS "Tables", 
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
FROM information_schema.TABLES 
WHERE table_schema = "$DBNAME" AND (data_length + index_length) > $SIZE
ORDER BY (data_length + index_length) DESC;


Show filesystem status
sudo file -s /dev/xvdf

sudo mount /dev/xvdf /backup


sudo apt-get install php5-gd php5-mysql
Posted by at

1 comment:

  1. kayle jamesAugust 19, 2026 at 3:17 AM

    Preparing an assignment involves more than writing the main discussion. Students also need to consider structure, formatting, referencing, proofreading, and submission instructions. The first page can provide important information that identifies the assignment and its author. Students who need guidance on a cover page assignment can review examples of commonly used academic layouts. It is always advisable to compare any example with the instructions given by the university. Different courses may require different information, so students should avoid assuming that one format will work for every assignment or academic institution.

    ReplyDelete

Subscribe to: Post Comments (Atom)