FastDomain 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 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:

  • Run away 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 which allow anyone to create a blog.
  • Using blobs to store images.




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 214,892 views tags: dump mysql ssh structure table

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

How to repair and optimize your database using phpMyAdmin:
Knowledgebase Article 316,977 views tags: database mysql optimizing repairing slow speed

Related Help Content

Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article 55,500 views tags: mysql phpmyadmin

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

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Knowledgebase Article 88,112 views tags: databases mysql phpmyadmin

A repository of information on how you can manage your database by using the phpMyAdmin interface.
Knowledgebase Article 269,794 views tags: commands database mysql phpmyadmin

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

This article will walk you through the steps to copying and renaming a database with phpMyAdmin.
Knowledgebase Article 61,611 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 135,299 views tags: database mysql password

How do I remotely connect using a database management software?
Knowledgebase Article 870,459 views tags: connection database mysqlfront remote