Find the table sizes in MySQL database


You would like to have a list with all the tables in an MySQL database, sorted with their sizes (actual table and indices).


You could run the following query to give you a list of all the tables sorted by size:

Take from the answer here