Views: 1,941
Totally Zenned
Does anyone use this to check on their database? If so, has anyone used the optimize table option? Does this help to speed up the site?
Black Belt
Please backup your data before any database manipulation and I will not be resposible for any mistakes or loss of data.
I have only used this when there was a problem.
What a difference a simple cleanup and optimization makes! If you are using PhpMyAdmin, follow these simple steps (after safely backing up your data).
Click on the database you are working with on the left hand side frame (not the table, the database name)
On the right hand column your tables should be listed. Scroll down till you see the “Check all” link.
Click on that link, make sure all database tables are checked and then from the dropdown next to it, carefully select “Optimize table”.
This should perform an analysis, repair and an optimization of your database. Most problems will be solved with this.
Fields marked required must be completed.
Tell staff why this post should be reviewed.
Required for login, security, and core site functionality.
Help us understand how the site is used so we can improve it.
Used for promotion and personalized campaign measurement.