blocks|key|1302415|text|首先是xdebug，它有一个分析器，但我不会在生产机器上使用它，因为它注入代码并使速度变得缓慢。不过，这对于测试环境来说非常好。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1302416|如果您想在生产环境中测量速度，我只需要手动测量即可。microtime()就是用来处理这些事情的函数。假设你有一个header.php和一个footer.php，所有的php脚本都会调用它们：|style|CODE|1302417|#+In+your+header.php+(or+tpl)
$GLOBALS['_execution_start']+=+microtime(true);

#+In+your+footer.php+(or+tpl)
file_put_contents(
++++'/tmp/my_profiling_results.txt',
++++microtime(true)+-+$GLOBALS['_execution_start']+.+':'+.+print_r($_SERVER,+true)+.+"\n",
++++FILE_APPEND
);|code-block|syntax|javascript|1302418|entityMap|0|LINK|mutability|MUTABLE|url|http://www.xdebug.org/|1|http://de.php.net/manual/en/function.microtime.php^0|3|6|0|0|Q|B|Q|B|1|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@$A|11|B|12|F|G]]|9|@$A|13|B|14|1|15]]|C|$]]|$1|H|3|I|5|J|7|16|8|@]|9|@]|C|$K|L]]|$1|M|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

First, there is <a href="http://www.xdebug.org/" rel="nofollow noreferrer">xdebug</a>, which has a profiler, but I wouldn't use that on a production machine, since it injects code and brings the speed to a crawl. Very good for testing environments, though.

If you want to measure speeds on a productive environment, I would just to the measuring manually. <a href="http://de.php.net/manual/en/function.microtime.php" rel="nofollow noreferrer"><code>microtime()</code></a> is the function for these things in PHP. Assuming you have a header.php and a footer.php which get called by all php scripts:

<pre><code># In your header.php (or tpl)
$GLOBALS['_execution_start'] = microtime(true);

# In your footer.php (or tpl)
file_put_contents(
 '/tmp/my_profiling_results.txt',
 microtime(true) - $GLOBALS['_execution_start'] . ':' . print_r($_SERVER, true) . "\n",
 FILE_APPEND
);
</code></pre>

blocks|key|4095536|text|http://blog.xrado.si/post/php-slow-log刚刚写了一篇关于auto_prepend_file和auto_append_file的文章|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4095537|entityMap|0|LINK|mutability|MUTABLE|url|http://blog.xrado.si/post/php-slow-log^0|0|12|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]]]]

what about auto_prepend_file and auto_append_file,
just wrote a post about it <a href="http://blog.xrado.si/post/php-slow-log" rel="noreferrer">http://blog.xrado.si/post/php-slow-log</a>

blocks|key|877354|text|您可以将脚本包装在一个简单的计时器中，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|877355|/*in+your+header+or+at+the+top+of+the+page*/
$time_start+=+microtime(true);+

/*+your+script+goes+here+*/

/*in+your+footer,+or+at+the+bottom+of+the+page*/
$time_end+=+microtime(true);
$time+=+$time_end+-+$time_start;+++
echo+"It+took+$time+seconds\n";|code-block|syntax|javascript|877356|请注意，这将增加两个函数执行和少量的数学开销。|877357|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You could wrap your scripts in a simple timer, like this:

<pre><code>/*in your header or at the top of the page*/
$time_start = microtime(true); 

/* your script goes here */

/*in your footer, or at the bottom of the page*/
$time_end = microtime(true);
$time = $time_end - $time_start; 
echo "It took $time seconds\n";
</code></pre>

Note that will add two function executions and a tiny bit of math as overhead.

blocks|key|877437|text|你可以不注册一个调用计时器结束的关闭函数吗？http://us3.php.net/register_shutdown_function这样你只需要在你认为可能有问题的地方启动计时器。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|877438|entityMap|0|LINK|mutability|MUTABLE|url|http://us3.php.net/register_shutdown_function^0|M|19|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]]]]

