gistfile1.txt

SELECT CONCAT(table_schema, '.', table_name), CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows, CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA, CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx, CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size, ROUND(index_length / data_length, 2) idxfrac FROM information_schema.TABLES WHERE table_schema = 'warmshowers' ORDER BY data_length + index_length DESC LIMIT 10;
+---------------------------------------+-------+-------+-------+------------+---------+
| CONCAT(table_schema, '.', table_name) | rows  | DATA  | idx   | total_size | idxfrac |
+---------------------------------------+-------+-------+-------+------------+---------+
| warmshowers.search_index              | 1.02M | 0.05G | 0.12G | 0.17G      |    2.17 |
| warmshowers.queue                     | 0.02M | 0.12G | 0.00G | 0.12G      |    0.01 |
| warmshowers.cache_form                | 0.00M | 0.09G | 0.00G | 0.09G      |    0.01 |
| warmshowers.geonames                  | 0.26M | 0.03G | 0.05G | 0.09G      |    1.58 |
| warmshowers.watchdog                  | 0.21M | 0.06G | 0.00G | 0.06G      |    0.07 |
| warmshowers.cache_filter              | 0.01M | 0.05G | 0.00G | 0.06G      |    0.05 |
| warmshowers.users                     | 0.03M | 0.05G | 0.00G | 0.05G      |    0.10 |
| warmshowers.accesslog                 | 0.18M | 0.03G | 0.01G | 0.03G      |    0.25 |
| warmshowers.wsuser                    | 0.03M | 0.02G | 0.00G | 0.03G      |    0.07 |
| warmshowers.url_alias                 | 0.11M | 0.01G | 0.02G | 0.02G      |    1.68 |
+---------------------------------------+-------+-------+-------+------------+---------+
10 rows in set (1.80 sec)