Plugins Garbage Collector
Plugins Garbage Collector
Some WordPress plugins create and use its own database tables. Those tables (small and large) are left in your database after plugin deactivation and deletion often. If your blog is more than 1 day old you have some plugins garbage in your WordPress database probably. With the help of this plugin you can check your database and discover if it is clean or not. Plugin shows not WordPress tables list with quant of its records, size they occupy in Kb. Plugin name and plugin state are shown too if those data are available.
Changes made to the core WordPress database tables (columns added) could be discovered too.
Version 0.9.1 is available. Click the Download button below if you wish to try it.
Quick Links
Look at “Plugins Garbage Collector” plugin in action screenshot:
- Red color rows with high probability show old deleted plugins forgotten tables, so-called plugins garbage, which can be deleted from your WordPress database with the help of
Delete Tablesbutton or some of your favorite database tools, e.g. phpMyAdmin. - Blue color rows show tables which belong to deactivated plugins. Those tables are probably candidates for deletion after you decide to delete theirs parent plugins.
- Green color rows show tables which belong to active plugins. Those tables are now in use. You do not need to touch them.
How Plugins Garbage Collector works? It selects all table names from your WordPress database, excludes core WordPress installation tables, then scans your plugins directory .php files text for table names and shows you the result as written above.
Delete Tables button appears if you have red color rows in the scan results table only. You need to turn on checkbox near the table name if you decided to drop it before click the Delete Tables button.
Attention! Delete table operation can not be rolled back. Please double think what are you doing before use Delete Tables button.
Plugins Garbage Collector is the decision support tool only and its conclusion about table usage can be wrong in some (I hope rare) cases. For example, if plugin developer uses some sophisticated scheme to assign names for his tables, not puts simple text into source code e.g. ‘my_plugin_table_name’, but calculates it with some algorithm e.g. ‘my’.'_’.'plugin’.'_’.'table’, etc… Final decision is for you – blog owner.
Do you have a suggestion what useful feature we can add to this plugin? Please, left your comments.
Translations
- Czech: Jindřich “Masterbill” Rubeš
- French: Simon
- Dutch: Arthur
- German: Christian
- Japanese: Yoichi
- Indonesian: Masino Sinaga
- Italian: Alessandro Mariani
- Russian: Vladimir Garagulya
- Spanish: Melvis E. Leon Lopez
Dear plugin User,
if you wish to help me with this plugin translation I very appreciate it. Please contact me via Contact form and I will answer you by email. Do not forget include your site link in order I can show it with greetings for the translation help at shinephp.com, plugin settings page and in this readme.txt file. If you have better translation for some phrases send it to me. You are welcome!
Special Thanks to
You are welcome! Help me in the bug hunting, share with me new ideas about plugin further development, contribute to the source code and link to your site will appear here.
ChangeLog
- 0.9.1 = 07.07.2010
- options form layout problem is fixed. That was wrong pgc-admin.css file version issue. - 0.9 = 01.07.2010
- You can mark tables which you do not wish to see as scan results as hidden.
- You can search extra columns in the core WordPress tables, which could be added by plugins.
- Czech translation is added. - 0.6 = 25.05.2010
- Dutch translation is updated. - 0.5.2 = 18.05.2010
- Italian translation is updated. - 0.5.1 = 14.05.2010
- German translation is updated. - 0.5 = 12.05.2010
- Italian translation is added.
- Lost translation domain inserted into a few places in the source code. Translators a welcome to update their work
.
- 0.4 = 03.05.2010
- “Delete Tables” button is added
- General code cleanup - 0.3 = 02.05.2010
- German, Japanese translations are added
- Another text domain ‘pgc’ missing bug is fixed - 0.2 = 01.05.2010
- French, Indonesian, Spanish translations are added
- Text domain ‘pgc’ missing bug is fixed - 0.1 = 29.04.2010
- 1st pre-release of the “Plugins Garbage Collector” WordPress Plugin.
FAQ
Coming soon. Just ask it. I will search the answer.
I am ready to answer on your questions about this plugin usage and help with possible problems. Use Plugins Garbage Collector plugin forum or this page comments and site contact form for that please.
Thanks,
Vladimir, ShinePHP.com.
If looking for quick success then make best use of testking 640-822 notes, testking 642-813 dumps and testking 642-832 practice exam to hit your goal on first try.
Tags: WordPress, wordpress plugin
[...] Скачать Plugins Garbage Collector [...]
“Do you have a suggestion what useful feature we can add to this plugin? May be you wish to have Delete button for not used tables right here to not go to phpMyAdmin?”
This would be a really nice feature.
Thank you, Gene and Geoffrey, for your support. I will implement the “Delete” feature for unused tables definitely in one of the next update.
Thank you very much. This is the plugin i'm looking for.
Recently after my site was hacked twice, i'm learning about database and cleaning them.
I deleted some of the tables in myphp without any clue if it's wanted or unwanted.
Yes, A “Delete” button would be very helpful.
Thanks Shinephp !
Thanks. I appreciate your support. I'm working on delete tables functionality and it will be added in a few next days.
[...] Garbage Collector v. 0.4 is available PGCPlugins Garbage Collector v. 0.4 is publushed at May 03rd, 2010. New feature “Delete Tables” is added. [...]
I installed version .2 and have used the automatic upgrade option for versions .3. and .4.
In both cases the upgrade has taken place successfully but the plugin page still shows the old version as being installed and that there is an update available (looking at the source code header indicates 0.4 installed correctly).
My installation (0.4 running on the Atahualpa Theme with Buddypress/WP on a Linux server) seems to be working but only partially.
The results of my scan just shows a list of tables with only two columns – Table Name and Plugin Name. In all cases the Plugin Name is 'Unknown'. Everything is in RED and the tables listed appear to those that are empty.
I could send you a screen image if you tell me where to send it.
Interesting… Please send the screenshot with PGC scan results to vladimir[at-sign]shinephp.com
Any additinal information, may be PHP error log messages will be useful too.
Do you use any cashing engine? Try to make full refresh for plugins page. Or clear your browser cach before open it. May be it will help. Is this issue exists for the PCG plugin only? What you WP shows for other plugins updated recently?
Dear Vladimir,
Hi Vladimir,
Nothing happens after clicking Scan. It's just plain without any tables displayed.
Screenshot: http://i44.tinypic.com/1gr4f6.jpg
Is Plugins Garbage Collector 0.4 compatible with version 2.9.2 ?
Thanks Will. You helped me to identify the problem with PGC plugin for webhosts running under MySQL 4. I will update the code to use “show table status” statement instead of direct query to information_schema.tables as information_schema database doesn't exist under MySQL 4.
Hi Hema,
Yes, PGC is compatible with WP 2.9.2. I developed it under 2.9.2 and use it myself under 2.9.2.
Is it your 1st try to Scan database with PGC plugin or previous versions worked for you?
Can you check PHP error log on your webhost? If yes, please send to it to my email vladimir[at]shinephp.com
If it is suitable for you I'm ready to check the problem directly on your site.
The good news is that my webhost (Dataflame they deserve a mention!) responded magnificently and less than 12 hours after I identified the problem (they were using MySQL 4.x) have upgraded MYsql to 5.2x and PHP to 5.2.9.
As a result PGC is working perfectly!
I am now trying your User Role Editor – so far, so good!
Thanks
Will
Hi Vladimir,
Sorry for the late reply. I was in the process of changing the host.
Earlier i complained that the plugin is not working. Now it's working PERFECTLY FINE.
Just in few seconds i cleared off the tables.
That's really a fantastic job.
Thank you very much for making this plugin
[...] удаленных плагинов, можно воспользоваться плагином Plugins Garbage Collector. После активирования плагина, нажать на сканирования. [...]
Hi Vladimir, I'm using Plugin Garbage Collector on WordPress 2.9.2
Every time I try to “Scan” I get a 504 Gateway Timeout error.
Thank you for help.
Hi Wpae,
It seems that you have a lot of plugins installed and PHP script execution time limit is exausted. PGC plugin tries to scan all plugins .php file for table names inclusion. It needs time.
Please confirm the large quant of plugins installed at your WP. I met one guy with 100+ plugins in /plugins folder, the most of which were deactivated.
Can you increase PHP script execution time limit? Of course it is possible for dedicated server only.
Possibly I should check the execution time left and return at least partial scanning results…
Thanks for the signal.
Hi Vladimir, every time I try to “Scan” I get a 504 gateway timeout error. How's possibile?
Hi!
Please read my answer on your previous comment below. I wait your next message.
Oh I'm sorry, I didn't see it.
No, I've got just 30 plugin installed, 23 activated and 7 deactivated.
What value for PHP max_execution_time parameter is set on your host?
Is it possible for you to email me your plugins list? I will build test environment similar to yours and check the issue.
Ok, I'm sending… thank you very much
Thanks. I received it. I will return with my investigations result in a couple of days.
[...] Garbage Collector Italian PGC ItalianItalian translation for the Plugins Garbage Collector WordPress plugin is available with version 0.5 published at May 12th, 2010. Thanks to Alessandro Mariani for the [...]
I made a test with 63 plugins installed, 30 from which are from your list. Look at screenshot
http://www.shinephp.com/wp-content/uploads/2010...
Scan process took 14 seconds only on my PC. Real server should fulfil this work much faster. Please check your web host PHP max_execution_time parameter.
the value of max_execution_time is 1800
I see that max_execution_time limit is not the problem in this case. Some other timeout is working here probably. I will refactor the scan operation with AJAX in order to show current progress of scanning process which should exclude such behaviour.
.
Thank you for the patience
P.S. Why do you not use 'Reply' button to keep our discission in the one thread?
I will use it, I promise!
Thank you for help.
Hi,
I updated plugin to work via AJAX with showing current progress. Please find time to try this beta version
http://www.shinephp.com/wp-content/downloads/wo...
Let me know how it works on your site and if timeout error is gone.
[...] }); }Plugins Garbage Collector Dutch TranslationDutch translation for the Plugins Garbage Collector WordPress plugin is available at May 25th, 2010 with version 0.6. Thanks to Arthur for the help with making Plugins [...]
Problem was in table meta data SQL query compatibility with MySQL version. It is fixed. I use more universal form now. Update will be published with next plugin version.
[...] pluginu jsem se dozvěděl díky WPressu - Pluings Garbage Collector jsem stáhnul z oficiálních stánek a přeložil. Štítky:čeština, plugin, WordPress [...]
[...] Plugins Garbage Collector : Voilà un plug-in très pratique pour les blogs WordPress assez anciens. Il permet de récupérer une liste des tables et champs de la base de données inutilisés puis de les supprimer. Une opération utile si vous avez installé puis désinstallé des plugins. Cela limitera la surcharge côté Mysql. [...]
[...] jQuery(document).ready(function($) { window.setTimeout('loadFBShareMe_5954()',5000); });/**/Das Garbage Collector Plugin von ShinePHP befreit die WordPress DB von Daten, die entferte Plugins hinterlassen haben. [...]