{"id":8101,"date":"2026-05-10T15:20:19","date_gmt":"2026-05-10T13:20:19","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=8101"},"modified":"2026-05-10T15:20:20","modified_gmt":"2026-05-10T13:20:20","slug":"optimizarea-bazei-de-date-wordpress-cu-curatatorul-avansat-de-baze-de-date","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/","title":{"rendered":"Optimizarea bazei dvs. de date WordPress cu Advanced Database Cleaner"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">A clean database is a mechanical necessity for a high-performing <strong>mybox-hosted<\/strong> website. Over time, your WordPress database accumulates &#8220;digital clutter&#8221;\u2014old post revisions, trashed comments, orphaned metadata, and expired transients. This bloat increases the size of your database backups and slows down site queries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Advanced Database Cleaner<\/strong> plugin is a professional tool designed to identify and remove this unnecessary data safely.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/#Why_Database_Optimization_Matters\" >Why Database Optimization Matters<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/#Key_Features_of_Advanced_Database_Cleaner\" >Key Features of Advanced Database Cleaner<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/#Step-by-Step_Optimization_Guide\" >Step-by-Step Optimization Guide<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/#Tables_and_Optimization\" >Tables and Optimization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/#Maintenance_Tips_for_mybox_Users\" >Maintenance Tips for mybox Users<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizing-your-wordpress-database-with-advanced-database-cleaner\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Database_Optimization_Matters\"><\/span>Why Database Optimization Matters<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<\/div>\n\n<div id=\"mybox-2204966609\" 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\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/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\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">Your database is the &#8220;brain&#8221; of your website. Every time a visitor loads a page, the server queries the database for content.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Faster Loading:<\/strong> Smaller databases allow the server to find and deliver information more quickly.<\/li>\n\n\n\n<li><strong>Reduced Server Load:<\/strong> Efficient queries use less CPU and RAM on your <strong>mybox<\/strong> account.<\/li>\n\n\n\n<li><strong>Smaller Backups:<\/strong> Removing thousands of old revisions significantly shrinks the size of your daily backups.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Key_Features_of_Advanced_Database_Cleaner\"><\/span>Key Features of Advanced Database Cleaner<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Unlike basic tools, this plugin offers granular control over what you delete:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>General Clean-up:<\/strong> Quickly removes revisions, auto-drafts, trashed posts, and &#8220;spam&#8221; comments.<\/li>\n\n\n\n<li><strong>Orphaned Data Finder:<\/strong> Identifies metadata left behind by plugins you have already uninstalled.<\/li>\n\n\n\n<li><strong>Table Management:<\/strong> Shows you which tables belong to which plugins and allows you to optimize or repair them.<\/li>\n\n\n\n<li><strong>Cron Job Management:<\/strong> Lets you view and delete scheduled tasks that are no longer needed.<\/li>\n\n\n\n<li><strong>Scheduled Optimization:<\/strong> (Pro feature) Automatically cleans the database on a daily or weekly basis.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-by-Step_Optimization_Guide\"><\/span>Step-by-Step Optimization Guide<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. Create a Backup (Mandatory)<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Before performing any database operations, use your <strong>mybox panel<\/strong> to create a full backup. Database cleaning is irreversible.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. Run the General Clean-up<\/h4>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Install and activate the plugin.<\/li>\n\n\n\n<li>Navigate to <strong>WP DB Cleaner > General Clean-up<\/strong>.<\/li>\n\n\n\n<li>Select items like <strong>Revisions<\/strong>, <strong>Old Auto-drafts<\/strong>, and <strong>Trash Comments<\/strong>.<\/li>\n\n\n\n<li>Select &#8220;Clean&#8221; from the bulk actions menu and click <strong>Apply<\/strong>.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">3. Handling Orphaned Metadata<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Plugins often leave &#8220;ghost&#8221; data in your <code>wp_options<\/code> or <code>wp_postmeta<\/code> tables after they are deleted.<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Go to the <strong>Tables<\/strong> or <strong>Options<\/strong> tab.<\/li>\n\n\n\n<li>The plugin will categorize items. Look for those marked as &#8220;Orphaned.&#8221;<\/li>\n\n\n\n<li>Review these carefully; if you are sure the plugin is no longer on your site, delete the associated data.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tables_and_Optimization\"><\/span>Tables and Optimization<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Tables<\/strong> tab provides a view of your physical database structure. You can see the &#8220;overhead&#8221; (wasted space) in each table.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select all tables with overhead.<\/li>\n\n\n\n<li>Choose the <strong>Optimize<\/strong> action.<\/li>\n\n\n\n<li>This defragments the table files on your <strong>mybox<\/strong> server, much like a disk defragmenter on a computer.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Maintenance_Tips_for_mybox_Users\"><\/span>Maintenance Tips for mybox Users<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Don&#8217;t Over-Clean:<\/strong> Cleaning once a month is usually sufficient for most sites. High-traffic blogs or e-commerce stores may benefit from a weekly schedule.<\/li>\n\n\n\n<li><strong>Limit Revisions:<\/strong> To prevent future bloat, consider adding <code>define('WP_POST_REVISIONS', 5);<\/code> to your <code>wp-config.php<\/code>. This limits WordPress to keeping only the last 5 versions of a post.<\/li>\n\n\n\n<li><strong>Monitor Performance:<\/strong> After a major clean-up, check your <strong>analytics<\/strong> and server response times in the <strong>mybox panel<\/strong> to see the impact of the optimization.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Advanced Database Cleaner turns a complex technical task into a simple, manageable process. By regularly purging the &#8220;junk&#8221; from your database, you ensure that your <strong>mybox-hosted<\/strong> WordPress site remains lean, fast, and reliable for your visitors.<\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9],"manual_kb_tag":[361,628,2127,2147,2155,2750,4837,6577,8458,8459,8460,8461,8462],"class_list":["post-8101","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manual_kb_tag-website-performance","manual_kb_tag-wordpress-database","manual_kb_tag-database-backups","manual_kb_tag-database-optimization","manual_kb_tag-table-optimization","manual_kb_tag-database-cleanup","manual_kb_tag-orphaned-metadata","manual_kb_tag-site-speed","manual_kb_tag-advanced-database-cleaner","manual_kb_tag-orphaned-data","manual_kb_tag-site-performance","manual_kb_tag-server-response-times","manual_kb_tag-cron-job-management"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/8101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/8101\/revisions"}],"predecessor-version":[{"id":8102,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/8101\/revisions\/8102"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=8101"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=8101"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=8101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}