Tierra Lab
An all new version of Tierra’s WPDB Profiling Plugin for Wordpress has been released. The plugin, which we released January of 2009 displays all of the db queries at the very footer of the page showing any slow and potentially hazardous queries which can bring your db to a halt. The new version checks to see if you have db caching enabled, either via several plugins or via a built in WP_CACHE function. It also makes enabling it more automatic with a new administration interface.
New features include:
- New wp-admin interface allows you to toggle plugin settings. Options are (Always show profiling when logged in as an administrator?) and (Allow the ?show_queries=yes parameter in URL to show profiling?)
- Enable / Disable profiling on the front end when logged in as administrator (user Level 10) to the wp-admin interface.
- Enable / Disable ?show_queries=yes $_GET parameter via wp-admin config to allow / prevent url request for query list.
- Check whether WP_CACHE and SAVEQUERIES are set on the back end – display success / failure notices and suggestions if one is missing.
- Checks if define(‘WP_CACHE’, true); is present. If not, provides plugin suggestions for DB caching.
- Plugin automatically enabled if your user has Level 10 permissions (administrator) by default.
- If user Level < 10 or not logged in, you can continue to pass ?show_queries=yes via the url if you are not logged in.
- Sets define(‘SAVEQUERIES’, true); in plugin should it not be by default.
Front End View:

Back End View:

Download It:
http://wordpress.org/extend/plugins/wpdb-profiling/

This entry was posted on Wednesday, July 1st, 2009 at 3:26 pm . You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Leave a Reply
Copyright © 2010 Tierra Innovation, Inc.
July 16th, 2009 at 12:02 pm
[...] WordPress MU’s built-in features along with custom themes and plugins such as WPDB Profiling, they made it easier and much cheaper for WNET.ORG to roll out multiple sites that provide a great [...]
September 8th, 2009 at 10:39 am
I’ve been using both WPDB-Profiling and WP’s get_num_queries() function for a site I’m developing and noticed that the query total WPDB-Profiling returns is anywhere from 7-13 less than get_num_queries().
Any idea for the discrepancy?
Thanks
September 10th, 2009 at 7:35 pm
Wow… I was looking for something like that. It’s AWESOME. Congrats and thanks!
September 18th, 2009 at 10:40 am
Hi Jonathan – thanks for the note. We’re looking into the differences to see why the numbers are off. We’ll post a response here once we have a conclusion.
September 27th, 2009 at 9:22 pm
Is there any way to enable this for the admin page? I’m developing some plugins and admin type things – would love to be able to profile the back-end too.
September 28th, 2009 at 9:54 am
Sure – let me add some functionality and I’ll post a new release to Wordpress later today.
September 28th, 2009 at 10:10 am
I just uploaded the latest version to Wordpress. You should see it there in a few minutes.
November 1st, 2009 at 5:53 pm
Very useful. Thank you