Bluehost India 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.
Recommended Help Content
MySQL dump of tables only no data
I would like to dump the Table Structure for my MySQL Database, but none of the data.
How To Rename Database Tables in PHPMyAdmin
This article will show you how to rename a database table in phpMyAdmin.
MySQL Repair and Optimize Tables in phpMyAdmin
How to repair and optimize your database using phpMyAdmin:
Related Help Content
How to Add Tables to a DB in PhpMyAdmin
Guidance on adding tables to your mySQL database in phpMyAdmin
Email Attachment Size Limit
Can I send an email with large files/attachments?
Modifying table columns - phpMyAdmin
A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Managing Your DB Using phpmyadmin
A repository of information on how you can manage your database by using the phpMyAdmin interface.
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.
How to Copy or Rename a Database
This article will walk you through the steps to copying and renaming a database with phpMyAdmin.
How To Reset MySQL Database User & Password
This article will explain how to change the password for a database in the event that the original password is lost.
Email Accounts - Change the Mailbox Size Quota
Where do I Change my Mailbox (Size) Quota? How do I Increase or Decrease Mailbox (Storage) Quota?