Scripts about MySql administration

Table & Index Size

SELECT table_name AS 'Tables',        
  ROUND((data_length / 1024 / 1024), 2) "Data in Mb",
  ROUND((index_length / 1024 / 1024), 2) "Index in Mb",
  ROUND(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
FROM information_schema.TABLES
WHERE table_schema = :database
ORDER BY ROUND(data_length + index_length) DESC;

Table Size

SELECT table_name AS 'Tables',
  ROUND(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = :database
ORDER BY ROUND(data_length + index_length) DESC;