這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

SQL Monitor

外掛說明

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.

IMPORTANT: the project has moved to Launchpad, please use it to report all bugs, suggest improvements,
request features and get the latest development version.

Warning

This plugins requires that PHP 5 be installed.
No support for ancient PHP 4, sorry.

Incompatibilities

SQLMon is incompatible with plugins that install their own db.php into wp-content directory (DB Cache, DB Cache Reloaded, probably W3 Total Cache).

Removal

If you want to remove the plugin completely, please deactivate it first and make sure that wp-content/db.php is deleted (if not, please delete it yourself).

Recommended Reading

Optimizing Queries with EXPLAIN

Bug Reports

Please use Launchpad to report any bugs.

螢幕擷圖

  • This is how the results might look.

安裝方式

  1. Upload sqlmon folder to the /wp-content/plugins/ directory.
  2. Please make sure that wp-content directory is writable by your web server (when activated, SQLMon will copy db.php to wp-content).
  3. Activate the plugin through the ‘Plugins’ menu in WordPress.
  4. If everything is fine, you will see db.php in your wp-content directory.

常見問題集

None yet. Be the first to ask.

使用者評論

這個外掛目前沒有任何使用者評論。

參與者及開發者

以下人員參與了開源軟體〈SQL Monitor〉的開發相關工作。

參與者

將〈SQL Monitor〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

0.6.1.1

0.6.1

  • Bugs fixed: LP #628621
  • Display how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and other notes about the optimization process
  • More details

0.6

  • WordPress 3.1-alpha compatibility (LP #627209)

0.5.9

  • CONNECT times are now also shown in the logs

0.5.8.1

  • Removed forgotten unserialize()

0.5.8

  • Code optimization. Got rid of EXPLAIN serialization.

0.5.7

  • Added a check if wp-content/db.php exists before trying to remove it on deactivation (no errors are thrown if the file does not exist)
  • Minor cleanups
  • Minified CSS

0.5.6

  • Major code refactoring

0.5.4

  • Code cleanup
  • Throws a warning when wp-content/db.php cannot be removed on plugin deactivation
  • Does not cause the white screen of death when the plugin is removed and wp-content/db.php is not.

0.5.1

  • Code cleanup
  • Support for multiple databases

0.5

  • First public avaliable version