{"id":1400,"date":"2021-07-26T06:45:20","date_gmt":"2021-07-26T11:45:20","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=1400"},"modified":"2023-03-10T11:07:54","modified_gmt":"2023-03-10T17:07:54","slug":"cleanup-and-optimize-wordpress","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/","title":{"rendered":"How to Clean Up and Optimize WordPress using SQL"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#how_to_clean_up_and_optimize_wordpress_posts_by_removing_specific_post_meta_data\" >How to Clean Up and Optimize WordPress Posts by Removing Specific Post Meta Data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#how_to_clean_up_orphaned_user_meta_in_wordpress\" >How to Clean Up Orphaned User Meta in WordPress?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#how_to_clean_up_transient_entries_in_wordpress_using_sql\" >How to Clean Up Transient Entries in WordPress using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#how_to_clean_up_wordpress_terms_no_longer_in_use_using_sql\" >How to Clean Up WordPress Terms No Longer in Use using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#how_to_clean_up_and_optimize_wordpress_comments_by_removing_comment_agent\" >How to Clean Up and Optimize WordPress Comments by Removing Comment Agent?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#how_to_remove_all_wordpress_pingbacks_using_sql\" >How to Remove All WordPress Pingbacks using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#whats_the_easiest_way_to_optimize_the_wordpress_database_using_sql_or_phpmyadmin\" >What\u2019s the Easiest Way to Optimize the WordPress Database using SQL or phpMyAdmin?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3 class=\"wp-block-heading\" id=\"how_to_clean_up_posts_by_removing_specific_post_meta_in_wordpress\"><span class=\"ez-toc-section\" id=\"how_to_clean_up_and_optimize_wordpress_posts_by_removing_specific_post_meta_data\"><\/span>How to Clean Up and <meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\">Optimize WordPress Posts by Removing Specific Post Meta Data?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you\u2019re uninstalled a plugin or have stopped using a custom field, it could be that you\u2019d like to remove all instances of post metadata relating to a particular meta key. If so:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_postmeta \n  WHERE meta_key = 'somemetakey';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_clean_up_orphaned_user_meta_in_wordpress\"><span class=\"ez-toc-section\" id=\"how_to_clean_up_orphaned_user_meta_in_wordpress\"><\/span>How to Clean Up Orphaned User Meta in WordPress?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Over time, the wp_usermeta table can get large and unwieldy, needing regular cleanup and optimization. Some of the worst offenders can be entries where there\u2019s user metadata not linked to any particular users.<\/p>\n\n\n\n<p>Removal of unlinked user metadata is pretty straightforward:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_usermeta \n  WHERE user_id NOT IN (SELECT ID FROM wp_users);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_clean_up_transient_entries_in_wordpress_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_clean_up_transient_entries_in_wordpress_using_sql\"><\/span>How to Clean Up Transient Entries in WordPress using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There are a number of different ways <a href=\"https:\/\/www.knownhost.com\/wordpress-hosting\">WordPress<\/a> stores cached information in the database, primarily in the wp_options table. Entries include expiration dates that should limit how long the cached information should be active.<\/p>\n\n\n\n<p>However, some transients will get set as non-expiring, and others may not get deleted after their expiration date, leaving considerable bloat in the wp_options table.<\/p>\n\n\n\n<p>When browsing wp_options and looking at option_name entries that mention transient in one form or another, you\u2019ll find that there are variations such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>_site_transient_browser_<\/li>\n\n\n\n<li>_site_transient_timeout_browser_<\/li>\n\n\n\n<li>_transient_feed_<\/li>\n\n\n\n<li>_transient_timeout_feed_<\/li>\n<\/ul>\n\n\n\n<p>These can safely be removed, as the cache will be reloaded upon demand. The question is whether to specify them individually or all in one.<\/p>\n\n\n\n<p><a href=\"https:\/\/sigmaplugin.com\/blog\/what-are-wordpress-dashboard-transient-feeds-and-how-to-clean-them\">From sigmaplugin.com<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM options \n  WHERE option_name LIKE \u2018_site_transient_browser_%\u2019 \n    OR option_name LIKE \u2018_site_transient_timeout_browser_%\u2019 \n    OR option_name LIKE \u2018_transient_feed_%\u2019 \n    OR option_name LIKE \u2018_transient_timeout_feed_%\u2019<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/crunchify.com\/what-are-transient-entries-in-wp-options-table-transient-buildup-information\/\">From crunchify.com:<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_options \n  WHERE option_name LIKE ('%_transient%_%');<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_clean_up_wordpress_terms_no_longer_in_use_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_clean_up_wordpress_terms_no_longer_in_use_using_sql\"><\/span>How to Clean Up WordPress Terms No Longer in Use using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Cleaning up means looking for things unused. Terms without any wp_term_taxonomy entries to accompany them are a candidate for removal as well as their wp_term_relationships when there isn\u2019t a term_taxonomy_id in wp_term_taxonomy.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_terms \n  WHERE term_id IN \n    (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );\n  \n  DELETE FROM wp_term_relationships \n  WHERE term_taxonomy_id not IN \n    (SELECT term_taxonomy_id FROM wp_term_taxonomy);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_clean_up_wordpress_comments_by_removing_comment_agent\"><span class=\"ez-toc-section\" id=\"how_to_clean_up_and_optimize_wordpress_comments_by_removing_comment_agent\"><\/span>How to Clean Up and <meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\">Optimize WordPress Comments by Removing Comment Agent?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There\u2019s a lot of information in the database that you may never need, particularly if you\u2019re not a web developer. For example, the wp_comments table has tucked away the web browser agent of every comment made. That means, even when one user has made many comments, using the same browser, there\u2019s unique entries for each and every comment.<\/p>\n\n\n\n<p>By removing the comment_agent details from the wp_comments table, you\u2019re lightening the load that one extra bit, which isn\u2019t a bad thing for performance!<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_comments \n  SET comment_agent ='';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_remove_all_wordpress_pingbacks_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_remove_all_wordpress_pingbacks_using_sql\"><\/span>How to Remove All WordPress Pingbacks using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you\u2019ve found your posts and database looking a bit spammed with pingbacks, perhaps you\u2019d like to clean them all out at once. In that case, the below SQL will do the trick:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments \n  WHERE comment_type = 'pingback';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_s_the_easiest_way_to_optimize_the_wordpress_database_using_sql_or_phpmyadmin\"><span class=\"ez-toc-section\" id=\"whats_the_easiest_way_to_optimize_the_wordpress_database_using_sql_or_phpmyadmin\"><\/span>What\u2019s the Easiest Way to Optimize the WordPress Database using SQL or phpMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There\u2019s a lot of optimization techniques out there, but here\u2019s the easiest.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the database in phpMyAdmin.<\/li>\n\n\n\n<li>Click the Check All link below the list of tables.<\/li>\n\n\n\n<li>In the dropdown menu, pick Optimize table and click Go.<\/li>\n\n\n\n<li>You should get a success message saying it\u2019s complete.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Have a WordPress website? Check out our <a href=\"https:\/\/www.knownhost.com\/wordpress-hosting\"><strong>Managed Hosting for WordPress<\/strong><\/a> and see if we are a good fit for you. <strong><a href=\"https:\/\/www.knownhost.com\">KnownHost <\/a><\/strong>offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team ready to help you should you need our assistance. You\u2019re not using KnownHost for the best webhosting experience? Well, why not?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Clean Up and Optimize WordPress Posts by Removing Specific Post Meta Data? If you\u2019re uninstalled a plugin or have stopped using a custom field, it could be that you\u2019d like to remove all instances of post metadata relating to a particular meta key. If so: How to Clean Up Orphaned User Meta in [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146],"tags":[251,252,106],"class_list":["post-1400","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-blogs","tag-cms","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Clean Up and Optimize WordPress using SQL - KnownHost<\/title>\n<meta name=\"description\" content=\"In this guide we will show you how to optimize your WordPress website using SQL, so you never keep your customers waiting.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Clean Up and Optimize WordPress using SQL - KnownHost\" \/>\n<meta property=\"og:description\" content=\"In this guide we will show you how to optimize your WordPress website using SQL, so you never keep your customers waiting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-26T11:45:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-10T17:07:54+00:00\" \/>\n<meta name=\"author\" content=\"Jonathan K. W.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan K. W.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/\"},\"author\":{\"name\":\"Jonathan K. W.\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"headline\":\"How to Clean Up and Optimize WordPress using SQL\",\"datePublished\":\"2021-07-26T11:45:20+00:00\",\"dateModified\":\"2023-03-10T17:07:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/\"},\"wordCount\":577,\"keywords\":[\"blogs\",\"cms\",\"wordpress\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/\",\"name\":\"How to Clean Up and Optimize WordPress using SQL - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2021-07-26T11:45:20+00:00\",\"dateModified\":\"2023-03-10T17:07:54+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"description\":\"In this guide we will show you how to optimize your WordPress website using SQL, so you never keep your customers waiting.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/cleanup-and-optimize-wordpress\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Clean Up and Optimize WordPress using SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\",\"name\":\"Jonathan K. W.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"caption\":\"Jonathan K. W.\"},\"sameAs\":[\"https:\\\/\\\/www.knownhost.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Clean Up and Optimize WordPress using SQL - KnownHost","description":"In this guide we will show you how to optimize your WordPress website using SQL, so you never keep your customers waiting.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/","og_locale":"en_US","og_type":"article","og_title":"How to Clean Up and Optimize WordPress using SQL - KnownHost","og_description":"In this guide we will show you how to optimize your WordPress website using SQL, so you never keep your customers waiting.","og_url":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/","og_site_name":"KnownHost","article_published_time":"2021-07-26T11:45:20+00:00","article_modified_time":"2023-03-10T17:07:54+00:00","author":"Jonathan K. W.","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathan K. W.","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/"},"author":{"name":"Jonathan K. W.","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"headline":"How to Clean Up and Optimize WordPress using SQL","datePublished":"2021-07-26T11:45:20+00:00","dateModified":"2023-03-10T17:07:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/"},"wordCount":577,"keywords":["blogs","cms","wordpress"],"articleSection":["WordPress"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/","url":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/","name":"How to Clean Up and Optimize WordPress using SQL - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"datePublished":"2021-07-26T11:45:20+00:00","dateModified":"2023-03-10T17:07:54+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"description":"In this guide we will show you how to optimize your WordPress website using SQL, so you never keep your customers waiting.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/cleanup-and-optimize-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to Clean Up and Optimize WordPress using SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b","name":"Jonathan K. W.","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","caption":"Jonathan K. W."},"sameAs":["https:\/\/www.knownhost.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=1400"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1400\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=1400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=1400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=1400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}