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
WHERE 
    TABLE_SCHEMA = 'your_database_name'
ORDER BY 
    Size (MB) DESC;

SHOW TABLE STATUS FROM your_database_name;

DELIMITER //

CREATE PROCEDURE GetTableSizes()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE db_name VARCHAR(255);
    DECLARE table_name VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'your_database_name';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO db_name, table_name;
        IF done THEN
            LEAVE read_loop;
        END IF;

        SELECT 
            db_name AS `Database`,
            table_name AS `Table`,
            ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS `Size (MB)`
        FROM 
            information_schema.TABLES
        WHERE 
            TABLE_SCHEMA = db_name AND TABLE_NAME = table_name;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL GetTableSizes();