How to Check Database Size in MySQL

This updated guide examines How to Check Database Size in MySQL and organizes the essential facts, background, and practical takeaways in clear American English.

Method 1

Using MySQL Workbench

1. Open MySQL Workbench. It has a blue icon that with an image that resembles a dolphin. Click the icon to launch MySQL Workbench.
2. Connect to the MySQL server. Double-click the MySQL server on under the SQL Development module in the start-up screen. Then enter the database password to connect.^{[1]XResearch source}
   • If SQL server is not listed on this screen, click New Connection and enter the server information, including hostname, port, username, and password.
3. Hover over the database in the schema pane. It's in the sidebar to the left. This displays a couple of icons to the right of the database name.
4. Click the information icon. It's the icon that resembles an "i" next to the database name in the schema pane.
5. Click theInfotab. It's the first tab in the main pane in the center. This displays information about the database. The database size is listed next to "Database size (rough estimate). this displays a rough estimate of the size of the database.^{[2]XResearch source}

Method 2

Running a Query

1. Connect to a MySQL server. There are a number of apps you can use to connect to a MySQL database, including MySQL Workbench. You can also query a MySQL database in the command line in Windows, or terminal on Mac. Once MySQL is installed on your computer you'll need to navigate to the MySQL directory in the Windows command line and typemysql -u root -p. Then enter the password for your database.
2. TypeSELECT table_schema "DB Name",as the first line of your query. This is the select command to query run a query on the database.
3. TypeSUM(data length + table length) 'Size in bytes',as the second line. This command will display the size of each table in bytes.
4. TypeROUND(SUM(data_length + index_length) / 1024 / 1024, 2) 'Size in MiB'as the next line. This displays a rounded number of the size in megabytes.
   • To display a rounded number in kilobytes, typeROUND(SUM(data_length + index_length) / 1024, 2) 'Size in KiB'instead.^{[3]XResearch source}
5. TypeFROM information_schema.tablesas the last line. This command specifies which database tables to query.
6. TypeGROUP BY table_schema;and execute the query. This will display the size of your databases. You can also type {[kbd|WHERE table_schema = 'database name';}} to check the size of a specific database. Type the actual name of the database in place of "database name". Your query should look something like this:

   SELECTtable_schema"DB Name"SUM(datalength+tablelength)'Size in bytes',ROUND(SUM(data_length+index_length)/1024/1024,2)'Size in MiB'FROMinformation_schema.tablesGROUPBYtable_schema;