Search This Blog

Sunday, November 18, 2018

List All Table Sizes From ALL Databases on MySQL

Query for the size of alltables within all databases in the entire system. This can be accomplished easily with the following query:

This will return not only the size of the table, but also the table name and parent database it is associated with.