【Mysql】mysql数据库占用空间查询

Mysql数据库操作

数据库大小查询

# 查询 每一个 数据库大小
SELECT table_schema AS '数据库名',SUM(data_length + index_length) / 1024 / 1024 AS '数据库大小(MB)'
FROM information_schema.TABLES
GROUP BY table_schema;

# 查询 数据库占用磁盘大小
SELECT SUM(data_length + index_length) / 1024 / 1024 / 1024 AS '数据库大小(GB)'
FROM information_schema.TABLES

# 查询 每个表占用多少行
SELECT TABLE_NAME, TABLE_ROWS
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_database_name'
ORDER BY TABLE_ROWS DESC;