author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Fri, 22 Jan 2016 22:14:58 +0200 | |
changeset 1879 | b5f927fa28ce |
parent 1878 | 25c0fb1dfc22 |
child 1880 | ff2e0241303c |
--- a/mysql.rst Fri Jan 22 22:13:42 2016 +0200 +++ b/mysql.rst Fri Jan 22 22:14:58 2016 +0200 @@ -75,8 +75,9 @@ GROUP BY table_schema; SELECT - table_schema as `Database`, - table_name AS `Table`, + table_schema AS `Database`, + table_name, + table_rows, round(((data_length + index_length) / 1024 / 1024), 2) `Size, MiB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;