怎么看mysql数据库的数据大小

SELECT table_schema AS '数据库名', 
       ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS '大小(MB)'
FROM information_schema.tables
GROUP BY table_schema;

DELIMITER //
CREATE PROCEDURE `GetDatabaseSize`()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE schema_name VARCHAR(100);
    DECLARE cur CURSOR FOR 
        SELECT schema_name FROM information_schema.schemata;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    CREATE TEMPORARY TABLE IF NOT EXISTS db_size (
        schema_name VARCHAR(100),
        size_mb FLOAT
    );
    OPEN cur;
    read_loop: LOOP
        FETCH cur INTO schema_name;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @query = CONCAT('SELECT "', schema_name, '" AS schema_name, 
            ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS size_mb 
            FROM ', schema_name, '.table_name');
        PREPARE stmt FROM @query;
        EXECUTE stmt;
        INSERT INTO db_size (schema_name, size_mb)
        SELECT schema_name, size_mb;
        DEALLOCATE PREPARE stmt;
    END LOOP;
    CLOSE cur;
    SELECT * FROM db_size;
    DROP TABLE db_size;
END //
DELIMITER ;