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 Repair MDF Files in SQL Server Database?

Important Note :  Before proceed to following steps, we strongly advise taking your database...

Fix :: Unable to login in phpMyadmin after revoking MySQL root user

Problem Statement I am not able to login into phpMyadmin after revoking root user. Solution...

How to Administrate MySQL Server with mysqladmin commands?

By using mysqladmin commands, you can perform basic MySQL tasks very easily, such as...

How to fix InnoDB database corruption error?

Check the log files. If you find InnoDB database corruption, follow the below mentioned steps:...

How to back up MySQL databases using AutoMySQLBackup?

What is AutoMySQLBackup? AutoMySQLBackup is a script that allows you to schedule the automatic...