Advanced Database Cleaner - Version 1.3.1

Version Description

  • Adding FAQ
Download this release

Release Info

Developer symptote
Plugin Icon 128x128 Advanced Database Cleaner
Version 1.3.1
Comparing to
See all releases

Code changes from version 1.3.0 to 1.3.1

Files changed (2) hide show
  1. README.txt +62 -2
  2. advanced-db-cleaner.php +1 -1
README.txt CHANGED
@@ -1,10 +1,10 @@
1
=== Advanced Database Cleaner ===
2
Contributors: symptote
3
Donate Link: https://www.paypal.com/us/cgi-bin/webscr?cmd=_flow&SESSION=Azq_P8u-Dy9AZSB3bmJFsrGWImHWiCoHtSE8KuC2SNdGQpreQxG8dl2tVZK&dispatch=5885d80a13c0db1f8e263663d3faee8d0b9dcb01a9b6dc564e45f62871326a5e
4
- Tags: plugin, plugins, plugin wordpress, wordpress, database cleaner, clean database, database clean, database, clean, cleaner, delete orphan data, orphan data, delete revisions, revision, delete draft, draft, delete trash, trash, delete spam, spam, delete auto draft, auto draft, delete postmeta, postmeta, delete commentmeta, commentmeta, delete relationships, relationships, delete transient feed, transient feed, optimize database, database optimize, database optimizer, optimize, optimizer, reset database, database reset, reset, admin, widget, schedule, scheduler, schedule clean-up, schedule optimize, multisite, multi-site, network
5
Requires at least: 3.0.0
6
Tested up to: 4.3
7
- Stable tag: 1.3.0
8
License: GPLv2 or later
9
License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
@@ -54,6 +54,9 @@ This section describes how to install the plugin and get it working.
54
55
== Changelog ==
56
57
= 1.3.0 =
58
* Some code optimizations
59
* New feature: Support multisite. You can now clean and optimize your database in multisite installation.
@@ -87,3 +90,60 @@ This section describes how to install the plugin and get it working.
87
88
= 1.0.0 =
89
* First release: Hello world!
1
=== Advanced Database Cleaner ===
2
Contributors: symptote
3
Donate Link: https://www.paypal.com/us/cgi-bin/webscr?cmd=_flow&SESSION=Azq_P8u-Dy9AZSB3bmJFsrGWImHWiCoHtSE8KuC2SNdGQpreQxG8dl2tVZK&dispatch=5885d80a13c0db1f8e263663d3faee8d0b9dcb01a9b6dc564e45f62871326a5e
4
+ Tags: plugin, plugins, plugin wordpress, wordpress, database cleaner, clean database, database clean, database, clean, clean-up, clean up, cleanup, cleaner, delete orphan data, orphan data, delete revisions, delete revision, revision, delete draft, draft, delete trash, trash, delete spam, spam, delete auto draft, auto draft, delete postmeta, postmeta, delete commentmeta, commentmeta, delete relationships, relationships, delete transient feed, transient feed, optimize database, database optimize, database optimizer, optimize, optimizer, reset database, database reset, reset, admin, widget, schedule, scheduler, schedule clean-up, schedule optimize, multisite, multi-site, network, cron, cron job
5
Requires at least: 3.0.0
6
Tested up to: 4.3
7
+ Stable tag: 1.3.1
8
License: GPLv2 or later
9
License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
54
55
== Changelog ==
56
57
+ = 1.3.1 =
58
+ * Adding FAQ
59
+
60
= 1.3.0 =
61
* Some code optimizations
62
* New feature: Support multisite. You can now clean and optimize your database in multisite installation.
90
91
= 1.0.0 =
92
* First release: Hello world!
93
+
94
+ == Frequently Asked Questions ==
95
+
96
+ = What does mean "clean my database"? =
97
+ As you use WordPress, your database accumulates a lot of extra data such as revisions, spam comments, trashed comments, etc. Removing this unnecessary data will reduce your database size, speeds up your backup process and speeds up your site also.
98
+
99
+ = Is it safe to clean my database? =
100
+ Yes, it is. We do not run any code that can break down your site or delete your posts, pages, comments, etc. However, we advise you to create a database backup before cleaning. It is always better to be safe than sorry.
101
+
102
+ = What does mean "Optimize my database"? =
103
+ Optimizing your 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. Optimizing your database is absolutely safe.
104
+
105
+ = Is this plugin compatible with multisite? =
106
+ Yes, it is compatible with multisite.
107
+
108
+ = What does mean "Revision"? What sql code is used to clean it? =
109
+ 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, this can lead to a lot of unnecessary overhead in your WordPress database, which consumes a lot of space. The sql query used by the plugin to clean all revisions is:
110
+ `DELETE FROM posts WHERE post_type = 'revision'`
111
+
112
+ = What does mean "Draft"? What sql code is used to clean it? =
113
+ 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 Draft. Over time, you could have multiple drafts that you will never publish and hence you can clean them. The sql query used by the plugin to clean all drafts is:
114
+ `DELETE FROM posts WHERE post_status = 'draft'`
115
+
116
+ = What does mean "Auto-draft"? What sql code is used to clean it? =
117
+ Wordpress automatically saves your post/page while you are editing it. This is called an 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 will never publish and hence you can clean them. The sql query used by the plugin to clean all auto-drafts is:
118
+ `DELETE FROM posts WHERE post_status = 'auto-draft'`
119
+
120
+ = What does mean "Moderated comment"? What sql code is used to clean it? =
121
+ Moderated comments are comments published by users and which are awaiting for your approval before appearing in your site. In some cases, you will have to clean all these comments. The sql query used by the plugin to clean all moderated comments is:
122
+ `DELETE FROM comments WHERE comment_approved = '0'`
123
+
124
+ = What does mean "Spam comment"? What sql code is used to clean it? =
125
+ It is a comment that you (or a plugin) have marked as a spam. The sql query used by the plugin to clean all spam comments is:
126
+ `DELETE FROM comments WHERE comment_approved = 'spam'`
127
+
128
+ = What does mean "Trash comment"? What sql code is used to clean it? =
129
+ A trash comment is a comment that you have deleted from your Wordpress and have been moved to the trash. A trash comment is not visible in your site and should be deleted forever. The sql query used by the plugin to clean all trash comments is:
130
+ `DELETE FROM comments WHERE comment_approved = 'trash'`
131
+
132
+ = What does mean "Orphan post meta"? What sql code is used to clean it? =
133
+ The post meta data 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 meta data information become orphan and do not belong to any post. They are then called "orphan postmeta" and should be cleaned since they are not useful. The sql query used by the plugin to clean all orphan postmeta is:
134
+ `DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL`
135
+
136
+ = What does mean "Orphan comment meta"? What sql code is used to clean it? =
137
+ The same as "Orphan post meta" with the exception that "orphan comment meta" concern comments and not posts. The sql query used by the plugin to clean all orphan comment meta is:
138
+ `DELETE FROM commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM comments)`
139
+
140
+ = What does mean "Orphan relationships"? What sql code is used to clean it? =
141
+ 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 of database space. The sql query used by the plugin to clean all orphan relationships is:
142
+ `DELETE FROM term_relationships WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM posts)`
143
+
144
+ = What does mean "Dashboard transient feed"? What sql code is used to clean it? =
145
+ Transient are a way for storing cached data temporarily in your database by given it a name and a timeframe after which it will expire and be deleted. The sql query used by the plugin to clean all expired dashboard transient feed meta is:
146
+ `DELETE FROM options WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%'`
147
+
148
+ = Does this plugin cleans itself after the uninstall? =
149
+ Yes, the plugin cleans itself and removes any data used to store its settings.
advanced-db-cleaner.php CHANGED
@@ -4,7 +4,7 @@ defined( 'ABSPATH' ) or die( 'No script kiddies please!' );
4
/*
5
Plugin Name: Advanced Database Cleaner
6
Description: Clean up your database by deleting unused data such as 'draft', Optimize your database or reset it to its initial state.
7
- Version: 1.3.0
8
Author: Younes JFR.
9
Contributors: symptote
10
Text Domain: advanced-db-cleaner
4
/*
5
Plugin Name: Advanced Database Cleaner
6
Description: Clean up your database by deleting unused data such as 'draft', Optimize your database or reset it to its initial state.
7
+ Version: 1.3.1
8
Author: Younes JFR.
9
Contributors: symptote
10
Text Domain: advanced-db-cleaner