blocks|key|3873567|text|有多种工具可以满足这些需求：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3873568|3873569|MySQL+Enterprise+Monitor+Query+Analyzer+(Costs+$$$)+performance|unordered-list-item|offset|length|3873570|+|3873571|将记录、监视和查找慢查询、未索引的连接和持久连接，并提供有关如何改进MySQL+log的建议|3873572|3873573|​|3873574|3873575|mysqltuner+(opensource+perl+script)+|3873576|这将调试您的MySQL配置，并提供有关如何调整它以改进performance|3873577|3873578|的建议|3873579|3873580|3873581|mtop+(like+top,+but+for+MySQL,+free)+|3873582|这将监视慢速的queries|3873583|3873584|3873585|3873586|3873587|XDebug和Web+Grind+(PHP+performance，免费)|3873588|这将记录、监视和查找运行缓慢的scripts|3873589|3873590|3873591|3873592|3873593|New+Relic+(good+for+finding+slow+requests,+and+the+reason+why+they+where+slow,+free+or+paid)+|3873594|这将记录、监视和查找运行缓慢的脚本和queries|3873595|3873596|3873597|3873598|3873599|MySQL+Monitor+Tool+(Java，免费)|3873600|这将记录、监视和查找慢查询和持久connections|3873601|3873602|3873603|3873604|在网站笔记中，另一个很棒的工具是Toad+for+MySQL+(免费)，它提供完整的数据库管理(包括表、视图、触发器、函数、过程等)、图表和模式/数据比较功能。|3873605|我个人建议，为了：|3873606|企业监控器新遗物(如果在budget)|3873607|mysqltuner中，则为免费或付费计划)(只需使用一次或两次)|3873608|MySQL企业监视器(对于大多数情况来说太贵，但非常好)|3873609|3873610|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mysql.com/products/enterprise/monitor.html|1|https://github.com/rackerhacker/MySQLTuner-perl|2|http://mtop.sourceforge.net/|3|http://xdebug.org/|4|http://code.google.com/p/webgrind/|5|http://newrelic.com/|6|http://sourceforge.net/projects/mysqlmt/|7|http://www.quest.com/toad-for-mysql/^0|0|0|0|1F|0|0|0|0|0|0|0|0|Z|1|1|1|0|0|0|0|0|10|2|1|1|0|0|0|0|0|6|3|7|9|4|1|1|0|0|0|0|0|2K|5|1|1|0|0|0|0|0|I|6|1|1|0|0|0|G|E|7|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|2R|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|2S|8|@]|9|@$F|2T|G|2U|1|2V]]|A|$]]|$1|H|3|I|5|6|7|2W|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|2X|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|2Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|2Z|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|30|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|31|8|@]|9|@$F|32|G|33|1|34]]|A|$]]|$1|R|3|S|5|E|7|35|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|36|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|37|8|@]|9|@]|A|$]]|$1|W|3|N|5|6|7|38|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|39|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|E|7|3A|8|@]|9|@$F|3B|G|3C|1|3D]]|A|$]]|$1|10|3|11|5|E|7|3E|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|3F|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|3G|8|@]|9|@]|A|$]]|$1|14|3|N|5|6|7|3H|8|@]|9|@]|A|$]]|$1|15|3|-4|5|6|7|3I|8|@]|9|@]|A|$]]|$1|16|3|17|5|E|7|3J|8|@]|9|@$F|3K|G|3L|1|3M]|$F|3N|G|3O|1|3P]]|A|$]]|$1|18|3|19|5|E|7|3Q|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|3R|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|3S|8|@]|9|@]|A|$]]|$1|1C|3|N|5|6|7|3T|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|3U|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|E|7|3V|8|@]|9|@$F|3W|G|3X|1|3Y]]|A|$]]|$1|1G|3|1H|5|E|7|3Z|8|@]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|40|8|@]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|41|8|@]|9|@]|A|$]]|$1|1K|3|N|5|6|7|42|8|@]|9|@]|A|$]]|$1|1L|3|-4|5|6|7|43|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|E|7|44|8|@]|9|@$F|45|G|46|1|47]]|A|$]]|$1|1O|3|1P|5|E|7|48|8|@]|9|@]|A|$]]|$1|1Q|3|-4|5|6|7|49|8|@]|9|@]|A|$]]|$1|1R|3|-4|5|6|7|4A|8|@]|9|@]|A|$]]|$1|1S|3|N|5|6|7|4B|8|@]|9|@]|A|$]]|$1|1T|3|1U|5|6|7|4C|8|@]|9|@$F|4D|G|4E|1|4F]]|A|$]]|$1|1V|3|1W|5|6|7|4G|8|@]|9|@]|A|$]]|$1|1X|3|1Y|5|6|7|4H|8|@]|9|@]|A|$]]|$1|1Z|3|20|5|E|7|4I|8|@]|9|@]|A|$]]|$1|21|3|22|5|E|7|4J|8|@]|9|@]|A|$]]|$1|23|3|-4|5|6|7|4K|8|@]|9|@]|A|$]]|$1|24|3|-4|5|6|7|4L|8|@]|9|@]|A|$]]]|25|$26|$5|27|28|29|A|$2A|2B]]|2C|$5|27|28|29|A|$2A|2D]]|2E|$5|27|28|29|A|$2A|2F]]|2G|$5|27|28|29|A|$2A|2H]]|2I|$5|27|28|29|A|$2A|2J]]|2K|$5|27|28|29|A|$2A|2L]]|2M|$5|27|28|29|A|$2A|2N]]|2O|$5|27|28|29|A|$2A|2P]]]]

