get mysql table sizes based on http://stackoverflow.com/questions/9620198

gistfile1.txt

# get mysql table sizes
# based on http://stackoverflow.com/questions/9620198
SELECT
  concat(table_schema, '.', table_name) AS "Table",
	table_rows AS "number of rows",
	round((data_length / 1024 / 1024), 2) "Data in MB",
	round((index_length / 1024 / 1024), 2) "Indexes in MB"
FROM information_schema.TABLES;