mysql查看数据量大小

SELECT table_schema AS 'Database',
       SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)'
FROM information_schema.TABLES
GROUP BY table_schema;

SELECT table_name AS 'Table',
       ROUND(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)'
FROM information_schema.TABLES
WHERE table_schema = 'your_database_name'
ORDER BY (data_length + index_length) DESC;

SELECT table_name AS 'Table',
       index_name AS 'Index',
       ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)'
FROM information_schema.STATISTICS
WHERE table_schema = 'your_database_name'
GROUP BY table_name, index_name
ORDER BY SUM(data_length + index_length) DESC;