«

Query to list top 10 largest tables in MySQL DB

September 18, 2010, 2:41 pm

mysql> 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 10;

Category: Database