Generated by All in One SEO v4.9.0, this is an llms.txt file, used by LLMs to index the site. # SigmaPlugin Build better websites with our intuitive WordPress plugins ## Sitemaps - [XML Sitemap](https://sigmaplugin.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [What are WordPress trashed comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-trashed-comments-and-how-to-clean-them/) - What are trashed comments? When you delete a comment in WordPress, it isn’t removed immediately. Instead, it’s moved to the trash so you can restore it later if needed. Over time, these trashed comments can accumulate in your database, especially on websites with active discussions or heavy spam activity. How they affect your database? Trashed - [What are duplicated commentmeta and how to clean them?](https://sigmaplugin.com/blog/what-are-duplicated-commentmeta-and-how-to-clean-them/) - What are duplicated commentmeta? Each comment in WordPress can have metadata, known as commentmeta, which stores additional information added by plugins or themes, such as ratings, flags, or custom comment settings. Duplicated commentmeta entries occur when multiple rows share the same comment_id and meta_key, often due to plugin conflicts or redundant saves. How they affect - [What are duplicated postmeta and how to clean them?](https://sigmaplugin.com/blog/what-are-duplicated-postmeta-and-how-to-clean-them/) - What are duplicated postmeta? Each post in WordPress can have metadata, known as postmeta, which stores additional information such as SEO data, custom fields, or plugin-related settings. Duplicated postmeta entries occur when multiple rows in the wp_postmeta table have the same meta_key and post_id. These duplicates often result from poorly coded plugins or repeated saves - [What are WordPress unapproved comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-unapproved-comments-and-how-to-clean-them/) - What are unapproved comments? Unapproved comments are those awaiting moderation in WordPress. When visitors submit a comment, it may be held for review before being published. If not regularly moderated, these pending comments can accumulate over time, especially on busy websites. How they affect your database? Unapproved comments are stored in the wp_comments table with - [What are WordPress trashed posts and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-trashed-posts-and-how-to-clean-them/) - What are trashed posts? When you delete a post, page, or any custom post type in WordPress, it isn’t permanently removed right away. Instead, it’s moved to the trash, allowing you to restore it later if needed. Over time, these trashed posts can build up in your database, especially if you frequently delete old or - [Major Changes in the New Advanced Database Cleaner 4.0.0](https://sigmaplugin.com/blog/major-changes-in-the-new-advanced-database-cleaner-4-0-0/) - After more than ten years of continuous service, Advanced Database Cleaner is entering a new era. Version 4.0.0 is not just an update - it’s an entirely new plugin, rebuilt from the ground up with a modern architecture, smarter modules, and a more sustainable model for the future. Below, we’ll explain why we took this - [What are unused commentmeta and how to clean them?](https://sigmaplugin.com/blog/what-are-unused-commentmeta-and-how-to-clean-them/) - What are unused commentmeta? WordPress stores comment-related metadata in the wp_commentmeta table. These data entries contain additional details added by plugins or themes, such as ratings, flags, or moderation notes. When comments are deleted or a plugin is removed, some commentmeta entries can remain in the database without a valid parent comment - these are - [What are unused usermeta and how to clean them?](https://sigmaplugin.com/blog/what-are-unused-usermeta-and-how-to-clean-them/) - What are unused usermeta? User metadata, stored in the wp_usermeta table, holds additional data for each user account such as roles, preferences, and plugin settings. Over time, when users are deleted or plugins stop using certain meta keys, leftover usermeta entries can remain in the database even though they no longer belong to any existing - [How to clean Action Scheduler data (actions and logs) in Advanced Database Cleaner Premium](https://sigmaplugin.com/blog/how-to-clean-action-scheduler-data-actions-and-logs-in-advanced-database-cleaner-premium/) - What is Action Scheduler data? The Action Scheduler is a background task system used by plugins such as WooCommerce to manage automated jobs, like sending emails, syncing data, or processing background events. Over time, thousands of completed, failed, or canceled tasks (and their logs) can accumulate and inflate your database. All these items can be - [What are “tables to optimize” and how to clean them?](https://sigmaplugin.com/blog/what-are-tables-to-optimize-and-how-to-clean-them/) - What are “tables to optimize”? As your site runs, database tables accumulate overhead (fragmented free space) from inserts, updates, and deletes. “Tables to optimize” are tables with measurable overhead that can be reclaimed to reduce size and improve I/O efficiency. Optimizing them reorganizes storage and updates table statistics. How they affect your database? Overhead makes - [What are expired transients and how to clean them?](https://sigmaplugin.com/blog/what-are-expired-transients-and-how-to-clean-them/) - What are expired transients? Transients are temporary pieces of data stored by WordPress, plugins, or themes to cache information and speed up performance. They are usually saved in the wp_options table, but in multisite installations, network-level transients are stored in the wp_sitemeta table instead. Each transient has an expiration time after which it should be - [What are WordPress revisions and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-revisions-how-to-clean-them/) - What are revisions? Each time you update or save a post or a page, WordPress automatically creates a new revision to store the previous version of your content. These revisions allow you to restore older versions of your post when needed, but over time, they can accumulate in large numbers, especially on active websites with - [What are WordPress auto drafts and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-auto-drafts-how-to-clean-them/) - What are auto drafts? WordPress automatically creates an auto draft when you start writing a new post or page but haven’t saved or published it yet. These temporary entries help you recover content if you close the editor or lose connection before saving. After you publish the post (or save a regular draft), these auto-draft - [What are WordPress pingbacks and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-pingbacks-how-to-clean-them/) - What are pingbacks? Pingbacks are automatic notifications that WordPress sends when another site links to your content. Similarly, your site receives pingbacks when other WordPress sites reference your posts. Although useful for networking, they can often be spammy and unnecessary. How they affect your database? Pingbacks are stored as entries in the wp_comments table with - [What are WordPress trackbacks and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-trackbacks-how-to-clean-them/) - What are trackbacks? Trackbacks are a legacy system that allows other blogs to notify you when they link to your content. Although similar to pingbacks, trackbacks are manually created by the sender and are often used by spammers. Modern WordPress sites rarely use them today. How they affect your database? Trackbacks are stored in the - [What are WordPress spam comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-spam-comments-how-to-clean-them/) - What are spam comments? Spam comments are unwanted or irrelevant comments automatically filtered or manually marked as spam in WordPress. They’re often generated by bots or spammers and can quickly accumulate, especially on popular websites that allow commenting. How they affect your database? Spam comments are stored in the wp_comments table with the status spam. - [What are “tables to repair” and how to clean them?](https://sigmaplugin.com/blog/what-are-tables-to-repair-and-how-to-clean-them/) - What are “tables to repair”? Tables can become inconsistent due to abrupt server restarts, storage issues, or plugin crashes. “Tables to repair” are tables that report errors when checked. Repairing attempts to fix index or data inconsistencies so the table can be read and written safely again. How they affect your database? Corrupted or inconsistent - [What are WordPress spam comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-spam-comments-and-how-to-clean-them-2/) - What are spam comments? Spam comments are unwanted or irrelevant comments automatically filtered or manually marked as spam in WordPress. They’re often generated by bots or spammers and can quickly accumulate, especially on popular websites that allow commenting. How they affect your database? Spam comments are stored in the wp_comments table with the status spam. - [What are unused relationships and how to clean them?](https://sigmaplugin.com/blog/what-are-unused-relationships-and-how-to-clean-them/) - What are unused relationships? WordPress stores the connections between posts and taxonomy terms (like categories or tags) in the wp_term_relationships table. Sometimes, when posts or taxonomies are deleted, their relationships remain in this table even though they no longer point to any valid post or term. These are called unused relationships. How they affect your - [What are oEmbed caches and how to clean them?](https://sigmaplugin.com/blog/what-are-oembed-caches-and-how-to-clean-them/) - What are oEmbed caches? When you embed external media like YouTube videos, tweets, or Instagram posts in WordPress, the platform creates cached data called oEmbed caches to load these embeds faster. These cached responses are stored as post metadata in the wp_postmeta table using keys like _oembed_* and _oembed_time_*. How they affect your database? Over - [What are unused termmeta and how to clean them?](https://sigmaplugin.com/blog/what-are-unused-termmeta-and-how-to-clean-them/) - What are unused termmeta? WordPress stores metadata for categories, tags, and custom taxonomies in the wp_termmeta table. Unused termmeta entries occur when a term (like a category or tag) is deleted, but its associated metadata remains in the database. This often happens when plugins or themes that use termmeta are uninstalled or updated incorrectly. How - [What are unused postmeta and how to clean them?](https://sigmaplugin.com/blog/what-are-unused-postmeta-and-how-to-clean-them/) - What are unused postmeta? Each post in WordPress can store metadata in the wp_postmeta table. These metadata entries contain extra information such as SEO settings, layout preferences, or plugin data. Over time, when plugins or themes are removed or stop using certain meta keys, they leave behind unused postmeta entries that no longer serve any - [What are duplicated termmeta and how to clean them?](https://sigmaplugin.com/blog/what-are-duplicated-termmeta-and-how-to-clean-them/) - What are duplicated termmeta? WordPress terms, such as categories and tags, can store metadata in the wp_termmeta table. Duplicated termmeta entries occur when multiple rows share the same term_id and meta_key, often created by plugins that improperly save taxonomy-related data multiple times. How they affect your database? Duplicated records in the wp_termmeta table waste database - [What are duplicated usermeta and how to clean them?](https://sigmaplugin.com/blog/what-are-duplicated-usermeta-and-how-to-clean-them/) - What are duplicated usermeta? User metadata, or usermeta, stores additional information for each user account, such as preferences, roles, and plugin-related settings. Duplicated usermeta entries appear when multiple rows in the wp_usermeta table share the same user_id and meta_key, often caused by plugins writing the same data repeatedly. How they affect your database? Duplicated usermeta - [What’s New in Advanced Database Cleaner 4.0.0 - Full Tour](https://sigmaplugin.com/blog/whats-new-in-advanced-database-cleaner-4-0-0-full-tour/) - Sommaire General Cleanup Tables Management Options Management Post Meta Management User Meta Management Transients Management Cron Jobs Management Automation Remote Scan Database Analytics Addons Activity Infos & Logs Introduction Version 4.0.0 of Advanced Database Cleaner marks a major evolution of the plugin. Internally, the architecture was rebuilt to be more modular, more stable, and easier - [How to increase your PHP Max Execution Time in case of a timeout error](https://sigmaplugin.com/blog/increase-your-php-max-execution-time/) - When executing PHP scripts that manipulate large amounts of data, such as exporting/importing a large database, processing a big number of files, etc. timeout errors may occur. Most hosting companies set the max execution time to 30 or 60 seconds. PHP will end scripts and you will get error messages such as “Maximum execution time - [Create a new WordPress admin user using phpMyAdmin](https://sigmaplugin.com/blog/create-new-wordpress-admin-user/) - Have you ever found yourself locked out of your WordPress admin panel? Whether due to a forgotten password or an unexpected website issue, losing access can be frustrating. Fortunately, there's a reliable workaround: creating a new admin user directly in your site's database using phpMyAdmin. This guide will walk you through each step. Step 1: - [How to delete a specific table from your WordPress Database](https://sigmaplugin.com/blog/delete-tables-from-wordpress-database/) - When you are using WordPress, it arrives that you need to delete a specific table from your database. For example, to completely delete Yoast plugin traces (after uninstalling it via FTP), you will need to delete some tables such as "yoast_indexable", "yoast_indexable_hierarchy", "yoast_migrations", etc. As it is reported here. (Make sure to back up your - [Changelog - Advanced Database Cleaner](https://sigmaplugin.com/docs-advanced-db-cleaner/changelog/) - The changelog has been moved to: https://docs.sigmaplugin.com/article/41-adbc-pro-changelog - [What are WordPress spam comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-spam-comments-and-how-to-clean-them/) - A WordPress spam comment is a comment that you (or a plugin like Akismet) have marked as spam. You can either use our plugin Advanced Database Cleaner to clean-up these spam comments or execute the following SQL code (which is used by the plugin) directly via your phpMyAdmin: DELETE FROM comments WHERE comment_approved = 'spam' - [How To Speed Up Your WordPress Website](https://sigmaplugin.com/blog/how-to-speed-up-your-wordpress-website/) - Are you making every effort to squeeze the best possible performance from your WordPress website? It might be decent, and it may even be above-average, but that doesn’t mean it’s fast enough for its visitors — and even if it is today, that might change in the coming years. It’s all due to massive improvements - [What does mean "clean my WordPress database"?](https://sigmaplugin.com/blog/what-does-mean-clean-my-wordpress-database/) - As you use WordPress, your database accumulates a lot of extra data such as revisions, spam comments, trashed comments, transients, etc. that make your site sluggish and bloated. Cleaning your WordPress database consists of removing this unnecessary data. This operation will reduce the size of your database and improve efficiency when accessing tables. In addition, - [Is it safe to clean-up my WordPress database?](https://sigmaplugin.com/blog/is-it-safe-to-clean-up-my-wordpress-database/) - It is always safe to clean-up your WordPress database if you use the appropriate tools. Our plugin Advanced Database Cleaner does not run any code that can break down your site or delete your posts, pages, comments, etc. However, either by using our plugin or other ones, we advise you to always make a database - [What does mean "Optimize my WordPress database"?](https://sigmaplugin.com/blog/what-does-mean-optimize-my-wordpress-database/) - Optimizing your WordPress database will reclaim unused space in your tables, which will reduce storage space and improve efficiency when accessing tables. Optimizing the database can sometimes significantly improve performance, particularly on sites that receive a lot of traffic or have a large amount of content. Moreover, optimizing your database is absolutely safe. Use our - [Is it safe to clean orphan WordPress scheduled tasks?](https://sigmaplugin.com/blog/is-it-safe-to-clean-orphan-wordpress-scheduled-tasks/) - A scheduled task enables plugins to execute some actions at specified times, without having to manually execute code at that time. WordPress itself uses some scheduled tasks to perform some regular actions. However, some scheduled tasks may not be removed even if the responsible plugins are deleted from your WordPress installation. As you know, not - [What are WordPress revisions and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-revisions-and-how-to-clean-them/) - WordPress stores a record called revision of each saved draft or published update. This system allows you to see what changes were made in each post and page over time. However, as you use WordPress, this can lead to a lot of unnecessary overhead in your WordPress database, which consumes a lot of space and - [What are WordPress drafts and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-drafts-and-how-to-clean-them/) - WordPress allows you to save a post or a page without having to publish it immediately. This way you can work on it as much as you want and publish it only when it is ready. This is called a WordPress draft. Over time, you could have multiple drafts that you will never publish and - [What are WordPress auto-drafts and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-auto-drafts-and-how-to-clean-them/) - WordPress automatically saves your post (or page) while you are editing it. This is called WordPress auto-draft. If you don't hit the publish/update button, then the post/page will be saved as auto-draft and any modification to your post/page will not be visible in your public site. Over time, you could have multiple auto-drafts that you - [What are WordPress pending comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-pending-comments-and-how-to-clean-them/) - Pending comments are comments published by users and which are waiting for your approval before appearing in your site. In some cases, you will have to clean all these comments. You can either use our plugin Advanced Database Cleaner to clean-up these comments or execute the following SQL code (which is used by the plugin) - [What are WordPress trash comments and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-trash-comments-and-how-to-clean-them/) - A trash comment is a comment that you have deleted from your WordPress site and have been moved to the trash. A trash comment is not visible in your site and should be deleted forever. You can either use our plugin Advanced Database Cleaner to clean-up these trash comments or execute the following SQL code - [What are WordPress orphan relationships and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-orphan-relationships-and-how-to-clean-them/) - Sometimes the 'wp_term_relationships' table becomes bloated with many orphaned relationships. This happens particularly often if you’re using your site not as a blog but as some other type of content site where posts are deleted periodically. Over time, you could get thousands of term relationships for posts that no longer exist which consumes a lot - [What are WordPress dashboard transient feeds and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-dashboard-transient-feeds-and-how-to-clean-them/) - A transient is a way for storing cached data temporarily in your database by giving it a name and a timeframe after which it will expire and be deleted. To clean this dashboard transient feeds, you can either use our plugin Advanced Database Cleaner or execute the following SQL code (which is used by the - [What are WordPress orphan comments meta and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-orphan-comments-meta-and-how-to-clean-them/) - The comment metadata is the information you provide to viewers about each comment. This information usually includes the author of the comment, when it was written (or posted), etc. In some cases, some comment metadata information becomes orphan and does not belong to any comment. They are then called "orphan comment meta" and should be - [How to activate the pro version of the Advanced Database Cleaner plugin](https://sigmaplugin.com/blog/how-to-activate-the-pro-version-of-advanced-database-cleaner-plugin/) - After purchasing the plugin you will receive automatically a purchase receipt containing your license key and download link to download the pro version of the plugin. In general, there are 2 ways to install the pro version of the "ADC" plugin: = 1. Via uploading the plugin to the WordPress dashboard = 1. Download the pro version - [What are WordPress trash posts and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-trash-posts-and-how-to-clean-them/) - A trash post is a post that you have deleted from your WordPress site and have been moved to the trash. A trash post is not visible in your site and should be deleted since it is not used. You can either use our plugin Advanced Database Cleaner to clean-up these trash posts or execute - [What are WordPress pingbacks and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-pingbacks-and-how-to-clean-them/) - Pingbacks allow you to notify other website owners that you have linked to their article on your website. Pingbacks were designed to solve some of the problems that people saw with trackbacks. Although there are some minor technical differences, a trackback is basically the same things as a pingback. Read more These pingbacks can be - [What are WordPress trackbacks and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-trackbacks-and-how-to-clean-them/) - Trackbacks allow you to notify other website owners that you have linked to their article on your website. Read more These trackbacks can be used to send huge amounts of spam. Spammers use them to get their links posted on as many sites as possible. That is why they should be deactivated/cleaned if you do - [What are WordPress orphaned user meta and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-orphaned-user-meta-and-how-to-clean-them/) - The user metadata is the information you provide to viewers about each user. This information usually includes additional data that is not stored in the users' table of WordPress. In some cases, some user metadata information become orphaned and does not belong to any user. They are then called "orphaned user meta" and should be - [What are WordPress orphaned term meta and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-orphaned-term-meta-and-how-to-clean-them/) - The term metadata is the information that is provided for each taxonomy term. This information usually includes additional data that is not stored in the terms table of WordPress. In some cases, some term metadata information becomes orphaned and does not belong to any taxonomy term. They are then called "orphaned term meta" and should - [What are WordPress transients?](https://sigmaplugin.com/blog/what-are-wordpress-transients/) - Transients are a way of storing cached data in the WordPress DB temporarily by giving it a name and a time frame after which it will expire and be deleted. This helps improve WordPress performance and speed up your website while reducing the overall server load. Transients housekeeping is now part of WordPress core, as - [Restore pro version after upgrade to 3.0.0](https://sigmaplugin.com/blog/restore-pro-version-after-upgrade-to-3-0-0/) - (This post concerns PRO users who lost their premium versions after upgrading to version 3.0.0 from an old version of the "Advanced DB Cleaner" plugin. New customers who have directly installed the version 3.0.0 or higher are not affected by this issue) If you have installed a version lower than 3.0.0 then upgraded to 3.0.0, you will - [How to get access to my account and downloads](https://sigmaplugin.com/blog/how-to-get-access-to-my-account-and-downloads/) - After purchasing one of our plugins, you can get access to your account so you can view your purchase history, downloads, manage licenses, generate an invoice, etc. There are two possible cases: If you have purchased one of our plugins and created an account at checkout, just login here and you will be redirected to - [4 Things That May Be Slowing Your WordPress Site Down](https://sigmaplugin.com/blog/4-things-that-may-be-slowing-your-wordpress-site-down/) - WordPress may be a free CMS simple enough for beginners to use, but that doesn’t mean it isn’t an excellent option for business-level sites. Configured and maintained well, it can do an excellent job as the foundation for your site — so if you’ve noticed that your site is struggling along, you can’t blame it - [What are WordPress orphan posts meta and how to clean them?](https://sigmaplugin.com/blog/what-are-wordpress-orphan-posts-meta-and-how-to-clean-them/) - The post metadata is the information you provide to viewers about each post. This information usually includes the author of the post, when it was written (or posted), and how the author categorized that particular post. In some cases, some post metadata information becomes orphan and do not belong to any post. They are then ## Pages - [Home page](https://sigmaplugin.com/) - [Refund policy](https://sigmaplugin.com/refund-policy/) - Last updated: November 27, 2025 At SigmaPlugin, we want you to feel confident when purchasing our WordPress plugins.We stand behind the quality of our products and offer a 100% risk-free, 30-day money-back guarantee - no questions asked. If you are not fully satisfied with your purchase for any reason, simply request a refund within 30 - [Terms of Use](https://sigmaplugin.com/terms-of-use/) - Last updated: November 27, 2025 Welcome to SigmaPlugin.com.By accessing or purchasing from our website, you agree to the following Terms & Conditions.If you do not agree, please do not use our website or products. 1. Definitions “We”, “Us”, “Our” – SigmaPlugin “Website” – sigmaplugin.com “Plugins” – our WordPress products and software “User”, “Customer”, “You” – - [Privacy policy](https://sigmaplugin.com/privacy-policy/) - Last updated: November 27, 2025 At SigmaPlugin (“we”, “us”, “our”), we respect your privacy and are committed to protecting your personal data.This Privacy Policy explains how we collect, use, and safeguard information when you visit sigmaplugin.com, purchase our products, or contact our support team. 1. Information We Collect We collect different types of information depending - [Cookie Policy](https://sigmaplugin.com/cookie-policy/) - Last updated: November 27, 2025 This Cookie Policy explains how SigmaPlugin (“we”, “us”, or “our”) uses cookies and similar tracking technologies on sigmaplugin.com and related pages.By using our website, you agree to the use of cookies as described in this policy. 1. What Are Cookies? Cookies are small text files stored on your device when - [Affiliate Terms of Use](https://sigmaplugin.com/affiliate-terms-of-use/) - As an authorized affiliate (Affiliate) of SigmaPlugin, you agree to abide by the terms and conditions contained in this Agreement (Agreement). Please read the entire Agreement carefully before registering and promoting SigmaPlugin as an Affiliate. Your participation in the Program is solely to legally advertise our website to receive a commission on memberships and products - [Affiliate Registration](https://sigmaplugin.com/affiliate-registration/) - [Affiliate area](https://sigmaplugin.com/affiliate-area/) - Promote our plugins on your website and receive 40% of commission per referral. For example, if a customer purchases a license of $39, you get $15.6 as commission! If he/she purchases a license of $59, you will get $23.6 of commission It is quick, easy, and FREE to join us Please do not use spamming - [Contact](https://sigmaplugin.com/contact/) - Whether you’ve got plugin issues, plugin suggestions, or pre-sale questions, please drop us a line to: sigmaplugin(at)gmail.com Note: We will do our best to reply as soon as possible. however, due to the timezone differences, we may take several hours to get in touch with you. Thank you for your patience :) Business Address: 30 N Gould - [About](https://sigmaplugin.com/about/) - Welcome to SigmaPlugin, a small, passionate team dedicated to building tools that help you create fast, clean, and powerful WordPress websites. My name is Younes Jaafar (known online as Younes JFR), and I am the founder of SigmaPlugin. My love for programming began when I was 17, the day my father brought home our family’s - [Activation success!](https://sigmaplugin.com/activation-success/) - Your account has been activated successfully! Please log in here - [Login](https://sigmaplugin.com/login/) - [Register](https://sigmaplugin.com/register/) - If you are new, your account will be created automatically after checkout.If you have already purchased one of our products without creating an account, please contact us and we will send you an email to set up your password. Please don't forget to send us the email address you used for your purchase.Contact page - [Update profile](https://sigmaplugin.com/update-profile/) - [Our plugins](https://sigmaplugin.com/plugins/) - [Invoice generation](https://sigmaplugin.com/invoice/) - [Purchase Confirmation](https://sigmaplugin.com/thank-you/) - Thank you for your purchase! - [Purchase Details](https://sigmaplugin.com/purchase-details/) - [Checkout](https://sigmaplugin.com/checkout2/) - [Purchase history](https://sigmaplugin.com/purchase-history/) - [Donation](https://sigmaplugin.com/donation/) - Hi Everyone If you love my plugins and would like to make a donation, then thank you very much. Here is my PayPal address email to send a direct donation: sigmaplugin@gmail.com - [Transaction Failed](https://sigmaplugin.com/transaction-failed/) - Your transaction failed, please try again or contact site support. - [WordPress Advanced Database Cleaner FAQ](https://sigmaplugin.com/wordpress-advanced-database-cleaner-faq/) - Plugin page: Advanced Database Cleaner Quick start How to install and activate the premium version Get access to your account to view your purchase history, downloads, generate invoice, etc. How to recover premium version in case you lost it after upgrade to 3.0.0 FAQ What does mean "clean my database"? Is it safe to clean ## UX Blocks - [Advanced DB Cleaner Block](https://sigmaplugin.com/blocks/advanced-db-cleaner-block/) - Do you know that even after deleting a plugin/theme from your WordPress website, some of its leftovers may remain in your database? Such as orphan options, orphan tables, and orphan cron tasks. As you may know, not all plugins/themes care about the housekeeping of your WordPress database. As long as you are removing plugins/themes, leftovers - [Advanced DB Reset Block](https://sigmaplugin.com/blocks/advanced-db-reset-block/) - Advanced WordPress Reset plugin will reset your WordPress Database back to its first original status in order to make a fresh installation without going through WordPress traditional installation. This plugin will help you save time especially if you are a developer and you have to install WordPress from scratch each time. By using the Advanced - [WP Cron Cleaner Block](https://sigmaplugin.com/blocks/wp-cron-cleaner-block/) - “WP Cron Cleaner” is a useful plugin to view the list of all your scheduled tasks. Indeed, your WordPress site may contain some orphan scheduled tasks that should be cleaned. “WP Cron Cleaner” plugin will display all your tasks and will help identifying those orphan tasks. Moreover, you will be able to see what happens - [siderbar_ads_form_my_plugins](https://sigmaplugin.com/blocks/siderbar_ads_form_my_plugins/) - [Footer](https://sigmaplugin.com/blocks/footer/) - [Blog header](https://sigmaplugin.com/blocks/blog-header/) - [Plugins](https://sigmaplugin.com/blocks/plugins/) - [Home page](https://sigmaplugin.com/blocks/home-page/) - [Money back guarantee section](https://sigmaplugin.com/blocks/money-back-guarantee-section/) ## Downloads - [Sigma Search Replace](https://sigmaplugin.com/downloads/sigma-search-replace/) - [Advanced Database Cleaner Premium](https://sigmaplugin.com/downloads/advanced-database-cleaner-premium/) - [WordPress Advanced Database Cleaner](https://sigmaplugin.com/downloads/wordpress-advanced-database-cleaner/) - Do you know that even after deleting a plugin/theme from your WordPress website, some of its leftovers may remain in your database? Such as orphan options, orphan tables and orphan cron tasks. As you may know, not all plugins/themes care about the housekeeping of your WordPress database. As long as you are removing plugins/themes, leftovers will be accumulated in your database and will influence your website performance. The Pro version of Advanced Database Cleaner will help you remove all those leftovers and perform a deep database clean up. In the pro version you can: * Classify options according to their "creator". They can be either: plugins options, themes options or WP core options * Detect and delete orphan options. * Classify tables according to their "creator". They can be either: plugins tables, themes tables or WP core tables * Detect and delete orphan tables. * Classify all cron tasks according to their "creator". They can be either: plugins cron tasks, themes cron tasks or WP core tasks * Detect and delete orphan cron tasks. * Search & filter options, tables and cron tasks based on several criteria such as the "name", "creator", "value", etc. * Get premium support: we will provide a quick support as well as any technical answers to help you cleanup your database efficiently - [WP Cron Cleaner](https://sigmaplugin.com/downloads/wp-cron-cleaner/) - Your WordPress site may contain some orphan scheduled tasks that should be cleaned. "WP Cron Cleaner" plugin will display all your tasks and will help identifying those orphan tasks... - [Advanced WordPress Reset](https://sigmaplugin.com/downloads/advanced-wordpress-reset/) - Advanced WordPress reset plugin will reset you WordPress Database back to its first original status in order to make a fresh installation without going through WordPress traditional installation. ## Categories - [Blog](https://sigmaplugin.com/category/blog/) - [Docs Advanced DB Cleaner](https://sigmaplugin.com/category/docs-advanced-db-cleaner/) ## Tags - [admin](https://sigmaplugin.com/tag/admin/) - [wordpress](https://sigmaplugin.com/tag/wordpress/) - [database](https://sigmaplugin.com/tag/database/) - [clean-up](https://sigmaplugin.com/tag/clean-up/) - [optimize](https://sigmaplugin.com/tag/optimize/) - [cron](https://sigmaplugin.com/tag/cron/) - [scheduled tasks](https://sigmaplugin.com/tag/scheduled-tasks/) - [revision](https://sigmaplugin.com/tag/revision/) - [draft](https://sigmaplugin.com/tag/draft/) - [auto-draft](https://sigmaplugin.com/tag/auto-draft/) - [pending comment](https://sigmaplugin.com/tag/pending-comment/) - [spam comment](https://sigmaplugin.com/tag/spam-comment/) - [trash comment](https://sigmaplugin.com/tag/trash-comment/) - [postmeta](https://sigmaplugin.com/tag/postmeta/) - [orphan](https://sigmaplugin.com/tag/orphan/) - [relationship](https://sigmaplugin.com/tag/relationship/) - [dashboard transient feed](https://sigmaplugin.com/tag/dashboard-transient-feed/) - [commentmeta](https://sigmaplugin.com/tag/commentmeta/) - [pingback](https://sigmaplugin.com/tag/pingback/) - [trackback](https://sigmaplugin.com/tag/trackback/) - [usermeta](https://sigmaplugin.com/tag/usermeta/) - [termmeta](https://sigmaplugin.com/tag/termmeta/) - [transients](https://sigmaplugin.com/tag/transients/) - [slow](https://sigmaplugin.com/tag/slow/) - [massive images](https://sigmaplugin.com/tag/massive-images/) - [excess plugins](https://sigmaplugin.com/tag/excess-plugins/) - [weak hosting](https://sigmaplugin.com/tag/weak-hosting/) - [user](https://sigmaplugin.com/tag/user/) - [mysql](https://sigmaplugin.com/tag/mysql/) - [phpmyadmin](https://sigmaplugin.com/tag/phpmyadmin/) ## Download Categories - [Wordpress Plugins](https://sigmaplugin.com/downloads/category/wordpress-plugins/) ## Download Tags - [database](https://sigmaplugin.com/downloads/tag/database/) - [clean-up](https://sigmaplugin.com/downloads/tag/clean-up/) - [optimization](https://sigmaplugin.com/downloads/tag/optimization/) - [Free](https://sigmaplugin.com/downloads/tag/free/) - [WordPress](https://sigmaplugin.com/downloads/tag/wordpress/) - [Reset](https://sigmaplugin.com/downloads/tag/reset/) - [cron](https://sigmaplugin.com/downloads/tag/cron/) - [schedule](https://sigmaplugin.com/downloads/tag/schedule/) - [task](https://sigmaplugin.com/downloads/tag/task/) - [search](https://sigmaplugin.com/downloads/tag/search/) - [replace](https://sigmaplugin.com/downloads/tag/replace/)