top_5_largest_tables.sql

gistfile1.txt

# Query to list top 5 largest tables in the database
# http://www.thegeekstuff.com/2008/11/overview-of-mysql-information_schema-database-with-practical-examples/
# This examples gives the top 5 largest space occupying tables in the database along with it’s size in MB.

SELECT concat(table_schema,'.',table_name) table_name,
       concat(round(data_length/(1024*1024),2),'M') data_length
       FROM information_schema.TABLES
       ORDER BY data_length DESC LIMIT 5