【数据库】MYSQL查看数据库所占空间大小容量命令
SELECT
TABLE_NAME,
CONCAT(
TRUNCATE (DATA_LENGTH / 1024 / 1024, 2),
" MB"
) AS DATA_SIZE,
CONCAT(
TRUNCATE (INDEX_LENGTH / 1024 / 1024, 2),
" MB"
) AS INDEX_SIZE
FROM
INFORMATION_SCHEMA. TABLES
WHERE
TABLE_SCHEMA = "BFIP"
GROUP BY
TABLE_NAME
ORDER BY
TABLE_NAME,
CONCAT(
TRUNCATE (DATA_LENGTH / 1024 / 1024, 2),
" MB"
) AS DATA_SIZE,
CONCAT(
TRUNCATE (INDEX_LENGTH / 1024 / 1024, 2),
" MB"
) AS INDEX_SIZE
FROM
INFORMATION_SCHEMA. TABLES
WHERE
TABLE_SCHEMA = "BFIP"
GROUP BY
TABLE_NAME
ORDER BY
DATA_LENGTH DESC;
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
