You can quickly check the total size of your database and the size of individual tables within it using phpMyAdmin. This helps you monitor disk usage and identify tables that may be consuming excessive space.
Checking Database Size in phpMyAdmin
- Log in to your cPanel account.
- Navigate to the Databases section and click phpMyAdmin.
- In the left-hand panel, click on the database you wish to check.
- On the database overview page, scroll to the Tables section where all tables are listed.
- Look at the Size column to see the size of each individual table.
- The Overhead column shows fragmented (wasted) space in each table.
- The total size of the database is displayed below the table list, or you can sum the values in the Size column.
Alternative: Using the "Database" Tab
- On the phpMyAdmin home page, click the Databases tab at the top.
- You will see a list of all databases with their sizes displayed in the Size column.
- Click on any database name to view its detailed table breakdown.
Important Notes
- Database size includes data and index storage. phpMyAdmin shows these separately in the table view.
- If the Overhead column shows a non-zero value, your tables have fragmented space. Click Check All, then select Optimize table from the dropdown to reclaim that space.
- Your hosting plan has a database size limit. If your database approaches this limit, you may need to archive old data or upgrade your plan.
Troubleshooting
- Size not displaying: Ensure your database user has the
SHOW DATABASESandSELECTprivileges. Refresh the page if values appear as "—". - Unexpectedly large size: Check the Overhead column. Running Optimize table on affected tables often reduces the total size significantly.
