內容簡介
幾乎所有的開發人員都知道，在許多情況下，性能不良是由設計不良的數據庫或 SQL 語句造成的（例如，當表沒有索引可用於查詢時，或者當查詢使用不必要的性能殺手，如 ORDER BY/GROUP BY 等）。
WordPress 只能提供查詢列表，開發人員必須手動運行每個查詢並進行分析。這樣很無聊，對吧？SQLMon試圖幫助開發人員，分析查詢本身，報告所有需要關注的內容。
每個傳遞給 WordPress 的查詢都被分析（使用 EXPLAIN），結果顯示在主題的頁腳或管理面板的頁腳中（只有站點管理員能夠看到，這樣即使在實際運行的站點上也可以使用 SQLMon）。
SQLMon 的一個關鍵特點是它不僅可以運行在選擇查詢上，在更新和刪除和插入和替換 INTO … AS 或 CREATE TABLE … AS 查詢中也可以運行 EXPLAIN。
這個外掛非常適合進行 WordPress 開發、外掛和主題作者以及站點管理員試圖找出為什麼博客變得太慢的人使用。
重要提示：此項目已移至Launchpad，請使用它來報告所有錯誤、建議改進、要求功能以及獲取最新的開發版本。
警告
插件需要安裝 PHP 5。
不支援古老的 PHP 4，抱歉。
不相容性
SQLMon 與在 wp-content 目錄中安裝自己的 db.php 的插件不相容（如 DB Cache、DB Cache Reloaded 和可能的 W3 Total Cache）。
刪除
如果您想完全刪除插件，請先停用插件，然後確保刪除 wp-content/db.php（如果沒有，請自行刪除）。
推薦閱讀
使用 EXPLAIN 優化查詢
錯誤報告
請使用Launchpad報告任何錯誤。
外掛標籤
開發者團隊
原文外掛簡介
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.
