MySQL 业务使用手册

SELECT 
  table_schema,
  ROUND(SUM(data_length) / 1024 / 1024, 2) AS data_size,
  ROUND(SUM(index_length) / 1024 / 1024, 2) AS index_size
FROM 
  information_schema.TABLES
GROUP BY 
  table_schema
ORDER BY 
  2 DESC;