# HG changeset patch # User Oleksandr Gavenko # Date 1453493698 -7200 # Node ID b5f927fa28cec921ff6eeda22424b6530abb5e66 # Parent 25c0fb1dfc227bb464fb1996fbb5680c7547c9e6 Add row count. diff -r 25c0fb1dfc22 -r b5f927fa28ce mysql.rst --- 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;