Bluehost 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 52,184 views bookmark tags: (updated 1257 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

Knowledgebase Article

MySQL Database Reported Size and SQL Size Differ

An exported .sql file shows as a different size than the reported size in cPanel (updated 1046 days ago)

Knowledgebase Article

Email Attachment Size Limit

Can I send an email with large files/attachments? (updated 25 days ago)

Knowledgebase Article

Managing Your Database Using phpMyAdmin

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 460 days ago)

Related Help Content

Knowledgebase Article

How to Copy or Rename a Database

This article will walk you through the steps to copying and renaming a database with phpMyAdmin. (updated 452 days ago)

Knowledgebase Article

How to Create and Delete MySQL Databases and Users

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 446 days ago)

Knowledgebase Article

Resetting MySQL Database User and Password

This article will explain how to change the password for a database in the event that the original password is lost. (updated 452 days ago)

Knowledgebase Article

MySQL Database Compatibility

How do I make my MySQL database compatible with the version you provide? (updated 1656 days ago)

Knowledgebase Article

Email Accounts - Change the Mailbox (Size) Quota

Where do I Change my Mailbox (Size) Quota? How do I Increase or Decrease Mailbox (Storage) Quota? (updated 216 days ago)

Knowledgebase Article

How to import a MySQL Database using phpMyAdmin

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 459 days ago)

Knowledgebase Article

Dropping columns from a database table in phpMyAdmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 459 days ago)

Knowledgebase Article

MySQL and Postgres Database Repair

What necessitates "Database Repair"? (updated 633 days ago)