mysql查看数据库表大小

SELECT 
    TABLE_SCHEMA AS 'Database', 
    TABLE_NAME AS 'Table', 
    ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2) AS 'Size (MB)' 
FROM 
    information_schema.TABLES 
ORDER BY 
    (DATA_LENGTH + INDEX_LENGTH) DESC;

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 
    ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2) AS 'Size (MB)' 
FROM 
    information_schema.TABLES 
WHERE 
    TABLE_SCHEMA = 'your_database_name' 
    AND TABLE_NAME = 'your_table_name';

FLUSH TABLES;

GRANT SELECT ON information_schema.TABLES TO 'your_user'@'localhost';

SELECT 
    TABLE_SCHEMA AS 'Database', 
    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 
LIMIT 10;