equal
deleted
inserted
replaced
73 ROUND(SUM(data_length+index_length)/1024/1024, 2) "Size, MiB" |
73 ROUND(SUM(data_length+index_length)/1024/1024, 2) "Size, MiB" |
74 FROM information_schema.TABLES |
74 FROM information_schema.TABLES |
75 GROUP BY table_schema; |
75 GROUP BY table_schema; |
76 |
76 |
77 SELECT |
77 SELECT |
78 table_schema as `Database`, |
78 table_schema AS `Database`, |
79 table_name AS `Table`, |
79 table_name, |
|
80 table_rows, |
80 round(((data_length + index_length) / 1024 / 1024), 2) `Size, MiB` |
81 round(((data_length + index_length) / 1024 / 1024), 2) `Size, MiB` |
81 FROM information_schema.TABLES |
82 FROM information_schema.TABLES |
82 ORDER BY (data_length + index_length) DESC; |
83 ORDER BY (data_length + index_length) DESC; |
83 |
84 |
84 SELECT |
85 SELECT |