How to check MYSQL Database size in phpMyAdmin and via command?

Sometimes it is required to check the MySQL Database size. You can check it from the phpMyAdmin as well as using ssh.

From phpMyAdmin 

 

  1. Login to cPanel. Skip this step if you have installed MySQL Database in Windows. You can directly open phpMyAdmin using server ipaddress:8080

  2. Click on phpMyAdmin.



  3. Select the Database which size you want to check.



  4. Go to the size column. At the end of the column, you can view the size of that Database as per below image.



From SSH Command

 

  1. Login to SSH using root.

  2. Enter in MySQL using the following command.
mysql -u username -p

MySQL username will be root

  1. Enter the Password once Password prompt appears.

  2. Copy/Paste the below command to display all the Databases with its size in MB.

#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;

If you are looking to display the size of a single Database. Change the Databasename to your database.

select table_schema `Database`, Round(Sum(data_length + index_length) / 1024 / 1024, 1)
`Size in MB` FROM information_schema.TABLES WHERE table_schema =
‘Databasename’;

If you are looking to display the size of a single Database along with its tables. Change the Databasename to your database.

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;
  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How do I connect MySQL database via MySQL Workbench?

MySQL Workbench is the excellent MySQL client tool used to connect to remote MySQL database from...

How to convert time zone in MySQL?

You can change the timezone in MySQL using php function CONVERT_TZ. Following is the SQL command...

How to Fix Error Forcing close of thread 310 user: 'root' in MySQL?

Problem Statement MySQL server keeps on shutting down. Error Message C:\Program...

How to connect MySQL using Python?

There are several ways to use python to connect with the MySQL database. In this article, we will...

How to enable the slow query log in MySQL?

Slow MySQL queries can significantly lower down the performance of your web application and eat...