正文

linux mysql 查看数据库大小

IP云
IP云V管理员/2 阅读
09/15
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

SELECT
CONCAT(TRUNCATE(SUM(data_length)//,),'MB') AS data_size,
CONCAT(TRUNCATE(SUM(max_data_length)//,),'MB') AS max_data_size,
CONCAT(TRUNCATE(SUM(data_free)//,),'MB') AS data_free,
CONCAT(TRUNCATE(SUM(index_length)//,),'MB') AS index_size,
TABLE_SCHEMA
FROM information_schema.tables
group by TABLE_SCHEMA;