Technofriends

If you are running a blog using Wordpress, you must definitely optimize your Wordpress Database. In this article, i will discuss how to optimize and repair your wordpress database using phpMyAdmin. If you are wondering about phpMyAdmin, here is a quick walkthrough about it. phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. 

In order to optimize your Wordpress Database tables or for that matter any MySQL database using phpMyAdmin, login to your database using the phpMyAdmin console. Next, select the appropriate database. Once done, select the appropriate tables. From the drop down menu, select the menu item which says “Optimize table”. This will internally optimize the tables and present to you the results.

When you select the Optimize Table menu, MySQL command OPTIMIZE TABLE ’<table name>’ is called by phpMyAdmin. The MySQL Optimize Table command effectively de-fragments a mysql table and is very useful for tables which are frequently updated and/or deleted. 

There also exists a Wordpress Plugin called Optimize DB, the plugin is pretty much useful for those to whom the use of phpMyAdmin appears to be a risky thing. This plugin lets you do just one simple task: optimize the tables of your database, to reduce their overhead.

Also Read: [How-To] Create and Delete Users in MySQL

You can follow me on Twitter at http://twitter.com/vaibhav1981

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Related posts:

1. [How-To] Delete Wordpress Spam Comments Using phpMyAdmin
2. [How-To] Create and Delete Users in MySQL
3. What are JOINS in Database?
4. [MySQL] How To Rename a User in MySQL
5. Manage SQLite Database on your PC with SQLite Manager