mysql查看数据库和表使用空间

– 1.切换

USE information_schema;

– 2.查看数据库使用大小

SELECT
  concat(
    round(
      sum(data_length / 1024 / 1024),
      2
    ),
    'MB'
  ) AS DATA
FROM
  TABLES
WHERE
  table_schema = 'user_server';

– 3.查看表使用大小

SELECT
  concat(
    round(
      sum(data_length / 1024 / 1024),
      2
    ),
    'MB'
  ) AS DATA
FROM
  TABLES
WHERE
  table_schema = 'user_server'
AND table_name = 'log_info';