Optimizing your WordPress Database in phpMyadmin
After using WordPress for a while your database becomes fragmented. Because over time memory overheads which increases your overall database size and query execution time. You can see it in the right column when looking at your database.
Optimization means clearing up this data and should be done regularly. Optimizing your database with phpMyadmin is really easy:
- Access the database you want to optimize. Click on the “check all” box at the bottom of the screen to mark all tables within that database.
- Use the drop-down menu on the right to select “Optimize table”.
- Depending on your version of phpMyadmin you might have to click on “Go” to start the optimization process.
Done! This will optimize your WordPress tables by defragmenting tables. It will make your WordPress queries run a little faster and slightly reduce the size of your database.
CHECKING AND REPAIRING TABLES
Sometimes tables will crash. It’s not pretty and might result in all of your posts or drafts disappearing or cause some other kind of mayhem. However, oftentimes phpMyadmin can repair the table and everything will go back to normal.
If something is amiss on your website, you might first to check if any of the tables in your database is at fault:
- Open the database in question.
- Select all tables by clicking on “check all” at the bottom of the screen.
- Use the drop-down menu to choose “check table”. You might also have to click the “Go” button at the bottom to start the process.
phpMyAdmin will show a page with the results. In the right column you will be able to see if your tables are deemed OK or not.Should any of theme exhibit a problem, repairing it is just as easy as optimizing:
- Mark the tables that needs to be repaired by checking their boxes.
- From the drop-down menu, choose “Repair table” to start the process. Alternatively, you might have to click on “Go” to get it going.
Renaming Your Database
Should you ever need to rename your database, that is entirely within the scope of phpMyAdmin. You can find that option under “Operations” while viewing your database. If you do rename it, make sure the data within your website’s wp-config.php gets updated accordingly.