blocks|key|59289|text|mytop是一个很好的起点。它基本上是MySQL的首选，并将为您提供一个窗口，了解数据库到底在做什么：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59290|http://jeremy.zawodny.com/mysql/mytop/|offset|length|59291|诺亚|59292|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|12|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

mytop is a good place to start. It's basically top for MySQL, and will give you a window into what exactly your DB is doing:

<a href="http://jeremy.zawodny.com/mysql/mytop/" rel="nofollow noreferrer">http://jeremy.zawodny.com/mysql/mytop/</a>

Noah

blocks|key|59299|text|这可能是许多原因，因此可能需要大量的提示。一个不错的第一步是打开缓慢的查询日志，并手动或使用parser检查它。您可以选择特定的频繁使用、速度较慢的查询进行优化(可能是命中未索引的查询)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|59300|entityMap|0|LINK|mutability|MUTABLE|url|http://www.maatkit.org/doc/mk-query-digest.html^0|1A|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

It could be any number of reasons, so it could take a lot of proding. A good first step would be to turn on the slow query log, and go over it by hand or with a <a href="http://www.maatkit.org/doc/mk-query-digest.html" rel="nofollow noreferrer">parser</a>. You can pick specific heavily used, slow queries to optimize (perhaps ones that hit something unindexed)

