Check MySQL Database Size – Command Line

Everyone who has been involved with IT for more than a few months has at least heard of MySQL. The acquisition of MySQL AB by Sun Microsystems brought a great deal of additional attention to MySQL’s database management system (DBMS). Even so, there is often more to MySQL than many people realize.

Unix-based servers with MySQL installations represent the majority of current installations of MySQL Server. Unlike Windows, Unix-based servers come in a number of packaging formats and configurations.

Suggested Read: Handy MySQL Commands – Cheatsheet 2018

And it is often required to get the size of a database in MYSQL via command line if you are using UNIX based OS.

By just a single SQL Query, you can easily get the information about the required databases from information_schema and print their size in MBs with the following command:

Command: select table_schema `Database`, Round(Sum(data_length + index_length) / 1024 / 1024, 1) `Size in MB` FROM information_schema.TABLES GROUP BY table_schema;

In case, if you want to display the DB size of a particular database, then use the following command:

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

Similarly you can also find out the size of a particular table by typing the following command:

Command: SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = “wp” AND table_name = “wp_users”;

You may also like:

Related Posts