![\"\"](\"https:\/\/lswp.store\/wp-content\/uploads\/2017\/09\/null-7.jpeg\" "\\"\\"")
<\/p>\n<\/p>\n
Welcome to another installment of WordPress Wednesday<\/a>!<\/p>\n We\u2019re on quite a roll lately, with all of the new functionality being introduced into our cache plugin<\/a>. But don\u2019t worry if you haven\u2019t had a chance to figure it all out yet. That\u2019s why I\u2019m here! Today, allow me to be your guide through Database Optimization.<\/strong><\/p>\n Disclaimer<\/strong>: The information contained in this post is accurate for LSCWP v7.2 [release log<\/a>]. If you are using a newer version of the plugin, some details may have changed. Please\u00a0refer to our documentation<\/a>\u00a0for the latest!<\/em><\/p>\n From your WordPress Dashboard, navigate to LiteSpeed Cache > Database<\/strong>. You\u2019ll notice some icons and buttons, and you may also notice that the page has been split up into two tabs: Manage <\/b>and DB Optimization Settings<\/strong>.<\/p>\n Database optimization is a useful tool when it comes to speeding up your site. We\u2019ve included it here because there\u2019s nothing we love more than an accelerated internet! This is one of many such \u201cextras\u201d we\u2019ve adding to the plugin.<\/p>\n Our DB Optimizer gives you an easy way to keep your WordPress database slim, trim, and as efficient as possible.<\/p>\n A word of caution:<\/strong> as with most tools of this nature, it is a good idea to have a current backup of your database before you begin pressing buttons!<\/p>\n So let\u2019s take a look at each of those buttons and see what they do.<\/p>\n This button is for the site admin in a rush. It allows you to clean up everything at once by executing all of the other cleanup buttons with a single click.<\/p>\n NOTE: Optimize Tables<\/strong>\u00a0is different than the other buttons, so it\u2019s not included in Clean All<\/strong>. Its functionality is explained in more detail below.<\/p>\n When you edit an existing post, WordPress saves a copy of the original version, just in case you make a mistake and need to revert back. If you edit the post 8 times, you will have 8 revisions saved. That\u2019s 8 full copies of the post, each just a little bit different than the others. This button removes all but the most recent revision from the database.<\/p>\n The Post Revisions<\/strong> button has the potential to free up a considerable amount of space, if you are prone to frequent edits. Just be aware that you will sacrifice your ability to ever restore old versions of posts. This is a sacrifice that most site owners can easily live with, though.<\/p>\n If you’ve deleted posts in the past, there is a chance that some metadata records from those posts remain. This button cleans them up.<\/p>\n When you create or edit a post, WordPress automatically saves drafts now and then. This is to protect you in case you unexpectedly lose your connection, or your computer crashes. If you know that all of your posts are either published or saved correctly as drafts, then it is safe to press this button and remove the automatic drafts.<\/p>\n If you\u2019ve put a post or page into the trash, then that\u2019s a pretty good sign that you don\u2019t need it anymore. Press this button to permanently empty that garbage can.<\/p>\n There should be no need to keep comments that have been marked as spam. Press this button to erase them once and for all.<\/p>\n Trashed comments, too, take up space. Press this button to permanently delete them.<\/p>\n When other blogs link to you (or when you link back to other posts on your own blog), it can create trackbacks or pingbacks. These are stored as comments and can be seen in the Comments<\/strong> section of your WordPress Admin. Additionally, some themes display trackbacks and pingbacks in among the comments on a post. If keeping a record of these external (and internal) links is not important to you, press this button to clear them from the database.<\/p>\n Transients are the result of a form of caching that can happen in the WordPress database with the results of remote API calls. This option clears all of the expired transients from the database.<\/p>\n This option clears all<\/em> of the transients in the database, whether expired or not.<\/p>\n This button is different than the others. It\u2019s the cleanup after the cleanup, if you will. When you delete large amounts of information from your database, it leaves gaps. The Optimize Tables<\/strong> button reclaims that disk space and reorganizes the table indexes for better efficiency. It\u2019s a useful last step once you\u2019ve done all you care to with the other buttons.<\/p>\n Keeping your database clean and free of trash is a great way to keep your WordPress site running efficiently. We hope you\u2019ll give the new DB Optimizer tab a try! Be sure to let us know if you have any questions, or any suggestions for future enhancements. We\u2019d love to hear from you!<\/p>\n Be sure to meet us back here next week to talk about more LSCWP features!<\/p>\n — Don\u2019t forget to meet us back here next week for the next installment. In the meantime, here are a few other things you can do:<\/p>\nManage<\/h2>\n
![\"Database](\"https:\/\/lswp.store\/wp-content\/uploads\/2017\/09\/DBOpt-1024x630.png\")
\nYou’ll notice that some of the buttons have green check-marks while others have red X’s. The check marks indicate that the area has already been cleaned-up. If you see a red X, it is an indication that you have an opportunity to do some optimization.<\/p>\nClean All<\/h3>\n
Post Revisions<\/h3>\n
Orphaned Post Meta<\/h3>\n
Auto Drafts<\/h3>\n
Trashed Posts<\/h3>\n
Spam Comments<\/h3>\n
Trashed Comments<\/h3>\n
Trackbacks & Pingbacks<\/h3>\n
Expired Transients<\/h3>\n
All Transients<\/h3>\n
Optimize Tables<\/h3>\n
![\"\"](\"https:\/\/lswp.store\/wp-content\/uploads\/2017\/09\/null-8.jpeg\" "\\"\\"")
<\/p>\n
\nHave some of your own ideas for future WordPress Wednesday<\/a> topics? Leave us a comment!<\/p>\n