Could you not register a shutdown function that calls an end to the timer? <a href="http://us3.php.net/register_shutdown_function" rel="nofollow noreferrer">http://us3.php.net/register_shutdown_function</a> That way you only need to start the timer wherever you think there might be a problem.

blocks|key|1516|text|如果你正在使用FastCGI来执行你的FastCGI脚本，你可以使用Process+(FPM，php-fpm)，它也支持所谓的“慢日志”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1517|您可以在php-fpm的php配置中启用它(对于debian，它在/etc/php5/fpm/pool.d/www.conf中)，配置选项为:+request_slowlog_timeout和slowlog。|offset|length|style|CODE|1518|1519|+request_slowlog_timeout|blockquote|1520|1521|为单个请求提供服务的超时时间，超过此时间后，PHP回溯将被转储到'slowlog‘文件中。值“0”表示“关闭”。可用单位:s(秒)(默认)、m(分钟)、h(我们的)或d(天)。默认值:+0。|1522|慢日志|1523|慢速请求的日志文件。默认值：#INSTALL_PREFIX#/log/php-fpm.log.low。|1524|1525|来自http://php.net/manual/en/install.fpm.configuration.php|1526|另请参阅：http://php.net/manual/en/install.fpm.php和http://rtcamp.com/tutorials/php/fpm-slow-log/|1527|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/install.fpm.configuration.php|1|http://php.net/manual/en/install.fpm.php|2|http://rtcamp.com/tutorials/php/fpm-slow-log/^0|0|X|T|0|0|0|0|0|0|0|0|2|1I|0|0|5|14|1|1A|19|2|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1E|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1I|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1K|8|@]|9|@$D|1L|E|1M|1|1N]]|A|$]]|$1|V|3|W|5|6|7|1O|8|@]|9|@$D|1P|E|1Q|1|1R]|$D|1S|E|1T|1|1U]]|A|$]]|$1|X|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]|15|$5|10|11|12|A|$13|16]]|17|$5|10|11|12|A|$13|18]]]]

If you are using FastCGI for executing your PHP scripts you can use the FastCGI Process Manager (FPM, php-fpm) which also supports a so called “slowlog”.

You can enable it in the php configuration of your php-fpm (for debian this is in <code>/etc/php5/fpm/pool.d/www.conf</code>) with the config options: request_slowlog_timeout and slowlog.

<blockquote>
 request_slowlog_timeout
 
 The timeout for serving a single request after which a PHP backtrace will be dumped to the 'slowlog' file. A value of '0' means
 'Off'. Available units: s(econds)(default), m(inutes), h(ours), or
 d(ays). Default value: 0.
 
 slowlog
 
 The log file for slow requests. Default value: #INSTALL_PREFIX#/log/php-fpm.log.slow.
</blockquote>

from <a href="http://php.net/manual/en/install.fpm.configuration.php" rel="nofollow">http://php.net/manual/en/install.fpm.configuration.php</a>

Also see: <a href="http://php.net/manual/en/install.fpm.php" rel="nofollow">http://php.net/manual/en/install.fpm.php</a> and <a href="http://rtcamp.com/tutorials/php/fpm-slow-log/" rel="nofollow">http://rtcamp.com/tutorials/php/fpm-slow-log/</a>

I am working on optimizing my site, and I have had the MySQL slow queries log on for a few days now, but after going through >260M queries, it only logged 6 slow queries, and those were special ones executed by me on phpMyAdmin. I am wondering if there is something to log slow PHP page execution time so that I can find certain pages that are hogging resources, rather than specific queries.

PHP equivalent to MySQL's slow query log?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我正在优化我的网站，我已经让MySQL慢查询登录了几天，但在经历了超过260M的查询后，它只记录了6个慢查询，这些都是我在phpMyAdmin上执行的特殊查询。我想知道是否有什么东西可以记录缓慢的PHP页面执行时间，以便我可以找到某些占用资源的页面，而不是特定的查询。

问PHP相当于MySQL的慢查询日志？
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP相当于MySQL的慢查询日志？EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP相当于MySQL的慢查询日志？
EN