Skip to main content

HostMonster Web Hosting Help

Database Size and Table Limits.

Database Size and Table Limits.
Occasionally databases grow faster then 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 1,000 tables and/or 3 GB on a single account or 1,000 tables and/or 2 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.

1. Run away error logs/sessions/cache tables in the database - delete excess non needed data.
2. Spam posts in a forum (phpbb, simple machines) - implement captcha to disable anonymous posting.
3. WordPress MU installations which allow anyone to create a blog.
4. Using blobs to store images.



Knowledgebase Article 120,037 views bookmark tags:


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

I would like to dump the Table Structure for my MySQL Database, but none of the data.
Knowledgebase Article 202,876 views tags: dump mysql ssh structure table

Can I send an email with large files/attachments?
Knowledgebase Article 204,411 views tags: email limits

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 646,898 views tags: creation database mysql

Related Help Content

This article will walk you through the steps to copying and renaming a database with phpMyAdmin.
Knowledgebase Article 51,138 views tags: database phpmyadmin

This article will explain how to change the password for a database in the event that the original password is lost.
Knowledgebase Article 105,594 views tags: database mysql password

This article explains how to install WordPress when Mojo is unable to create the database automatically.
Knowledgebase Article 68,597 views tags: MOJO automatic database install wordpress

Where do I Change my Mailbox (Size) Quota? How do I Increase or Decrease Mailbox (Storage) Quota?
Knowledgebase Article 252,619 views tags: account change decrease email increase mailbox quota size

This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 149,854 views tags: databases mysql phpmyadmin

How do I make my MySQL database compatible with the version you provide?
Knowledgebase Article 117,224 views tags: compatible database mysql

This article explains how to find the database in use by a WordPress site.
Knowledgebase Article 140,977 views tags: database find wordpress

How do I import a backup of my database (.sql file) using phpMyAdmin?
Knowledgebase Article 486,778 views tags: database mysql phpmyadmin

This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here