Tierra Innovation

Tierra Lab

WPDB Profiling 1.1 Released

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:
WPDB Front End

Back End View:
WPDB BackEnd

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

Bookmark and Share

8 Responses to “WPDB Profiling 1.1 Released”

  1. Fifty Sites. Ten Months. One CMS. « WordPress Publisher Blog Says:

    [...] 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 [...]

  2. jonathan Says:

    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

  3. Juarez P. A. Filho Says:

    Wow… I was looking for something like that. It’s AWESOME. Congrats and thanks!

  4. Todd Says:

    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.

  5. Will Says:

    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.

  6. Todd Says:

    Sure – let me add some functionality and I’ll post a new release to Wordpress later today.

  7. Todd Says:

    I just uploaded the latest version to Wordpress. You should see it there in a few minutes.

  8. Zoolander Says:

    Very useful. Thank you


Leave a Reply

Copyright © 2010 Tierra Innovation, Inc.