mysqlのテーブルごとのデータサイズを調べるときに使う

mysql_data_size.sql

select
  table_name,
  engine,
  table_rows,
  avg_row_length,
  floor((data_length+index_length)/1024/1024) AS MB
from
  information_schema.tables
where
  table_schema = 'DATABASE_NAME'
order by 
  (data_length+index_length) DESC
;