我们可以借助以下语句检查所有MySQL数据库的大小
mysql> SELECT table_schema "Database", -> SUM(data_length + index_length)/1024/1024 "Size in MB" -> FROM information_schema.TABLES GROUP BY table_schema; +--------------------+----------------+ | Database | Size in MB | +--------------------+----------------+ | gaurav | 1.04785156 | | information_schema | 0.00878906 | | mysql | 0.68551350 | | performance_schema | 0.00000000 | | sample | 0.04687500 | | tutorial | 0.03125000 | +--------------------+----------------+ 6 rows in set, 1 warning (0.33 sec)
以上就是如何查看所有MySQL数据库的大小?的详细内容,更多请关注php中文网其它相关文章!
已抢65721个
抢已抢31313个
抢已抢17278个
抢已抢8781个
抢已抢11345个
抢已抢23524个
抢