Difference between revisions of "Find the size of mysql database"

From MyWiki
Jump to: navigation, search
(Created page with "SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ; <br>")
(No difference)

Revision as of 08:13, 14 September 2015

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;