SELECT table_schema,SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024/1024 AS total_mb
FROM information_schema.TABLES group by table_schema;
结果如下图:
SELECT table_schema,SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024/1024 AS total_mb
FROM information_schema.TABLES group by table_schema;
结果如下图: