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 to enable the slow query log in MySQL?

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

How to check active MS-SQL connections?

Following are the steps to check active database connection in the MS SQL server please follow...

How to Fix MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"?

Problem Statement MySQL service is stopped. Error Message 150206 4:42:12 [ERROR] Plugin...

How to Optimize MySQL Database Using phpMyAdmin?

Database always grows in size due to high traffic or a large amount of content. This will lead to...

How to take a Backup and Restore of MySQL Databases via Command Line?

mysqldump is an easy and quick tool to create backup of MySQL databases. It creates a dump file...