{"id":6572,"date":"2021-08-16T13:06:23","date_gmt":"2021-08-16T13:06:23","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=ht_kb&#038;p=6572"},"modified":"2024-10-16T09:22:01","modified_gmt":"2024-10-16T09:22:01","slug":"litespeed-cache-database-optimization-settings-in-wordpress","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/litespeed-cache-database-optimization-settings-in-wordpress\/","title":{"rendered":"How to Configure the LiteSpeed Cache Database Optimization Settings in WordPress"},"content":{"rendered":"<p>Your website&#8217;s CSS and Javascript aren&#8217;t the only things you should consider optimizing with the LSCache for WordPress plugin. You should also use its Database optimization features to improve the response time of database queries and more.<\/p>\n<p>In this Knowledge Base article, we will cover how to use the database optimization settings in the LSCache for the WordPress plugin.<\/p>\n<p>Let&#8217;s begin!<\/p>\n<h2 id=\"how-to-configure-the-litespeed-cache-database-optimization-settings-in-wordpress\">How to Configure the LiteSpeed Cache Database Optimization Settings in WordPress<\/h2>\n<p>Step 1: Login to your \/wp-admin and hover over the LiteSpeed Cache area in the menu on the left and when the little menu pops out, click Database.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6574\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10.png\" alt=\"\" width=\"337\" height=\"639\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10.png 631w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10-158x300.png 158w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10-413x783.png 413w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10-26x50.png 26w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10-32x60.png 32w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/1-10-53x100.png 53w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/a>Step 2: When the Database Optimization page loads, you&#8217;ll have a few options, like the ones below:<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6575\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6.png\" alt=\"\" width=\"1369\" height=\"1207\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6.png 1369w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6-300x264.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6-783x690.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6-768x677.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6-50x44.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6-60x53.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/2-6-100x88.png 100w\" sizes=\"auto, (max-width: 1369px) 100vw, 1369px\" \/><\/a><\/p>\n<p>Let&#8217;s explore what each of these options does:<\/p>\n<ul>\n<li>Clean All performs all of the optimizations listed alongside the Clean All button.<\/li>\n<li>Post Revisions deletes all post revisions in your WordPress site.<\/li>\n<li>Auto Drafts deletes all auto-saved drafts from your WordPress site.<\/li>\n<li>Trashed posts delete all trashed posts and pages from your WordPress site.<\/li>\n<li>Spam Comments deletes all comments marked as spam from your WordPress site.<\/li>\n<li>Trashed Comments deletes all trashed comments from your WordPress site.<\/li>\n<li>Trackpacks\/Pingbacks delete all trackbacks and pingbacks from your WordPress site.<\/li>\n<li>Expired Transients deletes all transient options from your WordPress site.<\/li>\n<li>All transients delete all transients from your WordPress site.<\/li>\n<li>Optimize Tables is super helpful and you should run this maybe once or twice a month, depending on how frequently you add content to your website. This optimizes the tables in your database and makes them more readable to WordPress.<\/li>\n<\/ul>\n<p>Next let&#8217;s look at the Database Table Engine Converter, which is below the 10 buttons at the top of the Database page:<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6576\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5.png\" alt=\"\" width=\"1562\" height=\"230\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5.png 1562w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-300x44.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-783x115.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-768x113.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-50x7.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-1536x226.png 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-60x9.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/3-5-100x15.png 100w\" sizes=\"auto, (max-width: 1562px) 100vw, 1562px\" \/><\/a><\/p>\n<p>If you don&#8217;t see any databases here to convert, then there&#8217;s really nothing to do here.<\/p>\n<p>What would appear here are databases that are listed in the MySQL MyISAM format which is much slower than the newer InnoDB format. You would be given the option to convert them to InnoDB from within the WordPress Admin area, which is SUPER handy, let me tell you!<\/p>\n<p class=\"p1\"><b>Exciting News: Introducing Our fastest <\/b><a href=\"https:\/\/chemicloud.com\/managed-wordpress-hosting?utm_source=blog&amp;utm_medium=article#60b65e4e63b58\"><b>WordPress Hosting<\/b><\/a><b> stack <\/b><span class=\"s1\">\ud83d\ude80<\/span><b> Ready for speed? Try it for just $1!<\/b><\/p>\n<p><strong>Next, let&#8217;s look at the Database Summary area at the bottom of the page:<\/strong><\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6577\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6.png\" alt=\"\" width=\"473\" height=\"671\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6.png 845w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6-211x300.png 211w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6-551x783.png 551w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6-768x1091.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6-35x50.png 35w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6-42x60.png 42w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/4-6-70x100.png 70w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/a>The most important thing you want to keep an eye on in Database Summary, and by keeping an eye on, we mean just periodically checking in on, is the autoloads.<\/p>\n<p>You should try to keep the total autoloads below 1 MB, but the best is when it&#8217;s below 500 KB.<\/p>\n<p>Step 3: Return to the top of the page and click the DB Optimizations tab.<\/p>\n<p><a href=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6578\" src=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4.png\" alt=\"\" width=\"1918\" height=\"875\" srcset=\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4.png 1918w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-300x137.png 300w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-783x357.png 783w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-768x350.png 768w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-50x23.png 50w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-1536x701.png 1536w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-60x27.png 60w, https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/08\/5-4-100x46.png 100w\" sizes=\"auto, (max-width: 1918px) 100vw, 1918px\" \/><\/a><\/p>\n<ul>\n<li>For Revisions Max Number, you can set a limit if you find your database is too big and you have too many revisions. For my site, I leave this at 20, but I tend to revise my posts a lot as a perfectionist.<\/li>\n<li>Revisions Max Age is an interesting feature that I don&#8217;t use as sometimes one of your posts can have an issue in a revision and by the time you get to it, the revision has been cleared out by the system.<\/li>\n<\/ul>\n<p>Using the Database Optimization options in the LSCache plugin for WordPress will surely keep your website running smooth and keep your database clean.<\/p>\n<p>We hope you enjoyed this Knowledge Base article. If you have any questions, be sure to open a ticket or Live Chat from your Client Area and we&#8217;ll be happy to help!<\/p>\n<p>\u25b6\ufe0f Please join us in the next tutorial, where we will walk you through the configuration of the <a href=\"https:\/\/chemicloud.com\/kb\/article\/litespeed-cache-page-optimization-settings-in-wordpress\/\">LiteSpeed Cache Page Optimization Settings<\/a> in WordPress<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your website&#8217;s CSS and Javascript aren&#8217;t the only things you should consider optimizing with the LSCache for WordPress plugin. You should also use its Database optimization features to improve the response time of database queries and more. In this Knowledge Base article, we will cover how to use the database&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[191],"ht-kb-tag":[],"class_list":["post-6572","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-website-speed"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/6572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=6572"}],"version-history":[{"count":8,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/6572\/revisions"}],"predecessor-version":[{"id":8472,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/6572\/revisions\/8472"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=6572"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=6572"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=6572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}