There is a variety of tools to service these needs:

<ul>
<li><a href="http://www.mysql.com/products/enterprise/monitor.html" rel="nofollow">MySQL Enterprise Monitor Query Analyzer (Costs $$$)</a> 
<ul>
<li>This will log, monitor, and find slow queries, un-indexed joins, and persistent connections, as well as giving advice on how to improve MySQL performance</li>
</ul></li>
<li><a href="https://github.com/rackerhacker/MySQLTuner-perl" rel="nofollow">mysqltuner (opensource perl script)</a>
<ul>
<li>This will debug you MySQL configuration and give suggestions on how to adjust it to improve performance</li>
</ul></li>
<li><a href="http://mtop.sourceforge.net/" rel="nofollow">mtop (like top, but for MySQL, free)</a>
<ul>
<li>This will monitor slow queries</li>
</ul></li>
<li><a href="http://xdebug.org/" rel="nofollow">XDebug</a> and <a href="http://code.google.com/p/webgrind/" rel="nofollow">Web Grind</a> (PHP performance, free) 
<ul>
<li>This will log, monitor and find slow scripts</li>
</ul></li>
<li><a href="http://newrelic.com/" rel="nofollow">New Relic (good for finding slow requests, and the reason why they where slow, free or paid)</a>
<ul>
<li>This will log, monitor, and find slow scripts and queries</li>
</ul></li>
<li><a href="http://sourceforge.net/projects/mysqlmt/" rel="nofollow">MySQL Monitor Tool</a> (Java, free)
<ul>
<li>This will log, monitor, and find slow queries, and persistent connections</li>
</ul></li>
</ul>

Also on a site note, another awesome tool is <a href="http://www.quest.com/toad-for-mysql/" rel="nofollow">Toad for MySQL</a> (free) which provides full database management (including tables, views, triggers, functions, procedures, etc), diagramming, and schema/data comparison functions.

I personally recommend, in order:

<ul>
<li>New Relic (free, or paid plan if its within budget)</li>
<li>mysqltuner (only needs to be used once or twice)</li>
<li>MySQL Enterprise Monitor (too expensive for most cases, but very good)</li>
</ul>

blocks|key|149082|text|您可以启用slow+query+log。作为调整最重要参数的起点，mysqltuner也是不错的选择。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|149083|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html^0|X|A|5|E|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

You can enable <a href="http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html" rel="nofollow">slow query log</a>. <code>mysqltuner</code> is also good as a starting point to tune most important params.

I have inherited a site running several different software packages worked on by several different people over several years, with lots of modifications and addons throughout.

How can I systematically, pervasively, and I hope automatically log/monitor/find scripts that use slow queries, persistent connections, unindexed joins, etc.?

MySQL Query and PHP Script Tuning: How can I find the problems?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我继承了一个网站，运行着几个不同的软件包，几年来由几个不同的人开发，并在整个过程中进行了大量修改和添加。我如何系统地、无处不在地，并希望自动地记录/监控/查找使用慢查询、持久连接、未索引连接等的脚本？

问MySQL查询和PHP脚本调优:如何发现问题？
EN

回答 2

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL查询和PHP脚本调优:如何发现问题？EN

回答 2

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL查询和PHP脚本调优:如何发现问题？
EN