Opis
Advanced Database Cleaner is a complete WordPress optimization plugin that helps you clean up database clutter and optimize database performance by removing unused data such as old revisions, auto drafts, spam comments, expired transients, unused post meta, duplicated post meta, unused user meta, etc.
It is designed to help you improve website speed by reducing database bloat and ensuring a lean, efficient WordPress installation. It also provides detailed previews, powerful filters, and automation tools to safely control what gets cleaned.
With the ✨Premium version✨, you can unlock even more advanced features, such as detecting and cleaning orphaned options, orphaned tables, orphaned post meta, orphaned user meta, orphaned transients, and orphaned cron jobs. It also gives you clear insights into how your database evolves over time through built-in analytics, lets you monitor plugin and theme activity to better understand when new data is created or when leftovers appear, and much more.
Dlaczego warto używać Advanced Database Cleaner❓
👉 Get a clear overview: see how many tables, options, transients, cron jobs, metadata… records you have, and identify which are unused or orphaned.
👉 Save time: configure what to clean, how far back to keep data, and how often to run automations. The plugin will then handle recurring cleanups for you.
👉 Save space and improve performance: removing unnecessary data reduces database size, makes backups faster, and can improve query performance, especially on busy or older sites.
✅ Główne funkcje
- Usuwanie starych wersji wpisów i stron
- Usuwanie starych szkiców automatycznych
- Usuwanie wpisów z kosza
- Usuwanie oczekujących komentarzy
- Usuń komentarze spamowe
- Usuwanie komentarzy z kosza
- Usuwanie pingbacków
- Usuwanie trackbacków
- Delete unused post meta
- Delete unused comment meta
- Delete unused user meta
- Delete unused term meta
- Delete unused relationships
- Usuwanie wygasłych stanów przejściowych
- Delete duplicated post meta
- Delete duplicated user meta
- Delete duplicated comment meta
- Delete duplicated term meta
- Delete oEmbed caches
- Display the database size that will be freed before cleaning for each item type, and the total size to be freed
- Display and preview items to clean before performing a database cleanup to ensure safety
- Sorting capability in cleanup preview tables (by name, date, size, site id, etc.)
- View options value content in original or formatted mode for serialized or JSON structures (and other items types as well).
- Keep last X days of data: clean only data older than the number of days you specify
✅ Automatyzacja
- Planowanie automatycznego czyszczenia bazy danych
- Create scheduled cleanup tasks and specify which items each task should clean
- Schedule database optimization and/or repair to run automatically
- Execute scheduled tasks based on several frequencies: once, hourly, twice a day, daily, weekly, or monthly
- Specify the „keep last X days” rule for each item type in a scheduled task
- Wstrzymuj/Wznawiaj zaplanowane zadania w dowolnym momencie
- Create as many scheduled cleanup tasks as needed and specify what each task should clean
✅ Tabele
- Wyświetl listę tabel bazy danych z informacjami takimi jak liczba wierszy, rozmiar tabeli, silnik itp.
- Sort tables by any column such as table name or table size
- Display table contents along with their column structure, indexes, status, and more
- Detect and filter tables with invalid prefixes (tables that do not belong to the current WordPress installation), this can be enabled or disabled from the settings page
- Optymalizacja tabel bazy danych (wtyczka powiadomi cię, jeśli któraś z tabel będzie wymagała optymalizacji)
- Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted)
- Convert tables to InnoDB for better performance
- Empty rows of database tables
- Wyczyść i usuń tabele bazy danych
✅ Opcje
- Display the options list with information such as option name, option value, option size, and autoload status
- Sort options by any column such as option name or option size
- View option value content in original or formatted mode for serialized or JSON structures.
- Notify you if autoloaded options are large and help reduce autoload size for better performance
- Detect large options that may slow down your website
- Set option autoload to yes/no
- Czyszczenie i usuwanie opcji
✅ Zadania Cron
- Display the list of active cron jobs (scheduled tasks) with information such as arguments, action, next run, schedule, etc.
- Sort cron jobs by any column such as action name or next run time
- Detect cron jobs with no valid actions
- Czyszczenie i usuwanie zaplanowanych zadań
✅ Post Meta
- Display the post meta list with information such as meta key, value, size, associated post ID, etc.
- Sort post meta by any column such as meta key, meta size, or post ID
- View post meta value content in original or formatted mode for serialized or JSON structures.
- Detect unused post meta (meta not associated with any existing posts)
- Detect duplicated post meta (same meta key/value for the same post ID)
- Clean and delete post meta
✅ Post types
- Display post types with information such as name, post count, visibility (public or non-public), etc.
- Sort post types by columns such as name, post count, visibility, etc.
- View posts corresponding to each post type, along with their details
- Detect unused or orphaned post types
- Clean orphaned post types
✅ User Meta
- Display the user meta list with information such as meta key, value, size, associated user ID, etc.
- Sort user meta by any column such as meta key, meta size, or user ID
- View user meta value content in original or formatted mode for serialized or JSON structures.
- Detect unused user meta (meta not associated with any existing users)
- Detect duplicated user meta (same meta key/value for the same user ID)
- Clean and delete user meta
✅ Transients
- Display the list of transients with information such as name, value, size, and expiration time
- Sort transients by any column such as transient name, size, or expiration time
- View transient value content in original or formatted mode for serialized or JSON structures.
- Clean expired transients
- Detect large transients that may slow down your website
- Clean and delete transients
- Set transient autoload to yes/no
✅ Inne Narzędzia
- Wyświetl aktualny rozmiar bazy danych
- Logging system for easy troubleshooting
- Access the WordPress debug log directly from the plugin interface
- Multisite support (network-wide database cleanup and optimization from the main site)
- Modern, responsive interface powered by React for a smooth experience without page reloads
- Show/hide plugin tabs for better usability
⚡ Premium Features ⚡ Official website
Unlock the full power of database cleanup and optimization with Advanced Database Cleaner Premium – packed with smart features that take accuracy, speed, and cleanup control to the next level.
✅ Remote SmartScan
- Local scan + Remote SmartScan technology to accurately detect the true owners of tables, options, post meta, user meta, transients, and cron jobs
- Cloud-enhanced ownership detection using a large and continuously improving remote database
- Improved accuracy for identifying orphaned items left by deleted plugins and themes
- Ability to edit ownership of any item and correct misidentified owners
- Ability to send ownership corrections to improve the global detection database
- Enhanced „Belongs to” ownership column everywhere using cloud data + local data
- Display multiple possible owners for each item when applicable
- Display owner status (active, inactive, not installed) to simplify cleanup decisions
- Check your remote scan credits to monitor usage
✅ Action Scheduler Cleanup
- Clean Action Scheduler Completed actions
- Clean Action Scheduler Failed actions
- Clean Action Scheduler Canceled actions
- Clean Action Scheduler Completed logs
- Clean Action Scheduler Failed logs
- Clean Action Scheduler Canceled logs
- Wyczyść dzienniki harmonogramu akcji czyszczenia sierot
✅ General Cleanup Enhancements
- Funkcja zachowaj ostatnie X elementów w trakcie ogólnego czyszczeniu
- Zachowaj ostatnie X elementów dla każdego elementu nadrzędnego (np. dla każdego wpisu)
- Zachowaj globalnie ostatnie X elementów (np. zachowaj ostatnie 10 pingbacków)
- Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety
✅ Zaawansowane Filtry
- Zaawansowane filtry we wszystkich modułach (Tabele, Opcje, Dane meta wpisu, Dane meta użytkownika, Dane przejściowe, Zadania zaplanowane)
- Filter by size, value content, autoload, expiration, metadata type, and more
- Filter by plugin owner, theme owner, WordPress core, orphan, or unknown
- Filter by multisite site ID with full per-site visibility
- Filtruj zadania zaplanowane według częstotliwości
- Filtruj według zduplikowanych, nieużywanych, dużych, jeszcze nieprzeskanowanych lub wygasłych elementów
✅ Zaawansowana Automatyzacja
- Nieograniczona liczba zadań automatycznych (w wersji darmowej jest ograniczenie do 5 zadań)
- Create any number of scheduled cleanup tasks with different configurations
- Create scheduled optimization and repair tasks
- Use Keep Last X Items and Keep Last X Days inside scheduled tasks
- Uruchamiaj zadania automatyzacji co godzinę, dwa razy dziennie, codziennie, co tydzień, co miesiąc lub z dowolną obsługiwaną częstotliwością
- Wstrzymuj, wznawiaj i usuwaj zadania automatyzacji bez utraty ustawień
- Rejestrowanie zdarzeń automatyzacji dla poszczególnych zadań, pokazujące wykonane akcje, liczbę wyczyszczonych elementów, znaczniki czasu wykonania i szczegółowe dzienniki
✅ Analityka Bazy Danych
- Codzienne śledzenie całkowitego rozmiaru bazy danych i liczby tabel
- Dzienne i miesięczne wykresy pokazujące trendy wzrostu bazy danych
- Raw data tab with all recorded measurements
- Table-level analytics showing size growth, rows growth, and daily changes
- Ability to detect abnormal table growth caused by logs, caches, or runaway actions
- Multi-table selection and search for analyzing multiple tables at once
✅ Addons Activity
- Automatically track plugin activations, deactivations, and uninstalls
- Automatically track theme switches and uninstalls
- Display activity in a color-coded timeline for better readability
- All timestamps shown in your local timezone
- Wsparcie sieci stron (aktywność rejestrowana na głównej stronie)
✅ Full Multisite Support
- Wyczyść witrynę lub wszystkie witryny
- Filter items by site ID in every module (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs)
- Display which site each item belongs to
- Run automation tasks across the entire network
Zrzuty ekranu
General Cleanup overview (list of database items to clean, total count & size) 
Preview items before cleaning – Revisions example (filters in Premium) 
Keep Last rules – Revisions example (keep last X items in Premium) 
Tables overview (filters & scan in Premium) 
Options overview (filters & scan in Premium) 
Post Meta overview (filters & scan in Premium) 
User Meta overview (filters & scan in Premium) 
Transients overview (filters & scan in Premium) 
Cron Jobs overview (filters & scan in Premium) 
Start Scan modal – Full scan selected (in Premium) 
Scan running for Options – Exact Match step (in Premium) 
More info about an Option ownership (in Premium) 
Edit an Option ownership (in Premium) 
Automation cleanup tasks overview 
Create an Automation Revisions cleanup task (keep last 2 revisions per post) 
Revisions cleanup Automation task events log (in Premium) 
Database analytics – Last 30 days daily charts (in Premium) 
Tables analytics – Last 30 days, actionscheduler_logs & wp_options selected (in Premium) 
Addons Activity – Timeline of activation, deactivation & uninstall (in Premium) 
Info & Logs – System Info tab selected 
Strona ustawień
Instalacja
W tej sekcji opisano, jak zainstalować wtyczkę. Ogólnie rzecz biorąc, istnieją 3 sposoby instalacji tej wtyczki, tak jak każdej innej wtyczki WordPress.
1. Przez kokpit WordPress
- Kliknij „Dodaj wtyczkę” w kokpicie.
- Wyszukaj 'advanced-database-cleaner’
- Kliknij przycisk „Zainstaluj teraz”.
- Włącz wtyczkę z tej samej strony lub z kokpitu nawigacyjnego wtyczek
2. Poprzez przesłanie wtyczki do kokpitu WordPress
- Pobierz wtyczkę na swój komputer ze strony (https://wordpress.org/plugins/advanced-database-cleaner/)
- Kliknij „Dodaj wtyczkę” w kokpicie.
- Kliknij przycisk „Wyślij wtyczkę na serwer”.
- Wybierz plik zip wtyczki, który pobrałeś.
- Kliknij „Zainstaluj teraz”
- Włącz wtyczkę w kokpicie na stronie zarządzania wtyczkami
3. Przez FTP
- Pobierz wtyczkę na swój komputer ze strony (https://wordpress.org/plugins/advanced-database-cleaner/)
- Rozpakuj plik zip, co spowoduje wyodrębnienie katalogu „advanced-database-cleaner”
- Wgraj katalog 'advanced-database-cleaner’ (włączając wewnętrzne, rozpakowane katalogi) do katalogu /wp-content/plugins/ na twojej przestrzeni dysków serwerowych
- Włącz wtyczkę w kokpicie na stronie zarządzania wtyczkami
Do instalacji sieci stron
- Zaloguj się do swojej głównej witryny i przejdź do „Moje witryny” „Administrator sieci” „Wtyczki”
- Zainstaluj wtyczkę wybierając jedną z metod
- Network-activate the plugin. (Only the main site can access the full network-wide cleanup tools.)
Gdzie jest menu wtyczki?
- The plugin can be accessed via „Dashboard” » „WP DB Cleaner” or „Dashboard” » „Tools” » „WP DB Cleaner” (depending on your settings).
Najczęściej zadawane pytania
-
Dlaczego powinienem „czyścić moją bazę danych”?
-
As you use WordPress, your database accumulates a large amount of unnecessary data such as revisions, spam comments, trashed comments, and more. This clutter slowly increases the size of your database, which can make your site slower and make backups take longer. Cleaning this data keeps your site lighter, faster, and easier to maintain.
-
Czy czyszczenie bazy danych jest bezpieczne?
-
Yes, it is safe. The plugin does not run any code that can break your site or delete posts, pages, or approved comments. It only removes items that WordPress considers unnecessary. However, you should always back up your database before performing any cleanup. This is required, not optional! Backups ensure you can always restore your site if something unexpected happens.
-
Dlaczego powinienem „optymalizować moją bazę danych”?
-
Optimizing your database reclaims unused space and reorganizes the way data is stored inside your tables. Over time, tables become fragmented, especially on active websites. Optimization reduces storage usage and improves the speed at which your database responds. This process is safe and can significantly improve performance on large or busy websites.
-
Czy czyszczenie zadań cron (zadań zaplanowanych) jest bezpieczne?
-
Cron jobs allow WordPress and plugins to run tasks automatically (like checking for updates or sending emails). When a plugin is removed, some of its cron jobs may remain behind. These leftover tasks serve no purpose and can slow down wp-cron events. Cleaning unnecessary cron jobs is safe as long as you know which ones should be removed. If you are unsure, it is safer not to delete any cron jobs manually.
-
Czym są „wersje”? Jaki kod SQL jest używany do ich czyszczenia?
-
WordPress stores revisions for each saved draft or update so you can review older versions. Over time, these accumulate and take up space.
SQL used by the plugin to delete revisions:
DELETE FROM posts WHERE post_type = 'revision’ -
Czym są „auto-szkice”? Jaki kod SQL jest używany do ich czyszczenia?
-
WordPress automatically creates auto-drafts while you are editing posts/pages. If those drafts are never published, they remain in the database.
SQL used by the plugin to delete auto-drafts:
DELETE FROM posts WHERE post_status = 'auto-draft’ -
Czym są „oczekujące komentarze”? Jaki kod SQL jest używany do ich czyszczenia?
-
Pending comments are comments waiting for your approval. If you have many bots submitting comments, this list can grow quickly.
SQL used by the plugin to delete pending comments:
DELETE FROM comments WHERE comment_approved = '0′ -
Czym są „komentarze spamowe”? Jaki kod SQL jest używany do ich czyszczenia?
-
Spam comments are comments flagged as spam by you or by an anti-spam plugin. They can safely be deleted.
SQL used by the plugin to delete spam comments:
DELETE FROM comments WHERE comment_approved = 'spam’ -
Czym są „komentarze w koszu”? Jaki kod SQL jest używany do ich czyszczenia?
-
Trash comments are deleted comments moved to the trash. They are no longer visible and can be permanently removed.
SQL used by the plugin to delete trash comments:
DELETE FROM comments WHERE comment_approved = 'trash’ -
Czym są „trackbacki”? Jaki kod SQL jest używany do ich czyszczenia?
-
Trackbacki to przestarzały system WordPress, który umożliwia jednej stronie internetowej powiadomienie innej o umieszczeniu odnośnika do jej treści. Gdy strona otrzyma trackback, pojawia się on jako rodzaj komentarza do wpisu. Ponieważ trackbacki można wysyłać ręcznie, stały się one bardzo nadużywane przez spamerów, którzy wykorzystują je do publikowania niechcianych odnośników witrynach internetowych.
Kod SQL używany przez wtyczkę do usuwania trackbacków:
DELETE FROM comments WHERE comment_type = 'trackback’ -
Czym są „pingbacki”? Jaki kod SQL jest używany do ich czyszczenia?
-
Pingbacki to zautomatyzowany system powiadomień używany przez WordPress. Gdy jedna witryna internetowa publikuje odnośnik do wpisu na innej stronie, WordPress wysyła żądanie pingback do powiązanej witryny. Po zaakceptowaniu, pingback pojawia się jako rodzaj komentarza, potwierdzając, że inna strona odniosła się do twojej treści. Ponieważ pingbacki są zautomatyzowane, często są wykorzystywane przez boty do generowania żądań spamu.
Kod SQL używany przez wtyczkę do usuwania pingbacków:
DELETE FROM comments WHERE comment_type = 'pingback’ -
Czym jest „nieużywane post meta”? Jaki kod SQL jest używany do jego czyszczenia?
-
Metadane wpisu przechowują dodatkowe informacje o wpisach. Po usunięciu wpisu niektóre dane meta mogą pozostać. Te pozostałe „nieużywane” dane mogą z czasem zwiększać swą objętość.
Kod SQL używany przez wtyczkę do usuwania nieużywanych danych meta wpisu:
DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL -
Czym jest „nieużywane comment meta”? Jaki kod SQL jest używany do jego czyszczenia?
-
Comment meta stores extra information for comments. When a comment is removed, some metadata may remain in the database.
SQL used by the plugin to delete unused comment meta:
DELETE FROM commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM comments) -
Czym jest „nieużywane user meta”? Jaki kod SQL jest używany do jego czyszczenia?
-
Dane meta użytkownika przechowują dodatkowe dane o użytkownikach. Jeśli użytkownik zostanie usunięty, jego dane meta mogą nie zostać usunięte automatycznie.
Kod SQL używany przez wtyczkę do usuwania nieużywanych metadanych użytkownika:
DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users) -
Czym jest „nieużywane term meta”? Jaki kod SQL jest używany do jego czyszczenia?
-
Dane meta terminów przechowują dodatkowe informacje o terminach taksonomicznych (kategoriach, tagach itp.). Jeśli termin zostanie usunięty, jego dane meta mogą pozostać.
Kod SQL używany przez wtyczkę do usuwania nieużywanych metadanych terminów:
DELETE FROM termmeta WHERE term_id NOT IN (SELECT term_id FROM terms) -
Czym są „nieużywane relacje”? Jaki kod SQL jest używany do ich czyszczenia?
-
Tabela wp_term_relationships łączy wpisy z kategoriami/tagami. Po usunięciu wpisów powiązane wpisy mogą pozostać w tej tabeli, zajmując niepotrzebnie miejsce.
Kod SQL używany przez wtyczkę do usuwania nieużywanych relacji:
DELETE FROM term_relationships WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM posts) -
Czym są „wygasłe transients”?
-
Dane tymczasowe (transjenty) to tymczasowe dane buforowane przez wtyczki lub motywy. Po wygaśnięciu powinny zostać automatycznie usunięte. Jednak niektóre przestarzałe dane tymczasowe mogą pozostać w bazie danych. Można je bezpiecznie usunąć, aby zwolnić miejsce.
-
Czy wtyczka jest zgodna z siecią stron?
-
Tak, wtyczka jest kompatybilna z wieloma witrynami. Ze względów bezpieczeństwa tylko witryna główna może czyścić bazę danych w całej sieci. Witryny podrzędne nie mogą wykonywać operacji czyszczenia, aby uniknąć przypadkowego uszkodzenia.
-
Czy ta wtyczka jest kompatybilna z SharDB, HyperDB lub Multi-DB?
-
Jeszcze nie. Wtyczka nie jest obecnie kompatybilna z konfiguracjami SharDB, HyperDB ani Multi-DB. Obsługa może zostać dodana w przyszłych wersjach.
-
Czy ta wtyczka czyści się sama po odinstalowaniu?
-
Tak. Wtyczka usuwa wszystkie swoje dane i ustawienia po odinstalowaniu. Wtyczka czyszcząca, która pozostawia bałagan, nie ma sensu!
Recenzje
Kontrybutorzy i deweloperzy
„Advanced Database Cleaner – Optymalizuj i czyść bazę danych, aby przyspieszyć wydajność strony” jest oprogramowaniem open source. Poniższe osoby miały wkład w rozwój wtyczki.
Zaangażowani
Wtyczka „Advanced Database Cleaner – Optymalizuj i czyść bazę danych, aby przyspieszyć wydajność strony” została przetłumaczona na 12 języków. Podziękuj tłumaczom za ich wkład.
Interesuje cię rozwój wtyczki?
Przeglądaj kod, sprawdź repozytorium SVN lub czytaj dziennik rozwoju przez RSS.
Rejestr zmian
4.1.1 – 05/05/2026
- Security: [Premium + Pro-Lifetime] Patched a security vulnerability in the EDD SDK package
- Fix: Resolved an issue where the „No route was found matching the URL” error occurred when the default REST API URL was modified
- Fix: Fixed ReflectionFunction::__construct() error requiring a Closure or string as the first argument
- Fix: Corrected „Invalid setting key” error when hiding the post types menu item
- Fix: [Premium + Pro-Lifetime] Addressed undefined array key DOCUMENT_ROOT on sites running WP-Cron via system cron and WP-CLI in the Easy Digital Downloads (EDD) SDK package
- Tweak: Refactored several parts of the codebase to improve performance and maintainability
4.1.0 – 08/04/2026
- New: Added „Post Types” cleanup module
- New: In the General Cleanup tab, added a toggle for each item: Auto Count or Manual Count
- New: Added an action to convert table engines to InnoDB
- New: Added quick actions per row (available on the right side) for faster processing
- New: Added the ability to view table data, including rows content, column structure, indexes, and more
- Fix: Resolved an issue where RecursiveIteratorIterator could trigger excessive server load in certain environments
- Fix: Corrected the refresh icon behavior in the Addons Activity module to ensure consistent updates
- Fix: Fixed an issue where multiple folders were unintentionally created when deleting plugin settings
- Fix: Resolved a multisite issue where update notifications were displayed even when the latest version was already installed
- Fix: Fixed a “_load_textdomain_just_in_time was called incorrectly” warning caused by premature calls to wp_get_schedules() before the init hook
- Fix: Prevented scan crash caused by natsort() receiving a boolean instead of an array
- Fix: Adjust display properties for img/svg in WP admin menu to prevent layout shifts
- Tweak: Each table now displays the percentage of total database size it occupies, providing a clearer view of database distribution
- Tweak: Added an action to refresh table statistics and information
- Tweak: Prevent actions (such as delete) on WordPress core items by default (can be disabled in settings)
- Tweak: Add file path for cron jobs actions
- Tweak: Added direct links in notifications to help users quickly access logs or settings
- Tweak: Reduced (or eliminated) unnecessary frontend and backend requests/queries, executing them only when needed
- Tweak: Added a setting to bypass the confirmation modal for actions such as delete
- Tweak: In the settings page, invalid values are now handled locally with error messages, without sending REST requests
- Tweak: Refactored several parts of the codebase for better performance and maintainability
4.0.7 – 07/03/2026
- New: Added support for both SQL and native deletion methods in the Options, Transients, Postmeta, and Usermeta modules
- New: [Pro-Lifetime] Implemented a scan credits system in the new Pro plugin version
- Fix: Resolved conflict issues when different plugin versions are activated at the same time
- Fix: General Cleanup data now refreshes correctly when clicking the eye icon after changing the „Keep last” value
- Fix: Resolved „Invalid setting key” error when saving settings (Nginx edge case)
- Fix: Fixed issue where the plugin menu could disappear in some cases when version conflicts occur
- Tweak: [Pro-Lifetime] Implement data migration between the new Pro version and the old Pro version
- Tweak: Added links to notification popups for easier navigation
- Tweak: Added Remote Scan balance to the top bar of the plugin interface
- Tweak: Improved license activation/deactivation handling by refreshing balances and preventing unauthorized actions
- Tweak: Added several known usermeta and postmeta entries to the internal dictionaries
- Tweak: General code improvements and CSS enhancements
4.0.6 – 28/01/2026
- Fix: Some SQL queries did not run when database tables had different collations in Multisite setups.
- Fix: The „Show value” modal did not appear for expired transients.
- Fix: Deleted items could reappear as „ghost” entries after switching tabs and coming back.
- Fix: Some UI elements were incorrectly hidden on frontend pages.
- Fix: Extra characters in some translations within the UK ’.po’ file.
- Fix: [Premium] After a scan completed, correct counts were shown but disappeared when switching tabs and returning.
- Tweak: In Trashed Posts, only WordPress core post types are now displayed to prevent accidental deletion of unexpected data.
- Tweak: Allow selecting items by groups under the „General Cleanup” tab.
- Tweak: Increase the maximum number of selectable items per page from 200 to 1000.
- Tweak: General improvements to code quality and styling.
4.0.5 – 17/01/2026
- Fix: The plugin left menu was unstable in some environments.
- Fix: Some filters did not correctly reflect the displayed data.
- Fix: Certain strings were not translated in Multisite REST responses.
- Fix: Some special usermeta entries in Multisite and custom table prefix setups were not correctly assigned to WordPress core.
- Tweak: Improved the General Cleanup page to reduce the number of REST requests for better performance.
- Tweak: Take into account the site_status_autoloaded_options_size_limit filter when displaying the autoload size warning.
- Tweak: Added bulk actions to the bottom of tables as well.
- Tweak: Added the ability to select multiple items using the Shift key.
- Tweak: Optimized loading of scan results from files for improved performance.
- Tweak: Optimized the calculation of non-scanned items for better performance.
- Tweak: Added plugin settings to the System Info page.
- Tweak: Unified the structure of installed add-ons data sent during Remote Scan.
- Tweak: Various improvements to code quality, security, and styling.
4.0.4 – 25/12/2025
- Fix: [Premium] Prevented license activation from being unintentionally removed after one week.
- Fix: Resolved style conflicts with other plugins.
- Fix: Corrected an issue where sorting usermeta by meta key returned empty results when the „duplicated” filter was applied.
- Tweak: [Premium] Removed the weekly license check cron job when uninstalling the plugin.
- Tweak: Refactored code to improve loading performance by caching data.
- Tweak: Added translatable strings and corrected some date-format inconsistencies.
- Tweak: Improved UI consistency across all tables.
- Tweak: Increased Database Rows Batch limit to 50,000 by default for better performance on large sites.
- Tweak: Added a refresh icon to the highlighted orange sections for easier counts refresh.
4.0.3 – 14/12/2025
- Fix: Improved compatibility with PHP 7.
- Tweak: Optimized the loading of the Post Meta module for large websites.
- Tweak: Highlighted preset filter section counters are now fetched via separate endpoints for better performance.
- Tweak: Optimized the duplicated meta module to improve performance.
- Tweak: Optimized the General Cleanup module for faster loading.
- Tweak: Overall performance improvements and internal code optimizations.
4.0.2 – 05/12/2025
- Fix: Conflict with another plugin injecting links into our plugin settings.
- Fix: Syntax error: unexpected '…’ (T_ELLIPSIS), expecting ’]’.
- Fix: Deletion of transients and expired_transients in multisite within the sitemeta table when the transient’s site_id is invalid.
- Fix: Duplicate „squared” transients and expired transients being displayed.
- Tweak: Synchronize Axios timeout (React) with PHP max execution time to avoid early request timeouts.
- Tweak: In trashed comments, count only trashed comments and ignore comments belonging to trashed posts.
- Tweak: Use crc32 hashing to speed up detection of duplicate values.
- Tweak: General code cleanup and optimization.
- Tweak: [Premium] Added new WordPress-related items for improved identification.
- New: [Free] new setting allowing to control the number of items retrieved from the database per request for better performance.
- New: Choose between native WordPress functions or direct SQL queries for deleting items (new setting added).
- New: Items in the General Cleanup page are now loaded individually, so content appears immediately without waiting for all items.
- New: Items can now be deleted one by one in General Cleanup without reloading the entire list after each action.
- Compatibility: Tested with WordPress 6.9.
4.0.1 – 01/12/2025
- Naprawiono: obsługę FS_METHOD ftpext w klasie systemu plików.
- Naprawiono: podstrony w sieci stron nie były wczytywane prawidłowo.
- Fix: options and other items cannot be deleted in free version.
4.0.0 – 28/11/2025
Version 4.0.0 marks the biggest upgrade ever released for Advanced Database Cleaner. This major update introduces a completely redesigned interface for a smoother, faster, and more intuitive experience. It also brings powerful new features, an enhanced two-step scan engine for unmatched accuracy, and advanced security improvements that make database maintenance safer than ever. With better performance, more flexibility, and a modern UI, version 4.0.0 sets a new standard for professional WordPress database optimization.
- New: Duplicated post meta cleanup type.
- New: Duplicated user meta cleanup type.
- New: Duplicated comment meta cleanup type.
- Nowość: Typ czyszczenia zduplikowanych danych meta terminów.
- Nowość: typ czyszczenia pamięci podręcznej oEmbed.
- New: Estimated size to clean displayed for each cleanup type, plus a total freed-space summary before running a cleanup.
- New: Sorting capability added to cleanup preview tables (e.g. by name, date, size, site ID).
- New: Value viewer added to several cleanup types, displaying serialized or JSON data in raw or formatted views.
- New: Dedicated Post Meta Management module to list, sort, inspect, and clean post meta, including detection of unused and duplicated metadata.
- New: Dedicated User Meta Management module to list, sort, inspect, and clean user meta, including detection of unused and duplicated metadata.
- New: Dedicated Transients Management module to inspect, sort, and clean transients, with expiration tracking, detection of large transients, and control over their autoload status.
- New: Tables Management can now detect tables with invalid prefixes that do not belong to the current WordPress installation, with their visibility controlled from the Settings page.
- New: Options Management now includes a formatted value viewer, detection of large options, and warnings for heavy autoloaded options to help reduce autoload size.
- New: Cron Jobs Management now includes detection of cron jobs with no valid action/callback to help you clean them safely.
- New: All six management modules now detect items owned by WordPress core and Advanced Database Cleaner, making it clearer where data comes from.
- New: All six management modules now include an Attention Area that highlights priority issues, warns you about items requiring action, and helps you quickly identify and target them.
- New: Introduced a built-in error and exception logging system, allowing logs to be copied or downloaded for support or user-side investigations.
- New: Added tools to display the current database size, show or hide the plugin’s menu tabs, and access the WordPress debug log directly from the interface.
- New: Modern, fully responsive interface rebuilt with React for a smoother, faster, and more intuitive user experience.
- Enhanced: Cleaning process in the General Cleanup module now uses WordPress native deletion functions for deeper, hook-aware cleanup, with direct SQL deletion kept only as a safe fallback when required.
- Enhanced: Automation is now centralized into a unified module with a clearer creation/edit flow and consistent use of the local timezone for all schedules.
- Enhanced: Options, Tables, and Cron Jobs modules now display richer information with additional columns and more detailed data for each item.
- Enhanced: System Info is now far more detailed and can be copied or downloaded, making it easier to share environment details, diagnose issues, and assist users during support.
- Enhanced: Overall multisite support now provides clearer separation between network and site data and safer network-wide cleanup and optimization.
- Enhanced: Backend architecture migrated to a REST API–driven system for significantly faster interactions and navigation without page reloads.
- Enhanced: Numerous bugs and edge cases were resolved across all modules, resulting in more stable behavior and more reliable, effective cleaning operations.
- Premium: New – Action Scheduler completed actions cleanup type.
- Premium: New – Action Scheduler failed actions cleanup type.
- Premium: New – Action Scheduler canceled actions cleanup type.
- Premium: New – Action Scheduler completed logs cleanup type.
- Premium: New – Action Scheduler failed logs cleanup type.
- Premium: New – Action Scheduler canceled logs cleanup type.
- Premium: New – Action Scheduler orphan logs cleanup type.
- Premium: New – „Keep last X items” rule introduced, either per parent (e.g. keep 5 revisions per post) or globally (e.g. keep the last 10 pingbacks), in addition to the existing „keep last X days” rule.
- Premium: New – Introduced Remote Scan system that combines the local scan with our cloud-based detection engine and continuously curated ownership database to deliver near-perfect accuracy when identifying the true owners of tables, options, post meta, user meta, transients, and cron jobs.
- Premium: New – Added the ability to anonymously send your ownership corrections to improve our global detection database and refine ownership results for all users.
- Premium: New – „Keep last X items” rule now configurable inside scheduled tasks, in addition to the existing „keep last X days”, for more advanced and safer automated cleanups.
- Premium: New – Introduced Database Analytics module with daily and monthly charts, raw data views, and per-table analytics (size evolution, rows evolution, daily change breakdown), including multi-table selection for comparative analysis.
- Premium: New – Introduced Addons Activity module that automatically tracks plugin and theme activations, deactivations, uninstalls, and theme switches in a color-coded timeline using your local timezone.
- Premium: New – Added multisite filters to the General Cleanup preview, allowing items to be filtered by site ID or site name so you can focus on a specific site in the network.
- Premium: New – Introduced per-automation event logs showing what was cleaned, when each task ran, and how many items were processed.
- Premium: Enhanced – Scan process fully redesigned for greater robustness and accuracy, combining an improved local scan with Remote Scan results.
- Premium: Enhanced – Scan flow now offers clearer insights, guidance, and error handling throughout each step of the process.
- Premium: Enhanced – „Belongs to” ownership column enriched with cloud-backed data across all management modules for more accurate owner detection.
- Premium: Enhanced – Detailed ownership info modal added, showing all known plugins/themes related to each item.
- Premium: Enhanced – Owner status indicators added (active, inactive, or not installed) to support deeper investigations.
- Premium: Enhanced – Filtering capabilities expanded across all management modules with new filters by size, value content, autoload, expiration, owner type (plugin, theme, WordPress core, orphan, unknown), duplicates, unused, large, not-yet-scanned, and more, including filtering specifically by a chosen plugin or theme.
- Premium: Enhanced – Multisite experience improved with clearer cross-site visibility, safer network-level operations, and tighter integration of ownership and analytics across all sites.
- Premium: Enhanced – Numerous bugs and edge cases were resolved across all premium features, resulting in more stable behavior and more reliable, effective cleaning operations.
Previous changelog
- For previous changelog, please refer to the changelog on sigmaplugin.com.