Skip to content

Get Size of MySQL Database

Run the following query using phpMyAdmin to get the size of a MySQL database:

SELECT
table_schema "Data Base Name", sum( data_length + index_length )/1024/1024"Data Base Size in MB", sum( data_free )/1024/1024"Free Space in MB"FROM information_schema.TABLES GROUPBY table_schema ;

Tags: