WordPress.org

한국어

워드프레스 받기
WordPress.org

Plugin Directory

Advanced Database Cleaner – Optimize & Clean database to Speed Up Site Performance

Advanced Database Cleaner – Optimize & Clean database to Speed Up Site Performance

작성자: Younes JFR.
다운로드

설명

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.

Why use 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.

✅ Main Features

  • 글 및 페이지의 이전 리비전 삭제
  • Delete old auto-drafts
  • Delete trashed posts
  • 보류 중인 댓글 삭제
  • 스팸 댓글 삭제
  • Delete trashed comments
  • 핑백 삭제
  • 트랙백 삭제
  • Delete unused post meta
  • Delete unused comment meta
  • Delete unused user meta
  • Delete unused term meta
  • Delete unused relationships
  • 만료된 임시 항목 삭제
  • 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

✅ Automation

  • Schedule database cleanup to run automatically
  • 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
  • Pause/Resume scheduled tasks whenever needed
  • Create as many scheduled cleanup tasks as needed and specify what each task should clean

✅ Tables

  • Display the list of database tables with information such as number of rows, table size, engine, etc.
  • Sort tables by any column such as table name or table size
  • 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
  • Optimize database tables (the plugin notifies you when tables require optimization)
  • Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted)
  • Empty rows of database tables
  • 데이터베이스 테이블 정리 및 삭제

✅ Options

  • 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
  • 옵션을 정리 및 삭제

✅ Cron Jobs

  • 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
  • 예약된 작업을 정리 및 삭제

✅ 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

✅ 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

✅ Other Tools

  • Display current database size
  • 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
  • Clean Action Scheduler Orphan logs

✅ General Cleanup Enhancements

  • Keep last X items feature in General Cleanup
  • Keep last X items per parent (e.g., per post)
  • Keep last X items globally (e.g., keep the last 10 pingbacks)
  • Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety

✅ Advanced Filters

  • Advanced filters in all modules (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs)
  • 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
  • Filter by action frequency and interval in cron jobs
  • Filter by duplicated, unused, large, not-yet-scanned, or expired items

✅ Advanced Automation

  • Unlimited automation tasks (Free version is limited to 5 tasks)
  • 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
  • Run automation tasks hourly, twice daily, daily, weekly, monthly, or at any supported frequency
  • Pause/resume/delete automation tasks without losing settings
  • Per-task automation event logging showing executed actions, number of items cleaned, execution timestamps, and detailed logs

✅ Database Analytics

  • Daily tracking of total database size and number of tables
  • Daily and monthly charts showing database growth trends
  • 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
  • Multisite support (activity recorded on the main site)

✅ Full Multisite Support

  • Clean any site or all sites
  • 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

스크린샷

  • 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
  • Settings page

설치

이 섹션에서는 플러그인 설치 방법을 설명합니다. 일반적으로 다른 워드프레스 플러그인과 마찬가지로 이 플러그인을 설치하는 방법은 세 가지가 있습니다.

1. 워드프레스 알림판을 통해

  • Click on “Add New” in the Plugins dashboard.
  • Search for “advanced-database-cleaner”.
  • Click the “Install Now” button.
  • Activate the plugin from the same page or from the Plugins dashboard.

2. 워드프레스 알림판에 플러그인 업로드를 통해

  • Download the plugin to your computer from: https://wordpress.org/plugins/advanced-database-cleaner/
  • Click on “Add New” in the Plugins dashboard.
  • Click on the “Upload Plugin” button.
  • Select the zip file of the plugin that you downloaded.
  • Click “Install Now”.
  • Activate the plugin from the Plugins dashboard.

3. FTP를 통해

  • Download the plugin to your computer from: https://wordpress.org/plugins/advanced-database-cleaner/
  • Unzip the zip file, which will extract the “advanced-database-cleaner” directory.
  • Upload the “advanced-database-cleaner” directory (included inside the extracted folder) to the /wp-content/plugins/ directory in your web space.
  • Activate the plugin from the Plugins dashboard.

다중 사이트 설치의 경우

  • Log in to your primary site and go to “My Sites” » “Network Admin” » “Plugins”.
  • Install the plugin following one of the above ways.
  • Network-activate the plugin. (Only the main site can access the full network-wide cleanup tools.)

Where is the plugin menu?

  • The plugin can be accessed via “Dashboard” » “WP DB Cleaner” or “Dashboard” » “Tools” » “WP DB Cleaner” (depending on your settings).

FAQ

Why should I “clean my database”?

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.

내 데이터베이스를 정리하는 것이 안전한가요?

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.

Why should I “optimize my database”?

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.

cron(예약된 작업)을 정리하는 것이 안전한가요?

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.

What are “revisions”? What SQL code is used to clean them?

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’

What are “auto drafts”? What SQL code is used to clean them?

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’

What are “pending comments”? What SQL code is used to clean them?

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’

What are “spam comments”? What SQL code is used to clean them?

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’

What are “trash comments”? What SQL code is used to clean them?

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’

What are “trackbacks”? What SQL code is used to clean them?

Trackbacks are a legacy system used by WordPress to allow one website to notify another that it has linked to its content. When a site receives a trackback, it appears as a type of comment on the post. Because trackbacks can be sent manually, they became heavily abused by spammers who use them to post unwanted links on websites.
SQL used by the plugin to delete trackbacks:
DELETE FROM comments WHERE comment_type = ‘trackback’

What are “pingbacks”? What SQL code is used to clean them?

Pingbacks are an automated notification system used by WordPress. When one website publishes a link to another site’s post, WordPress sends a pingback request to the linked site. If accepted, the pingback appears as a type of comment, confirming that another site has referenced your content. Because pingbacks are automated, they are often exploited by bots to generate spam requests.
SQL used by the plugin to delete pingbacks:
DELETE FROM comments WHERE comment_type = ‘pingback’

What is “unused post meta”? What SQL code is used to clean it?

Post meta stores additional information for posts. When a post is deleted, some metadata may be left behind. This leftover “unused” data can grow over time.
SQL used by the plugin to delete unused post meta:
DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

What is “unused comment meta”? What SQL code is used to clean it?

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)

What is “unused user meta”? What SQL code is used to clean it?

User meta stores additional data for users. If a user is deleted, their metadata may not be removed automatically.
SQL used by the plugin to delete unused user meta:
DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users)

What is “unused term meta”? What SQL code is used to clean it?

Term meta stores extra information for taxonomy terms (categories, tags, etc.). If a term is removed, its metadata may remain behind.
SQL used by the plugin to delete unused term meta:
DELETE FROM termmeta WHERE term_id NOT IN (SELECT term_id FROM terms)

What are “unused relationships”? What SQL code is used to clean them?

The wp_term_relationships table links posts to categories/tags. When posts are deleted, related entries may remain in this table, taking unnecessary space.
SQL used by the plugin to delete unused relationships:
DELETE FROM term_relationships WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM posts)

What are “expired transients”?

Transients are temporary cached data stored by plugins or themes. When they expire, they should be removed automatically. However, some expired transients may remain in the database. These can be safely cleaned to free space.

이 플러그인은 다중 사이트와 호환되나요?

Yes, the plugin is compatible with multisite. For safety, only the main site can clean the database for the entire network. Sub-sites cannot perform cleanup operations to avoid accidental damage.

Is this plugin compatible with SharDB, HyperDB, or Multi-DB?

Not yet. The plugin is not currently compatible with SharDB, HyperDB, or Multi-DB setups. Support may be added in future versions.

Does this plugin clean itself after uninstall?

Yes. The plugin removes all of its data and settings when uninstalled. A cleanup plugin that leaves clutter would not make sense!

후기

Exzellent

2025년 12월 7일
It does what it’s supposed to do perfectly.

Outstandingly awesome!

2025년 12월 7일
Installed easy. Updates without issues. Works flawlessly. Been using for a few months now and it couldn’t be easier. Very satisfied and would recommend to anyone!

Bez zastrzeżeń

2025년 12월 6일
Polecam zainstalować jako jedną z pierwszych, by wtyczka łatwo mogła przypisać wpisy do odpowiednich wtyczek/motywów.
모든 1,793 평가 읽기

기여자 & 개발자

“Advanced Database Cleaner – Optimize & Clean database to Speed Up Site Performance”(은)는 오픈 소스 소프트웨어입니다. 다음의 사람들이 이 플러그인에 기여하였습니다.

기여자

“Advanced Database Cleaner – Optimize & Clean database to Speed Up Site Performance”(이)가 12 개 언어로 번역되었습니다. 기여해 주셔서 번역자님께 감사드립니다.

자국어로 “Advanced Database Cleaner – Optimize & Clean database to Speed Up Site Performance”(을)를 번역하세요.

개발에 관심이 있으십니까?

코드 탐색하기는, SVN 저장소를 확인하시거나, 개발 기록을 RSS로 구독하세요.

변경이력

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

  • Fix: handling FS_METHOD ftpext in the file system class.
  • Fix: sub-sites in Multisites were not loaded correctly
  • 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.
  • New: Duplicated term meta cleanup type.
  • New: oEmbed caches cleanup type.
  • 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.

3.1.6 – 24/03/2025

  • 수정: HTML이 포함된 이름이 올바르게 표시되지 않았습니다.
  • 수정: 특정 임시 항목 작업, 옵션, 테이블 및 cron 작업을 삭제할 수 없습니다.
  • 수정: 함수 _load_textdomain_just_in_time이 잘못 호출되었습니다.
  • 수정: 테이블을 최적화한 후 이제 플러그인이 데이터를 새로 고쳐 데이터베이스의 실제 상태를 정확하게 반영합니다.
  • 수정: 플러그인의 보안을 강화했습니다.
  • 수정 (PRO): 사용자가 라이선스를 비활성화할 수 없는 경우가 있었습니다.
  • 조정: 플러그인이 옵션의 자동 로드 값을 편집하는 방식을 개선했습니다.
  • 조정: 검사가 시작된 후에만 max_execution_time을 늘리고, 특정 조건에서만 늘렸습니다.
  • 조정: 일부 PHP, CSS, JS 코드 부분을 정리하고 향상시켰습니다.
  • 신규: 옵션 탭에 자동으로 로드된 옵션의 총 크기가 표시됩니다.
  • 신규: Multisite에서 사용자는 이제 네트워크 관리자 패널에 플러그인 메뉴를 표시할지 선택할 수 있습니다.
  • 신규 (PRO): 필터에서 새로운 자동 로드 옵션 값에 대한 지원이 추가되었습니다: 켜짐, 자동, 자동 켜짐, 자동 꺼짐.
  • New (PRO): users can now assign items to WordPress using the “manual categorization” feature.

3.1.5 – 19/09/2024

  • 수정: false를 배열로 자동 변환하는 기능이 더 이상 사용되지 않음
  • 수정: 헤더 정보를 수정할 수 없습니다. 헤더가 이미 전송되었습니다.
  • 수정: stdClass 클래스의 객체를 문자열로 변환할 수 없음

3.1.4 – 23/01/2024

  • 보안: 역직렬화를 피함으로써 보안 강화(Wordfence의 Richard Telleng에게 감사드립니다)
  • PRO: 끝없는 스캔 재로딩 수정
  • PRO: PHP 경고 수정: float에서 int로의 암묵적 변환
  • PRO: 일부 코드 정리

3.1.3 – 12/09/2023

  • 보안: 일부 매개변수를 정리하여 보안 강화
  • 수정: ‘PHP 8에서는 상수 FILTER_SANITIZE_STRING이 더 이상 사용되지 않습니다’ 수정
  • 수정: ‘정의되지 않은 속성: stdClass::$data_free’를 수정했습니다.
  • 수정: ‘PHP 치명적 오류: 처리되지 않은 TypeError: date(): 인수 #2 ($timestamp)는 ?int 유형이어야 합니다’ 수정
  • 조정: nonce 처리 개선
  • 호환성: 최신 버전의 워드프레스 6.3.1로 테스트됨

3.1.2 – 22/02/2023

  • 보안 수정: 설정을 저장할 때
  • 수정: 때때로 두 번 생성될 수 있어 옵션의 ‘자동 로드’ 변경
  • 수정: 무료 버전과 Pro 버전을 함께 활성화하면 호환성 문제가 발생합니다
  • 조정: Ajax를 사용하도록 일부 코드 블록 향상
  • 조정: WP_List_Table 클래스 사용을 보다 잘 처리
  • 조정 (PRO): 플러그인의 라이선스 페이지 개선 + 업데이트 프로세스
  • 호환성: 최신 버전의 워드프레스 6.1.1로 테스트됨

