mysql数据库怎样查看容量

SELECT TABLE_SCHEMA AS '数据库', 
       SUM(data_length + index_length) / 1024 / 1024 AS '大小(MB)' 
FROM information_schema.TABLES 
GROUP BY TABLE_SCHEMA;

SELECT TABLE_NAME AS '表名', 
       ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS '大小(MB)' 
FROM information_schema.TABLES 
WHERE TABLE_SCHEMA = 'your_database' 
      AND TABLE_NAME = 'your_table';

SELECT TABLE_NAME AS '表名', 
       ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS '大小(MB)' 
FROM information_schema.TABLES 
WHERE TABLE_SCHEMA = 'your_database' 
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;

mysql -u your_username -p

USE your_database;
SHOW TABLE STATUS;