\nFinding the 20 Largest Databases<\/p>\n
- \n
- Access Your Server:<\/strong>\n
- \n
- \u00a0Log in to your WHM panel.<\/li>\n
- Go to WHM > Terminal, or connect via SSH using your preferred client.
\n![\"terminal\"](\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2025\/04\/Snag_38d2ec44.png\")
<\/a><\/li>\n- Run the MySQL Query:
\nExecute the following command:<\/p>\nmysql -e \u201cSELECT table_schema AS \u2018Database\u2019,\r\nROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS \u2018Size (MB)\u2019\r\nFROM information_schema.tables\r\nGROUP BY table_schema\r\nORDER BY SUM(data_length + index_length) DESC\r\nLIMIT 20;\u201d<\/pre>\n<\/li>\n<\/ol>\n<\/li>\n
- Understanding the Output
\n<\/strong>The query will return a list of the top 20 databases, sorted by size in megabytes (MB). The output will look something like this:<\/p>\nDatabase Size (MB)\r\nbig_database_1\u00a0\u00a0 50\r\nbig_database_2\u00a0\u00a0 950.75\r\nuser_site_db\u00a0\u00a0\u00a0\u00a0 820.20<\/pre>\n<\/li>\n
- To List All Databases (Not Just Top 20)
\n<\/strong>Simply remove the LIMIT 20; clause to list every database:<\/p>\nmysql -e \u201cSELECT table_schema AS \u2018Database\u2019,\r\nROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS \u2018Size (MB)\u2019\r\nFROM information_schema.tables\r\nGROUP BY table_schema\r\nORDER BY SUM(data_length + index_length) DESC;\u201d<\/pre>\n
Alternative Method: Check Disk Usage
\n<\/strong>For a quick, file-based check, use the du command:<\/p>\ndu -sh \/var\/lib\/mysql\/* | sort -hr | head -20<\/pre>\n
Note: This method may be inaccurate for InnoDB databases since they store data in shared tablespaces.<\/li>\n<\/ol>\n
You can use this method to view the size of all databases on a cPanel server. If you need further assistance, our support team is here to help.<\/p>\n
Ready to set up a new database? Learn How to create a MySQL database in cPanel<\/a><\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
If you\u2019re managing a cPanel server and need to view the sizes of all MySQL databases, a quick MySQL query can give you the correct insights. This is particularly helpful…<\/p>\n
- Run the MySQL Query: