mysql查看数据及索引所占的空间
– 查询数据占用空间
SELECT
CONCAT(
ROUND(
SUM(data_length) / (1024 * 1024 * 1024),
6
),
' GB'
) AS 'Total Data Size'
FROM
information_schema. TABLES
WHERE
table_schema LIKE 'crmdbcs';
– 查询索引占用空间
SELECT
CONCAT(
ROUND(
SUM(index_length) / (1024 * 1024 * 1024),
6
),
' GB'
) AS 'Total Index Size'
FROM
information_schema. TABLES
WHERE
table_schema LIKE 'crmdbcs';