MySQL database is the back-end of many online web applications. WordPress users might've seen this in their c-panel but only a few does knew the use of it.
Optimizing MySQL database can greatly influence the overall size of your database, thus reducing the effect on your WordPress blog loading time. Once optimized, one of my blog's database went from 100MB to 15MB.
Does Optimizing the MySQL database deletes my data?
Its absolutely false! Optimization doesn't really delete any data. It is simply like De-fragmenting a database. With the database growing old, data gets deleted and added resulting in number of empty rows.
Although the rows are empty, they still contribute to overall size of the MySQL database and so optimizing the MySQL database helps in deletion of "overhead" (i.e., empty rows) and the data will be arranged well in your database.
How to Optimize and Reduce Size of MySQL Database?
- Go to your cpanel > phpMyAdmin.
- Select your WordPress database file associated with your blog (in particular).
- Select all the tables and click "Export" (backup your database. Just in case).
- Again select all your tables and click on the drop-down menu with label "with selected" at the bottom.
- From the drop-down menu, select "optimize table".

- That's it! Your MySQL database is well-optimized now.





















To speed up the task and reduce personal intervention, there is a small hack which allows us to empty the trash automatically without having to do it manually each time.

