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

Mr Pete

<p>The (mu-compatible) WP Tuner plugin for WordPress is a powerful and easy to use way to answer many hard questions about why your blog is slow or cranky. What’s causing the slowdown? Is it a plugin? Is it your host?</p>
<p>Used with a bit of common sense, this powerful plugin will help blog administrators as well as software developers improve their WordPress blog performance.</p>
<p>Perfect for WordPress site administrators, plugin and theme designers, developers</p>
<p>Fully translatable.</p>
<h3>Advanced Use</h3>
<p>Here are more advanced ways to make use of <em>WP Tuner</em>. Please <a href="http://blogs.icta.net/plugins/wptuner" title="(Visit the WP Tuner home page)" rel="nofollow ugc">share your questions and/or stories</a> examples to share with others!</p>
<p>1) Hook any WordPress action</p>
<p>In wptuner.php, you will find a default set of action hooks. You can add as many hooks as you like for other actions. They look like this (just change “admin_footer” to the name of the action you want to measure):</p>
<pre><code>add_action('admin_footer', 'wpTuneFilterTime' );
</code></pre>
<p>Each hook adds a line to the <em>WP Tuner</em> performance analysis table, when that action is triggered.</p>
<p>2) Time anything at all in WordPress</p>
<p>WP Tuner contains a function that causes performance analysis for any section of WordPress code. Just use<br />
  wpTuneMarkTime(‘My Marker string’);</p>
<p>…at the beginning of the code you want analyzed. Add another marker at the end if needed.</p>
<p>For example, suppose you want to know how much time is spent loading each of the plugins you have enabled. Here’s how to do it, by adding two simple lines to wp-settings.php:</p>
<pre><code>if (function_exists(wpTuneMarkTime)) wpTuneMarkTime('Load Plugins'); // ** Add THIS line **

if ( get_option('active_plugins') ) {
  $current_plugins = get_option('active_plugins');
  if ( is_array($current_plugins) ) {
    foreach ($current_plugins as $plugin) {
      if (function_exists(wpTuneMarkTime)) wpTuneMarkTime('Plugin: '.$plugin); // ** Add THIS line **
      if ( '' != $plugin && 0 == validate_file($plugin) && file_exists(WP_PLUGIN_DIR . '/' . $plugin) )
        include_once(WP_PLUGIN_DIR . '/' . $plugin);
    }
  }
}<h3>Credits</h3>
</code></pre>
<p>Many thanks to the WP Tuner translation team!</p>
<p>Русский: <a href="http://lecactus.ru" rel="nofollow ugc">Кактусу</a> (updated through WP Tuner 0.9.3)</p>
<h3>Readme Validator</h3>
<p>This readme was validated using:<br />
<a href="https://wordpress.org/extend/plugins/about/validator/" rel="ugc">https://wordpress.org/extend/plugins/about/validator/</a></p>


WP Tuner

Easily, powerfully, discover why your blog or plugin is slow or cranky. Comprehensive time and database access analyzer. WPmu. multi-lingual.

SQL Monitor vs WP Tuner