Vladimir Kolesnikov

<p>Almost every developer knowns that the poor performance in many cases is due to poorly designed database or SQL queries<br />
(for example, when the table does not have indices that the query can use or when the query uses unnecessary<br />
performance killers such as ORDER BY/GROUP BY).</p>
<p>WordPress can provide only the list of the queries and the developer has to manually run every query and analyze it.<br />
Very boring, isn’t it? SQLMon tries to help the developers and analyzes the query itself, reporting everything that needs attention.</p>
<p>Every query passed to WordPress is analyzed (using EXPLAIN) and the results are shown in the theme’s footer or Admin panel’s footer<br />
(they are visible to site administrators only — this allows to use SQLMon even on live sites).</p>
<p>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<br />
CREATE TABLE … AS.</p>
<p>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.</p>
<p><strong>IMPORTANT:</strong> the project has moved to <a href="https://launchpad.net/wp-plugin-sqlmon" rel="nofollow ugc">Launchpad</a>, please use it to report all bugs, suggest improvements,<br />
request features and get the latest development version.</p>
<h3>Warning</h3>
<p>This plugins requires that PHP 5 be installed.<br />
No support for ancient PHP 4, sorry.</p>
<h3>Incompatibilities</h3>
<p>SQLMon is incompatible with plugins that install their own <code>db.php</code> into <code>wp-content</code> directory (DB Cache, DB Cache Reloaded, probably W3 Total Cache).</p>
<h3>Removal</h3>
<p>If you want to remove the plugin completely, please deactivate it first and make sure that <code>wp-content/db.php</code> is deleted (if not, please delete it yourself).</p>
<h3>Recommended Reading</h3>
<p><a href="http://dev.mysql.com/doc/refman/5.1/en/using-explain.html" rel="nofollow ugc">Optimizing Queries with EXPLAIN</a></p>
<h3>Bug Reports</h3>
<p>Please use <a href="https://bugs.launchpad.net/wp-plugin-sqlmon" rel="nofollow ugc">Launchpad</a> to report any bugs.</p>


SQL Monitor

Almost every developer knowns that the poor performance in many cases is due to poorly designed database or SQL queries

Avram

<p>Ultimate debug bar for your WordPress website. On each page of your website a neat debug bar will be displayed with the following info:</p>
<ul>
<li>PHP version</li>
<li>Request execution time</li>
<li>Request memory consumption</li>
<li>WordPress-related PHP constants defined in your wp-config.php file</li>
<li>All website options (wp_options)</li>
<li>Request data</li>
<li>Timeline (waterfall) where you can see which portion of execution takes too much time</li>
<li>List of all hooks triggered on the page whose execution time exceeds 1ms, along with some stats</li>
<li>List of all database queries performed on the page, along with their source and execution time</li>
<li>Last 100 lines of your debug.log file (if it exists in wp-content)</li>
<li>List of loaded PHP files (categorized)</li>
</ul>
<p>Besides that, it will track request data/hooks/db queries/mem. consumption in AJAX calls too (beta).</p>
<p>This plugin is meant to be used during development and/or debugging only. Only administrators and network administrators (in multi-site environment) can see the debugbar, unless the <code>WP_DEBUG</code> is set to <code>true</code>. In that case, everyone will see the debugbar.</p>
<p>Try it instantly on <a href="https://tastewp.com/new?pre-installed-plugin-slug=ultimate-debugbar&redirect=%2F&ni=true" rel="nofollow ugc">tastewp.com</a>!</p>


Ultimate DebugBar

Ultimate debug bar for your Wordpress website.

SQL Monitor vs Ultimate DebugBar