Från Googlehemsida

Hoppa till: navigering, sök

With this query you'll get the size of each table in the DB.

 SELECT table_name AS "Tables", 
 round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
 FROM information_schema.TABLES 
 WHERE table_schema = "my_database_name"
 ORDER BY 2 DESC;