How to get the sizes of the tables of a MySQL database?

Posted by Editorial Staff | Updated on

Want to get the sizes of the tables of a MySQL database? You can use this query to show the size of a table (although you need to substitute the variables first):

or this query to list the size of every table in every database, largest first:


If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers