SQL Monitor for WordPress

Registered 2010-08-29 by Vladimir Kolesnikov

Plugin to analyze queries made by WordPress and its plugins

Almost every developer knowns that the poor performance in many cases is due to poorly designed database or SQL queries (for example, when the table does not have indices that the query can use or when the query uses unnecessary performance killers such as ORDER BY/GROUP BY).

WordPress can provide only the list of the queries and the developer has to manually run every query and analyze it. Very boring, isn't it? SQLMon tries to help the developers and analyzes the query itself, reporting everything that needs attention.

Every query passed to WordPress is analyzed (using EXPLAIN) and the results are shown in the theme's footer or Admin panel's footer (they are visible to site administrators only — this allows to use SQLMon even on live sites).

One of the key features of SQLMon is that it can run EXPLAIN not only on SELECT queries but also on UPDATE/DELETE and INSERT/REPLACE INTO … AS or CREATE TABLE … AS.

The plugin is perfect for WordPress developers, plugin and theme authors and site administrators who are trying to find out why the blog is too slow.

Project information

Maintainer:
Vladimir Kolesnikov
Driver:
ICS
Development focus:

0.6 series 

lp:wp-plugin-sqlmon 
Browse the code

Programming Languages:
PHP
Licences:
Simplified BSD Licence
()

RDF metadata

View full history Series and milestones

wp-plugin-sqlmon 0.6 series is the current focus of development

Downloads

Latest version is 0.6.1.1
released on 2010-12-21

All downloads