MySQL查看数据库表容量大小

数据库 0 1175

SELECT 
  table_schema AS '数据库',
  table_name AS '表名',
  table_rows AS '记录数',
  TRUNCATE(data_length / 1024 / 1024, 2) AS '数据容量(MB)',
  TRUNCATE(index_length / 1024 / 1024, 2) AS '索引容量(MB)' 
FROM
  information_schema.tables 
ORDER BY data_length DESC,
  index_length DESC ;