{"id":9778,"date":"2026-06-07T14:50:47","date_gmt":"2026-06-07T12:50:47","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=9778"},"modified":"2026-06-07T14:50:48","modified_gmt":"2026-06-07T12:50:48","slug":"wordpress-optimization-removing-leftover-data-from-deleted-plugins-2","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/","title":{"rendered":"WordPress Optimization &#8211; Removing Leftover Data from Deleted Plugins"},"content":{"rendered":"\n<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">One of WordPress&#8217;s greatest strengths is its extensive plugin ecosystem. Plugins allow you to add new features and functionality without modifying the core system.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">During the development and maintenance of a website, it is common to install, test, and remove various plugins. While most plugins clean up after themselves when uninstalled, some leave configuration settings, cached data, or other records behind in the database.<\/p>\n\n\n\n<\/div>\n\n<div id=\"mybox-268044347\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Early access<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Still need help?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contact our customer service team.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Message us<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">Over time, these unnecessary entries can accumulate and increase the size of the database, potentially affecting performance and making backups larger than necessary.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This guide explains how to identify database entries that may have been left behind by plugins that are no longer in use.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Important<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This guide is intended for users with basic database administration knowledge.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before executing any SQL queries:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a complete database backup.<\/li>\n\n\n\n<li>Verify that you have selected the correct database.<\/li>\n\n\n\n<li>Review all results carefully before deleting any data.<\/li>\n\n\n\n<li>Confirm that your website functions correctly after performing any cleanup operations.<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left 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\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Access_phpMyAdmin\" >Access phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Log_In_to_the_Database\" >Log In to the Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Open_the_SQL_Query_Editor\" >Open the SQL Query Editor<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Search_for_Plugin-Related_Entries\" >Search for Plugin-Related Entries<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Example\" >Example<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Review_the_Results\" >Review the Results<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Removing_Unused_Plugin_Data\" >Removing Unused Plugin Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Benefits_of_Removing_Leftover_Plugin_Data\" >Benefits of Removing Leftover Plugin Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Alternative_Cleanup_Methods\" >Alternative Cleanup Methods<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/wordpress-optimization-removing-leftover-data-from-deleted-plugins-2\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Access_phpMyAdmin\"><\/span>Access phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log in to the mybox Panel.<\/li>\n\n\n\n<li>Navigate to:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Databases\n<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Click:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>phpMyAdmin\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A new browser tab will open with the database login page.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Log_In_to_the_Database\"><\/span>Log In to the Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Use the database credentials associated with your WordPress website.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you do not know the credentials, you can find them in the <code>wp-config.php<\/code> file located in the root directory of your WordPress installation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define('DB_NAME', 'database_name');\ndefine('DB_USER', 'database_user');\ndefine('DB_PASSWORD', 'database_password');\ndefine('DB_HOST', 'database_host');\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">By default, the file is located in:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>public_html\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Open_the_SQL_Query_Editor\"><\/span>Open the SQL Query Editor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After logging in:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select your WordPress database from the left-hand menu.<\/li>\n\n\n\n<li>Click the:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">tab located at the top of the page.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This will open the SQL query editor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Search_for_Plugin-Related_Entries\"><\/span>Search for Plugin-Related Entries<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before removing any data, identify records that belong to the plugin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Run the following query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM `wp_options`\nWHERE `autoload` = 'yes'\nAND `option_name` LIKE '%plugin-name%'\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Replace:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>plugin-name\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">with a keyword related to the plugin you previously removed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Example\"><\/span>Example<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to search for settings left behind by the Disqus plugin, use:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM `wp_options`\nWHERE `autoload` = 'yes'\nAND `option_name` LIKE '%disqus%'\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Click:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Execute\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">to run the query.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Review_the_Results\"><\/span>Review the Results<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The query will display records stored in the <code>wp_options<\/code> table that match the specified keyword.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before deleting anything:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verify that the records belong to the removed plugin.<\/li>\n\n\n\n<li>Confirm that the plugin is no longer installed.<\/li>\n\n\n\n<li>Ensure that no active plugin uses the same settings.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Carefully reviewing the results helps prevent accidental removal of data required by your website.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Removing_Unused_Plugin_Data\"><\/span>Removing Unused Plugin Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After confirming that the records belong to a deleted plugin and are no longer needed, you can remove them using a DELETE query.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE\nFROM `wp_options`\nWHERE `option_name` LIKE '%disqus%'\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Warning<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Always review the results returned by the SELECT query before executing any DELETE statements.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Benefits_of_Removing_Leftover_Plugin_Data\"><\/span>Benefits of Removing Leftover Plugin Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cleaning up obsolete plugin records can provide several benefits:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reduced database size.<\/li>\n\n\n\n<li>Faster database backups.<\/li>\n\n\n\n<li>Improved database performance.<\/li>\n\n\n\n<li>Reduced autoloaded data.<\/li>\n\n\n\n<li>Better overall WordPress efficiency.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The benefits are especially noticeable on websites that:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Have been running for several years.<\/li>\n\n\n\n<li>Frequently install and remove plugins.<\/li>\n\n\n\n<li>Have undergone multiple redesigns or migrations.<\/li>\n\n\n\n<li>Use a large number of extensions.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Alternative_Cleanup_Methods\"><\/span>Alternative Cleanup Methods<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you prefer not to work directly with SQL queries, several WordPress optimization plugins can help identify and remove orphaned plugin data, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WP-Optimize<\/li>\n\n\n\n<li>Advanced Database Cleaner<\/li>\n\n\n\n<li>LiteSpeed Cache<\/li>\n\n\n\n<li>WP Rocket<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Always review suggested changes before confirming any cleanup operation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Some WordPress plugins leave configuration data behind even after being removed. Over time, these unused records can contribute to database bloat and reduced performance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To identify leftover plugin data:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open phpMyAdmin.<\/li>\n\n\n\n<li>Select your WordPress database.<\/li>\n\n\n\n<li>Open the SQL tab.<\/li>\n\n\n\n<li>Run:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM `wp_options`\nWHERE `autoload` = 'yes'\nAND `option_name` LIKE '%plugin-name%'\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Replace <code>plugin-name<\/code> with a keyword associated with the plugin you want to investigate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before deleting any records, always create a database backup and verify that the entries are no longer required by your website.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[58],"manual_kb_tag":[190,389,487,2147,2159,2750,4828,4829,4830,4831],"class_list":["post-9778","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-web-applications-cms","manual_kb_tag-wordpress","manual_kb_tag-database-backup","manual_kb_tag-wordpress-plugins","manual_kb_tag-database-optimization","manual_kb_tag-optimize-database","manual_kb_tag-database-cleanup","manual_kb_tag-plugin-cleanup","manual_kb_tag-remove-plugin-data","manual_kb_tag-leftover-plugin-data","manual_kb_tag-database-performance"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/9778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/9778\/revisions"}],"predecessor-version":[{"id":9779,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/9778\/revisions\/9779"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=9778"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=9778"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=9778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}