表大小查询
-
查看mysql数据库大小_查看库表大小
使用SELECT table_schema AS '数据库名', SUM(data_length + index_length) / 1024 / 1024 AS '数据库大小' FROM information_schema.tables GROUP BY table_schema;命令查看库表大小。
使用SELECT table_schema AS '数据库名', SUM(data_length + index_length) / 1024 / 1024 AS '数据库大小' FROM information_schema.tables GROUP BY table_schema;命令查看库表大小。