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