Knowledgebase
Helpcloud Support > Helpcloud Support > Knowledgebase

Search help:


How to Optimize & Reduce size of MySql Database?

Solution

MySql databases form the back end of many online applications including WordPress blogs and website, Shopping carts, Asquared knowledge base.

Size of a database is very important for easy management and must be reviewed on a regular basis.

Optimizing Mysql database can greatly reduce overall size of your database. For example: a WordPress Blog database went from 85MB to just 10MB after optimization.

There are a number of articles you can read to understand and learn how to optmise a database. It is recommended you get a basic understanding of how a database works first.

PLEASE NOTE:

You must backup your database(s) before attempting optimisation or any changes. If something goes wrong, you can then reload the database. It is not recommended you alter the database in any way if you do not have a basic understanding of database operations.

User support is available for this operation, please contact us for current user support rates by lodging a ticket with details on what kind of support you require.

Please go to:

http://www.tothepc.com/archives/how-to-optimize-reduce-size-of-mysql-database/

http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121.aspx

http://www.mysql.com/

 
Was this article helpful? yes / no
Related articles How to Database backup from plesk panel
Adding email addresses to your Spam whitelist or blacklist
Article details
Article ID: 25
Category: Data Base
Views: 204
Rating (Votes): Article rated 3.0/5.0 (6)

 
« Go back