Understanding MySQL Database Size Limits and How to Reduce Usage

Every MySQL database on your hosting account counts toward your overall disk space quota, the same allowance your files and emails share. A database that grows unchecked, often from years of spam comments, old logs, or leftover tables from plugins you no longer use, can quietly push you toward your storage limit. Here's how to check your database size and bring it back down.

How to Check Your Database Size

In cPanel

1. Log in to your cPanel account.
2. Under the Databases section, click MySQL® Databases.
3. Scroll to the Current Databases table. Each database is listed with its size in the appropriate column.

For a closer look at individual tables, open phpMyAdmin from the same section, click on a database in the left sidebar, and check the Size column next to each table.

In DirectAdmin

1. Log in to your DirectAdmin account.
2. Go to MySQL Management under the account menu.
3. Each listed database shows its current size.

As with cPanel, open phpMyAdmin from the same page for a table-by-table breakdown.

What Usually Fills Up a Database

• Spam comments and unmoderated form submissions piling up over time
• Cache or "transient" tables left behind by plugins
• Revision history if your site keeps every saved draft or edit
• Log tables from plugins that track visits, errors, or activity
• Leftover tables from apps or plugins you uninstalled without cleaning up their data

How to Reduce Your Database Size

Back up your database before deleting or dropping anything. Some cleanup actions can't be undone, and a wrong deletion can break your website.

1. Open phpMyAdmin and select the database you want to clean up.
2. Sort the table list by size to find the biggest tables first.
3. For tables you recognize as safe to trim (spam comments, old logs, cache data), select the unnecessary rows and delete them, or use your site's own admin tools where available (for example, an "Empty spam" option) rather than editing the database directly if you're not sure which rows are safe to remove.
4. For tables left behind by software you no longer use, confirm the table isn't in active use, then select it and choose Drop to remove it entirely.
5. Once you've cleaned up rows, select the remaining tables, tick the ones you edited, and choose Optimize table from the dropdown to reclaim the freed space, since MySQL doesn't always release space automatically after deleting rows.

If you're not confident identifying which tables or rows are safe to remove, it's worth asking whoever built or maintains your website before making changes directly in the database.

See also How to Back Up a Single MySQL Database before you start, and How to Optimize and Repair a MySQL Database Using phpMyAdmin for more detail on the optimize step.