blocks|key|991206|text|你能做的最好的事情就是分析你的应用程序代码。找出哪些调用占用了您的大量资源。下面是一些选项(谷歌搜索"php+profiler“的前三个关键词)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|991207|991208|Xdebug|unordered-list-item|offset|length|991209|NuSphere+PhpED|991210|DBG|991211|991212|您可能有一些SQL查询非常慢，但是如果它们不经常运行，它们可能不是性能问题的主要原因。您可能拥有速度更快的SQL查询，但它们的运行频率太高，因此对性能的净影响也更大。分析应用程序将有助于识别这些应用程序。|991213|就数据库使用而言，提高应用程序性能的最通用建议是识别不经常更改的数据，并将该数据放在缓存中以加快检索速度。这取决于您确定哪些数据将从中获益最多，因为它非常依赖于您的应用程序使用模式。|991214|就缓存技术而言，APC和memcached在PHP中都有很好的支持。|991215|您还可以仔细阅读MySQL+optimization+chapter，以确定与您的应用程序相关的任何改进。|991216|其他不错的资源是MySQL+Performance+Blog和“High+Performance+MySQL”这本书。如果你真的想运行一个基于MySQL的网站，你应该经常查阅这些资源。|991217|entityMap|0|LINK|mutability|MUTABLE|url|http://www.xdebug.org/docs/profiler|1|http://www.nusphere.com/products/php_profiler.htm|2|http://www.php-debugger.com/dbg/|3|http://php.net/apc|4|http://php.net/memcached|5|http://dev.mysql.com/doc/refman/5.1/en/optimization.html|6|http://www.mysqlperformanceblog.com/|7|https://rads.stackoverflow.com/amzn/click/com/0596101716^0|0|0|0|6|0|0|0|E|1|0|0|3|2|0|0|0|0|8|3|3|C|9|4|0|E|K|5|0|8|M|6|W|M|7|0^^$0|@$1|2|3|4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1K|8|@]|9|@$F|1L|G|1M|1|1N]]|A|$]]|$1|H|3|I|5|E|7|1O|8|@]|9|@$F|1P|G|1Q|1|1R]]|A|$]]|$1|J|3|K|5|E|7|1S|8|@]|9|@$F|1T|G|1U|1|1V]]|A|$]]|$1|L|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1Z|8|@]|9|@$F|20|G|21|1|22]|$F|23|G|24|1|25]]|A|$]]|$1|S|3|T|5|6|7|26|8|@]|9|@$F|27|G|28|1|29]]|A|$]]|$1|U|3|V|5|6|7|2A|8|@]|9|@$F|2B|G|2C|1|2D]|$F|2E|G|2F|1|2G]]|A|$]]|$1|W|3|-4|5|6|7|2H|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]|14|$5|Z|10|11|A|$12|15]]|16|$5|Z|10|11|A|$12|17]]|18|$5|Z|10|11|A|$12|19]]|1A|$5|Z|10|11|A|$12|1B]]|1C|$5|Z|10|11|A|$12|1D]]|1E|$5|Z|10|11|A|$12|1F]]|1G|$5|Z|10|11|A|$12|1H]]]]

The best thing you can do is to profile your application code. Find out which calls are consuming so much of your resources. Here are some options (the first three Google hits for "php profiler"):

<ul>
<li><a href="http://www.xdebug.org/docs/profiler" rel="nofollow noreferrer">Xdebug</a></li>
<li><a href="http://www.nusphere.com/products/php_profiler.htm" rel="nofollow noreferrer">NuSphere PhpED</a></li>
<li><a href="http://www.php-debugger.com/dbg/" rel="nofollow noreferrer">DBG</a></li>
</ul>

You might have some SQL queries that are very slow, but if they are run infrequently, they probably aren't a major cause of your performance problems. It may be that you have SQL queries that are more speedy, but they are run so often that their net impact to performance is greater. Profiling the application will help identify these.

The most general-purpose advice for improving application performance with respect to database usage is to identify data that changes infrequently, and put that data in a cache for speedier retrieval. It's up to you to identify what data would benefit from this the most, since it's very dependent on your application usage patterns.

As far as technology for caching, <a href="http://php.net/apc" rel="nofollow noreferrer">APC</a> and <a href="http://php.net/memcached" rel="nofollow noreferrer">memcached</a> are options with good support in PHP.

You can also read through the MySQL <a href="http://dev.mysql.com/doc/refman/5.1/en/optimization.html" rel="nofollow noreferrer">optimization chapter</a> carefully to identify any improvements that are relevant to your application.

Other good resources are <a href="http://www.mysqlperformanceblog.com/" rel="nofollow noreferrer">MySQL Performance Blog</a>, and the book "<a href="https://rads.stackoverflow.com/amzn/click/com/0596101716" rel="nofollow noreferrer" rel="nofollow noreferrer">High Performance MySQL</a>." If you're serious about running a MySQL-based website, you should be consulting these resources frequently.

blocks|key|58064|text|使用EXPLAIN帮助您优化查询/排除查询故障。它将向您显示表是如何被引用的，以及正在读取多少行。它非常有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|58065|另外，如果你对你的MySQL+configuration做了任何修改，你可能想要重新访问它。|58066|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/explain.html|1|http://books.google.com/books?id=btfeDZZdiC4C&lpg=PA72&ots=rOle9C2pHp&dq=mysql%2520configuration&pg=PP1^0|2|7|0|0|9|J|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Use <a href="http://dev.mysql.com/doc/refman/5.1/en/explain.html" rel="nofollow noreferrer">EXPLAIN</a> to help you optimize/troubleshoot your queries. It will show you how tables are referenced and how many rows are being read. It's very useful.

Also if you've made any modifications to your <a href="http://books.google.com/books?id=btfeDZZdiC4C&amp;lpg=PA72&amp;ots=rOle9C2pHp&amp;dq=mysql%20configuration&amp;pg=PP1" rel="nofollow noreferrer">MySQL configuration</a>, you may want to revisit that.

I've written a site CMS from scratch, and now that the site is slowly starting to get traffic (30-40k/day) Im seeing the server load a lot higher than it should be. It hovers around 6-9 all the time, on a quad core machine with 8gb of ram. I've written scripts that performed beautifully on 400-500k/day sites, so I'd like to think Im not totally incompetent. 

I've reduce numbers of queries that are done on every page by nearly 60% by combining queries, eliminating some mysql calls completely, and replacing some sections of the site with static TXT files that are updated with php when necessary. All these changes affected the page execution time (index loads in 0.3s, instead of 1.7 as before).

There is virtually no IOwait, and the mysql DB is just 30mb. The site runs lighttpd, php 5.2.9, mysql 5.0.77

What can I do to get to the bottom of what exactly is causing the high load? I really wanna localize the problem, since "top" just tells me its mysql, which hovers between 50-95% CPU usage at all times.

Whats a good way about troubleshooting a script in terms of performance (php/mysql)?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我从头开始写了一个网站CMS，现在网站开始慢慢地获得流量(30-40k/天)，我看到服务器的负载比它应该的要高得多。在内存为8 8gb的四核机器上，它一直在6-9之间徘徊。我写的脚本在400-500k/天的网站上表现得很好，所以我想我不是完全无能的。我已经通过组合查询，完全消除了一些mysql调用，并用静态TXT文件替...

问从性能(php/mysql)的角度来看，解决脚本问题的好方法是什么？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从性能(php/mysql)的角度来看，解决脚本问题的好方法是什么？EN