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 88,413 views bookmark tags: (updated 1786 days ago)

Was this resource helpful?

Did this resolve your issue?

Please add any other comments or suggestions about this content:

Recommended Help Content

An exported .sql file shows as a different size than the reported size in cPanel (updated 1575 days ago)
Knowledgebase Article 26,248 views tags: backup database dump export mysql mysqldump size sql

Can I send an email with large files/attachments? (updated 514 days ago)
Knowledgebase Article 148,245 views tags: email limits

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 989 days ago)
Knowledgebase Article 158,753 views tags: commands database mysql phpmyadmin

Related Help Content

This article will walk you through the steps to copying and renaming a database with phpMyAdmin. (updated 157 days ago)
Knowledgebase Article 18,912 views tags: database phpmyadmin

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 46 days ago)
Knowledgebase Article 484,538 views tags: creation database mysql

This article will explain how to change the password for a database in the event that the original password is lost. (updated 981 days ago)
Knowledgebase Article 32,877 views tags: database mysql password

How do I make my MySQL database compatible with the version you provide? (updated 2185 days ago)
Knowledgebase Article 85,160 views tags: database mysql

This article explains how to install WordPress when Mojo is unable to create the database automatically. (updated 82 days ago)
Knowledgebase Article 5,767 views tags: MOJO automatic database install wordpress

This article will explain how to convert a MySQL database to UTF-8. (updated 87 days ago)
Knowledgebase Article 1,470 views tags: character database encoding mysql utf

Where do I Change my Mailbox (Size) Quota? How do I Increase or Decrease Mailbox (Storage) Quota? (updated 745 days ago)
Knowledgebase Article 210,592 views tags: account change decrease email increase mailbox quota size

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 156 days ago)
Knowledgebase Article 172,929 views tags: database mysql phpmyadmin