【MYSQL计算表记录占空间大小】

2019独角兽企业重金招聘Python工程师标准>>>

1、

SELECT 
  table_name,
  table_rows,
  data_length + index_length,
  CONCAT(
    ROUND(
      (data_length + index_length) / 1024 / 1024,
      2
    ),
    'MB'
  ) DATA 
FROM
  information_schema.tables 
WHERE table_schema = 'test_schema' 
ORDER BY DATA DESC;

SELECT 
  (SUM(DATA_LENGTH) + SUM(INDEX_LENGTH))/1024/1024 
FROM
  information_schema.tables 
WHERE table_schema = 'test_schema';

转载于:https://my.oschina.net/maojindaoGG/blog/2998467