This article demonstrates how to determine the size of MySQL databases and tables. You can do this by using the phpMyAdmin web interface or by using the command line.
You can use the phpMyAdmin web interface to determine the sizes of MySQL databases and tables. To do this, follow these steps:
The phpMyAdmin administration page appears in a new window.
In the right pane, locate the Size column. phpMyAdmin displays the size of each table in the database:
To obtain the total size of the database, scroll down to the end of the Size column:
You can use the mysql command-line program to determine the sizes of MySQL databases and tables. To do this, follow these steps:
mysql -u username -p
To determine the sizes of all of your databases, at the mysql> prompt type the following command:
SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;
To determine the sizes of all of the tables in a specific database, at the mysql> prompt, type the following command. Replace database_name with the name of the database that you want to check:
SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "database_name" ORDER BY (data_length + index_length) DESC;
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.