Database Size and Table Limits
Occasionally, databases grow faster than expected. This sustained growth can cause performance problems for any website. If ignored for long enough, this can cause downtime. Our research shows that server performance degrades when the MySQL usage is over 5,000 tables and/or 10 GB on a single account or 5,000 tables and/or 5 GB on a single database. In order to ensure optimal performance for your account and the others in your shared hosting environment, please be wary of the following:
- Runaway error logs/sessions/cache tables in the database - delete excess non-needed data.
- Spam posts in a forum (phpbb, simple machines) - implement captcha to disable anonymous posting.
- WordPress MU installations allow anyone to create a blog.
- Using blobs to store images.