mysql-data_length-check.sql

use sampledb;

SELECT
  table_name
  , engine
  , table_rows
  , avg_row_length
  , data_free
  , floor((data_length+index_length)/1024/1024) as all_size_MB
  , floor((data_length)/1024/1024) as data_size_MB
  , floor((index_length)/1024/1024) as index_size_MB
FROM 
  information_schema.tables
WHERE
  table_schema=database()
ORDER BY
  (data_length+index_length)
  DESC;