This article shows you how to use the database table optimization tool found in phpMyAdmin.
Over time, MySQL databases may become less efficient and run slower. It's very easy to optimize databases using the DB optimize tool found in phpMyAdmin. Using this tool is similar to defragmenting a computer, and can shrink a database's size and remove unused elements that are left behind from frequent changes, referred to as overhead. There is no danger in using this tool and you should consider running it occasionally, especially if your database changes frequently.
If you're having trouble with the steps in this article, additional assistance is available via Advanced Support, our premium services division. For more information on what Advanced Support can do for you, please click here.
These instructions use phpMyAdmin version 3.5.2. Your user interface may differ slightly, but you should still be able to follow these steps without an issue.
1. Log in to phpMyAdmin. If you need help doing this or are not familiar with phpMyAdmin, instructions can be found here. Once you're logged in, click on the Databases tab at the top.
2. Select the relevant database from the Databases list.
3. Click on Check All unless you only want to target specific tables, and then select Optimize table from the drop-down menu.
4. You should receive a confirmation screen letting you know that the selected tables have been optimized. You can now log out of phpMyAdmin. As always, please feel free to contact Media Temple's award winning 24/7 support with any additional questions.