Latency Tracker: PHP/mySQL tracking for Wordpress
Overview
I’ve had some forum peeps complain lately that the speed of their Wordpress install seems fast one day, slow the next, and mediocre the next. To give them some concerete data, I created the LatencyTracker plugin for Wordpress. This really simple plugin hooks into your wp_footer function (so make sure that your theme uses it) to count the number of queries, how long they took, and when it all occured. That way, they can show some solid data to the host so that they are able to compare numbers and know for sure that their load times are faster or slower when compared.
Install
- Download the zip at the bottom of this post and extract somewhere memorable on your storage device.
- Upload the latencytracker folder to your wp-content/plugins/ folder.
- Log in to your Wordpress dashboard and go to the plugins page.
- Activate the plugin
Uninstall
- Log in to your Wordpress dashboard and go to the plugins page.
- Deactivate the plugin. This will remove the table storing your data and remove the option info from your wp_options table.
- Delete the latencytracker folder in your wp-content/plugins/ folder
FAQ
- Which versions of Wordpress have you tested it with?
Wordpress 2.6+, 2.7+
- Will it work with my theme?
It should. Make sure that you footer.php in your theme folder includes a call to wp_footer(); or it won’t work. - This is stupid, it just stores data to a table and causes my site to slow down!
Sorry, it is my first WP plugin, and I’m trying to fill a very specific need, track PHP/mySQL response times. - My friends site is faster/slower then mine!
Each host is different. Mirror your site on another server for apples to apples comparison of the data.
Admin panel screenshots
Recent requests with Table Sorter
Graph of processing times with Fusion Charts
Data average
Download
- LatencyTracker 2.0.2
Bug fixes - LatencyTracker 2.0.1
Bug fix: Max records not trimming correctly - LatencyTracker 2.0
Added settings, error checks, and a cron job to keep table size down. Please deactivate and delete 1.x before you upgrade to 2.x. - LatencyTracker 1.5
Flash graphs and tabs - LatencyTracker 1.4
Better averages, minor bug fixes. - LatencyTracker 1.3
Added admin page under Manage >> Latency Tracker. You must have been using version 1.2 to replace it with 1.3. - LatencyTracker 1.2
Added page URI field. - LatencyTracker 1.1
Added a datetime field for easier tracking
- LatencyTracker 1.0
Initial release
Twitter
Feedburner
Thanks for the great plugin!
[...] I’ve updated my Wordpress PHP/mySQL Latency tracker to version 1.3. I wanted the admin to be able to see min, max, and avg times for the number of queries and processing time. I also wanted them to be able to view the last 50 requests. You can access the admin panel under Manage >> Latency Tracker. You can get the updated version on the plugin page. [...]
[...] the latest version on the plugin page. [...]
[...] my Latency Tracker plugin and make it ready for release as a formal Wordpress [...]
[...] updated my Latency Tracker plugin for Wordpress to version 2.0.In case you haven’t seen it before, here is a short blurb about it. The [...]
This is very good – works great on my wordpress installs but I use another mysql program called website baker as well as other mysql based applications. Could this be made into a stand alone program with appropriate calls installed on the footer of the program you wish to monitor? If so this would be great. I think it would gain wide appeal, many people would like the opportunity to monitor the performance of their mysql based applications across different hosting environments. Thanks
@Robert: I guess it could be, it’s not that hard to do. Take a look at the source and it should be pretty easy to port.