Skip to content

MySQLDatabaseSize.md

Latest commit

 

History

History
35 lines (25 loc) · 933 Bytes

MySQLDatabaseSize.md

File metadata and controls

35 lines (25 loc) · 933 Bytes

How do I find out how large my MySQL database is?

To find out how much space the current database is using, start a MySQL console on the database in question, then run this:

:::sql
SELECT table_schema "Database Name"
     , SUM(data_length + index_length) / (1024 * 1024) "Database Size in MB"
FROM information_schema.TABLES
GROUP BY table_schema;

How to delete a database I don't need any more?

Start a MySQL console and run the following command:

:::sql
drop database `<your_username>$<your_database_name>`;

replacing placeholders in brackets respectively with your username and the database name that should be deleted. See "Using MySQL" help page or more details.