3.1.1 – 24/06/2022

  • 보안 수정: 일부 URL을 출력하기 전에 이스케이프하여 플러그인의 보안 강화

3.1.0 – 16/06/2022

  • 수정: ‘치명적인 오류: 쓰기 컨텍스트에서 함수 반환 값을 사용할 수 없습니다’ 오류 수정
  • 수정: 경고 수정: count(): 매개변수는 Countable을 구현하는 배열이나 객체여야 합니다
  • 수정: 일부 오타 및 문법 수정
  • 조정: “개요 및 설정” 탭에서 쓸모없는 데이터 삭제
  • 조정: CSS 코드를 향상시켜 이제 플러그인이 반응성이 뛰어나고 작은 화면에서도 사용할 수 있습니다
  • 조정: PHP 코드의 일부 블록 향상
  • New: adding “delete filter” for custom cleanup elements in “general cleanup” tab
  • 정보: CSS 코드를 많이 변경했으므로 브라우저 캐시를 새로 고치거나 “Ctrl + F5″를 클릭하세요.
  • 정보: 다음 버전에 훌륭한 기능이 추가될 예정입니다

3.0.4 – 21/01/2022

  • 조정: 플러그인 보안 강화
  • 조정: 최신 버전의 WP로 플러그인 테스트

3.0.3 – 06/10/2020

  • 조정: 사용하지 않는 코드 블록을 삭제하여 코드 정리
  • 조정: 플러그인 보안 강화

3.0.2 – 01/09/2020

  • 수정: 일반 정리 탭에서 사용자가 소재 불명의 항목을 삭제하지 못하게 하는 문제 수정
  • 조정: 이제 모든 팝업 상자에 SweetAlert를 사용하고 있습니다
  • 조정: JavaScript 코드 향상
  • 조정: 일부 코드 블록 향상
  • 조정: 플러그인 보안 강화

3.0.1 – 26/08/2020

  • 수정: JS 파일의 일부 호출이 수정되었습니다
  • 수정: “더 이상 사용되지 않음: array_key_exists()” 경고가 이제 해결되었습니다
  • 수정: ‘스트림을 열 수 없습니다: 해당 파일 또는 디렉토리가 없습니다’ 문제가 이제 해결되었습니다
  • 워드프레스 5.5로 테스트됨
  • 새로운 기능이 곧 출시됩니다!

