{"id":9616,"date":"2023-02-10T10:28:54","date_gmt":"2023-02-10T18:28:54","guid":{"rendered":"https:\/\/codedcommerce.com\/?p=9616"},"modified":"2023-10-13T20:41:24","modified_gmt":"2023-10-14T03:41:24","slug":"database-cleanup-2023","status":"publish","type":"post","link":"https:\/\/codedcommerce.com\/database-cleanup-2023\/","title":{"rendered":"Database Cleanup 2023"},"content":{"rendered":"\n<p class=\"has-drop-cap wp-block-paragraph\">I&#8217;m presenting again on WooCommerce and WordPress database cleanup. This time my presentation is for our <a rel=\"noreferrer noopener\" href=\"https:\/\/www.meetup.com\/woocommerce-los-angeles-meetup\/events\/290839036\/\" data-type=\"URL\" data-id=\"https:\/\/www.meetup.com\/woocommerce-los-angeles-meetup\/events\/290839036\/\" target=\"_blank\">WooCommerce and WordPress Meetup group event<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;ve previously covered this topic in my <a href=\"https:\/\/codedcommerce.com\/wordcamp-los-angeles-2020-presentation-on-database-cleanup\/\" data-type=\"URL\" data-id=\"https:\/\/codedcommerce.com\/wordcamp-los-angeles-2020-presentation-on-database-cleanup\/\">WordCamp Los Angeles 2020 presentation<\/a> and I posted on it in my blog post <a href=\"https:\/\/codedcommerce.com\/cleaning-up-your-woocommerce-database\/\" data-type=\"URL\" data-id=\"https:\/\/codedcommerce.com\/cleaning-up-your-woocommerce-database\/\">Cleaning up your WooCommerce database<\/a>. This is a popular topic with evolving content.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Following is an outline for my 2023 presentation. Please refer to a <a rel=\"noreferrer noopener\" href=\"https:\/\/wpengine.com\/support\/database-optimization-best-practices\/\" data-type=\"URL\" data-id=\"https:\/\/wpengine.com\/support\/database-optimization-best-practices\/\" target=\"_blank\">WP Engine post on WordPress Database Optimization<\/a> for detailed explanations in some areas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pillar One \u2013 WordPress environment cleanups<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-7387b849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\">\n<li>MyISAM to InnoDB table storage engine<\/li>\n\n\n\n<li>Post revisions and auto drafts<\/li>\n\n\n\n<li>Orphaned or duplicated postmeta<\/li>\n\n\n\n<li>Orphaned or duplicated usermeta<\/li>\n\n\n\n<li>Unused terms and relationships<\/li>\n\n\n\n<li>Orphaned or duplicated terms \/ relationships<\/li>\n\n\n\n<li>Unused terms<\/li>\n\n\n\n<li>SPAM comments<\/li>\n\n\n\n<li>Failed orders, old or from CC guessing attacks<\/li>\n\n\n\n<li>Other order status retention policies<\/li>\n\n\n\n<li>Action Scheduler histories<\/li>\n\n\n\n<li>WooCommerce cart sessions<\/li>\n\n\n\n<li>Blog pingbacks and trackbacks<\/li>\n\n\n\n<li>Outdated Media Library items<\/li>\n\n\n\n<li>Outdated navigation menu items<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Open-source plugins to clean these:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\" data-type=\"URL\" data-id=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP Optimize<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wp-sweep\/\" data-type=\"URL\" data-id=\"https:\/\/wordpress.org\/plugins\/wp-sweep\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP Sweep<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wordpress.org\/plugins\/advanced-database-cleaner\/\" data-type=\"URL\" data-id=\"https:\/\/wordpress.org\/plugins\/advanced-database-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">Advanced Database Cleaner<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/wordpress.org\/plugins\/breeze\/\" data-type=\"URL\" data-id=\"https:\/\/wordpress.org\/plugins\/breeze\/\" target=\"_blank\">Breeze by Cloudways<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wp-crontrol\/\" data-type=\"URL\" data-id=\"https:\/\/wordpress.org\/plugins\/wp-crontrol\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP Crontrol<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/wordpress.org\/plugins\/media-cleaner\/\" data-type=\"URL\" data-id=\"https:\/\/wordpress.org\/plugins\/media-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">Media Cleaner<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Pillar Two \u2013 Past experiment cleanups<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Plugin and theme settings<\/li>\n\n\n\n<li>Plugin and theme post types<\/li>\n\n\n\n<li>Plugin and theme custom tables<\/li>\n\n\n\n<li>Theme modifications (WP Customizer) <code>thememods_%<\/code><\/li>\n\n\n\n<li>Block Theme templates, parts, styles, terms \/ relationships<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Pillar Three \u2013 Plugin or hosting bug cleanups<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oversized and\/or autoload <code>wp_options<\/code> settings<\/li>\n\n\n\n<li>Action Scheduler failures and choke-ups<\/li>\n\n\n\n<li>Transients that aren&#8217;t garbage collecting<\/li>\n\n\n\n<li>WooCommerce <code>coupon_data<\/code> oversized order item metadata bug<\/li>\n\n\n\n<li>Earlier Facebook for WooCommerce bug thousands of wp_option rows<\/li>\n\n\n\n<li>Earlier JetPack bug thousands of wp_option rows<\/li>\n\n\n\n<li>WordPress sessions <code>_wp_session_%<\/code> and WP-CRON failures<\/li>\n\n\n\n<li>Theme object caches (Avada example)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m presenting again on WooCommerce and WordPress database cleanup. This time my presentation is for our WooCommerce and WordPress Meetup group event. I&#8217;ve previously covered this topic in my WordCamp Los Angeles 2020 presentation and I posted on it in my blog post Cleaning up your WooCommerce database. This is a popular topic with evolving [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1852,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52047,635716946,635718626],"tags":[],"class_list":["post-9616","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-events","category-wordpress-guides"],"jetpack_featured_media_url":"https:\/\/codedcommerce.com\/wp-content\/uploads\/2019\/02\/kevin-ku-364843-unsplash-scaled.jpg","_links":{"self":[{"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/posts\/9616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/comments?post=9616"}],"version-history":[{"count":0,"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/posts\/9616\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/media\/1852"}],"wp:attachment":[{"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/media?parent=9616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/categories?post=9616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codedcommerce.com\/wp-json\/wp\/v2\/tags?post=9616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}