复制SELECT table_schema AS 数据库,何查 sum( table_rows ) AS 记录数, sum( TRUNCATE ( data_length / 1024 / 1024, 2 ) ) AS 数据容量(MB), sum( TRUNCATE ( index_length / 1024 / 1024, 2 ) ) AS 索引容量(MB) FROM information_schema.TABLES GROUP BY table_schema ORDER BY sum( data_length ) DESC, sum( index_length ) DESC; 1.2.3.4.5.6.7.8.9.10.11.12. |
喜欢
讨厌