3.0.0 – 05/12/2019

  • PRO 사용자를 위한 중요 공지: 이전 버전에서 3.0.0으로 업그레이드하면 워드프레스에서 ‘플러그인 파일이 없습니다’라는 오류로 인해 플러그인이 비활성화된 것을 확인할 수 있습니다. 이는 Pro 플러그인 폴더 이름이 “advanced-db-cleaner”에서 “advanced-database-cleaner-pro”로 변경되었기 때문입니다. 이로 인해 워드프레스가 이전 플러그인을 찾을 수 없어 플러그인이 비활성화됩니다. 다시 활성화하면 아무런 문제가 발생하지 않습니다. 플러그인을 다시 활성화하면 문제 없이 정상적으로 작동합니다. 또한 이번 업그레이드 후에는 Pro 버전이 손실될 가능성이 높습니다(무료 버전과 Pro 버전 간의 충돌로 인해 발생하며, 현재는 해결되었습니다). 이 경우, 다음 단계에 따라 모든 새로운 기능이 포함된 Pro 버전을 복원하세요. (https://sigmaplugin.com/blog/restore-pro-version-after-upgrade-to-3-0-0)

  • 호환성: 이 플러그인은 워드프레스 5.3에서 테스트되었습니다

  • 변경: readme.txt 파일에 대한 일부 변경 사항
  • 제거: 많은 사용자가 초안이 유용하다고 보고했기 때문에 3.0.0에서는 초안이 더 이상 정리되지 않습니다
  • 신규: 이제 새 항목을 정리할 수 있습니다: 핑백, 트랙백, 소재 불명의 사용자 메타, 소재 불명의 용어 메타, 만료된 임시 항목
  • 신규: 왼쪽 메뉴의 플러그인 아이콘이 흰색으로 변경되었습니다
  • 신규: text-domain을 ‘advanced-database-cleaner’로 변경
  • 신규: 플러그인의 모양과 느낌이 향상되었습니다
  • 신규: 무료 버전의 사이드바가 변경되었으며, Pro 버전에서는 삭제되었습니다
  • 신규: 옵션에 대해 옵션 크기 열과 두 가지 새로운 작업이 추가되었습니다. 자동 로드를 ‘아니요/예’로 설정합니
  • 신규: 테이블에 대해 테이블 비우기 및 테이블 복구라는 두 가지 작업을 추가했습니다
  • 신규: 이제 모든 항목을 주문하고 정렬할 수 있습니다
  • 신규: 페이지당 항목 수를 변경할 수 있습니다
  • 신규: 지난 x일 동안의 데이터는 정리되지 않도록 하고 지정한 일수보다 오래된 데이터만 정리할 수 있습니다
  • 신규: 예약된 작업에서 정리할 요소를 지정할 수 있습니다. 또한 필요한 만큼 예약된 작업을 만들 수도 있습니다
  • 신규: ‘일반 정리’ 탭의 사용되지 않는 데이터 각 줄에 정보를 추가하여 사용자가 정리할 각 항목에 대해 자세히 알 수 있도록 했습니다
  • 신규: 정리하기 전에 항목을 표시/보기(‘일반 정리’ 탭)하는 기능이 이제 무료 버전에 추가되었습니다
  • 신규: 무료 버전에서 “프리미엄” 탭을 숨기는 새로운 설정 추가
  • 수정: 올바른 텍스트 도기본으로 일부 문자열 복구
  • 수정: 인수가 있는 일부 작업을 정리할 수 없는 문제가 수정되었습니다
  • 수정: 후크 이름이 같고 인수가 다른 일부 작업이 표시되지 않던 문제가 수정되었습니다
  • 수정: 이전 버전에서는 일부 사용자에게 표가 표시되지 않는 문제가 수정되었습니다
  • 성능: 플러그인에서 사용하는 모든 이미지는 이제 SVG 형식입니다
  • 성능: 더 나은 성능을 위해 전체 코드 재구성
  • 보안: 양식에 _wpnonce 추가
  • 신규 (PRO): 무료 버전과 Pro 버전을 구별하기 위해 Pro 버전의 제목에 “Pro”를 추가합니다
  • 신규 (PRO): 이제 여러 기준에 따라 옵션, 표, 작업 등 모든 요소를 검색하고 필터링할 수 있습니다
  • 신규 (PRO): 소재 불명의 항목을 검색할 때 처리해야 할 남은 항목을 표시하기 위해 진행률 표시줄 추가
  • 신규 (PRO): “분류되지 않음”이라는 카테고리를 추가하여 사용자가 아직 분류되지 않은 항목을 볼 수 있도록 합니다
  • 수정 (PRO): 활성화 문제가 이제 수정되었습니다
  • 수정 (PRO): 소재 불명의 항목 검사로 인해 대용량 데이터베이스에서 시간 초과 오류가 발생했는데 이제 Ajax를 사용하여 이를 해결합니다
  • 수정 (PRO): 무료 버전과 Pro 버전 간의 충돌이 이제 해결되었습니다
  • 성능 (PRO): 이제 EDD 플러그인이 제공하는 향상된 새 업데이트 클래스를 사용하고 있습니다
  • 성능 (PRO): 플러그인에서 사용하는 모든 옵션에서 자동 로드를 아니요로 설정합니다
  • 성능 (PRO): 이 플러그인은 더 이상 검사 결과를 DB에 저장하지 않습니다. 대신 파일을 사용합니다
  • 보안 (PRO): 보안상의 이유로 라이선스가 활성화 후 숨겨집니다
  • 웹사이트 (PRO): 이제 구매 내역을 확인하고, 다운로드하고, 송장을 생성하고, 라이선스를 업그레이드하는 등의 작업을 할 수 있습니다. 자세히 알아보세요.
  • 웹사이트 (PRO): 플러그인 프리미엄 페이지 개선

2.0.0

  • readme.txt 파일에 대한 일부 변경 사항
  • 플러그인 번역 방식 변경
  • 일부 텍스트의 __() 수정
  • 일부 표시 텍스트 수정
  • 스타일의 큰 변화
  • 더 나은 성능을 위해 전체 코드 재구성
  • 플러그인 기본 페이지 생성: (https://sigmaplugin.com/downloads/wordpress-advanced-database-cleaner)
  • 언어 번역 지원 추가
  • 예약된 작업에 대한 시간대 오프셋 수정
  • 최적화하는 동안 InnoDB 테이블 건너뛰기
  • 소재 불명의 테이블 데이터의 크기를 ‘o’에서 ‘KB’로 변경
  • 이제 기본 메뉴는 ‘설정’이 아닌 ‘도구’에 있습니다.
  • 별도의 왼쪽 메뉴 추가(비활성화 가능)
  • 유용한 정보가 포함된 개요 페이지 추가
  • 설정 페이지 추가
  • “데이터베이스 재설정”은 이제 별도의 플러그인으로 제공됩니다(플러그인 페이지를 참조하세요).
  • 다중 사이트: 이제 기본 사이트만 네트워크를 정리할 수 있습니다
  • 신규: 정리하기 전에 항목 표시/보기 (Pro)
  • 신규: 보기 및 정리 옵션
  • 신규: 소재 불명의 옵션, 플러그인 옵션, 테마 옵션 및 WP 옵션 감지(Pro)
  • 신규: cron(예약된 작업) 보기 및 정리
  • 신규: 소재 불명의 작업, 플러그인 작업, 테마 작업 및 WP 작업 감지(Pro)
  • 신규: 데이터베이스 테이블 보기 및 정리
  • 신규: 소재 불명의 테이블, 플러그인 테이블, 테마 테이블 및 WP 테이블 감지(Pro)

1.3.7

  • “휴지통에 있는 글 정리” 추가
  • FAQ 업데이트
  • readme 파일 업데이트
  • 최대 테스트 수준: 4.4

1.3.6

  • 기부 버튼 문제 해결
  • 플러그인의 모든 텍스트에 _e() 및 __() 사용

1.3.5

  • 신규: “cron 정리” 기능이 추가되었습니다. 이제 불필요한 예약된 작업을 정리할 수 있습니다.
  • FAQ 업데이트

1.3.1

  • FAQ 추가

1.3.0

  • 일부 코드 최적화
  • 신규: 다중 사이트 지원. 이제 다중 사이트 설치 환경에서 데이터베이스를 정리하고 최적화할 수 있습니다.

1.2.3

  • 일부 최적화 및 스타일 수정
  • 신규: 스케줄러 추가. 이제 데이터베이스 정리 및 최적화 일정을 예약할 수 있습니다.

1.2.2

  • 일부 최적화 및 스타일 수정

1.2.1

  • 일부 최적화 및 스타일 수정
  • “데이터베이스 정리” 탭에는 이제 모든 요소가 나열되는 대신 정리해야 할 요소만 표시됩니다.
  • “데이터베이스 정리” 탭에는 이제 데이터베이스 상태를 나타내는 아이콘이 표시됩니다.
  • “데이터베이스 최적화” 탭에는 이제 모든 테이블이 나열되는 대신 최적화해야 하는 테이블만 표시됩니다.
  • “데이터베이스 최적화” 탭에는 이제 테이블 상태를 나타내는 아이콘이 표시됩니다.
  • “데이터베이스 재설정”을 선택하면 이제 데이터베이스를 재설정하기 전에 경고가 표시됩니다.

1.2.0

  • 일부 최적화 및 스타일 수정
  • 신규: “데이터베이스 재설정” 추가

1.1.1

  • 일부 최적화 및 스타일 수정
  • “기부 링크” 추가

1.1.0

  • 일부 최적화 및 스타일 수정
  • 신규: “데이터베이스 최적화” 추가

1.0.0

  • 최초 릴리스: Hello world!

기초

평점

별 5점 만점에 4.9점.

리뷰 추가하기

모든 리뷰 보기

기여자

지원

지난 2개월 동안 해결된 문제:

9 중 8

지원 포럼 보기

기부

이 플러그인이 발전하도록 도우시겠습니까?

이 플러그인에 기부하기