Req #81501 [Com]: Log request information in slowlog

Edit report at https://bugs.php.net/bug.php?id=81501&edit=1 ID: 81501 Comment by: Michelle1698Jones at gmail dot com Reported by: wedwards at cyberfusion dot nl Summary: Log request information in slowlog Status: Open Type: Feature/Change Request Package: FPM related Operating System: Debian 10 PHP Version: 7.4.24 Block user comment: N Private report: N New Comment: The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. However, examining a long slow query log can be a time-consuming task. To make this easier, you can use the mysqldumpslow command to process a slow query log file and summarize its contents. See Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”. (https://www.wellcaremedicare.net/)github.com Previous Comments: ------------------------------------------------------------------------ [2021-10-04 13:46:00] wedwards at cyberfusion dot nl Description: ------------ When slowlog is enabled, and PHP-FPM announces it's going to log to the slowlog, some request information is written to the log message: proc.request_method, proc.request_uri, and proc.query_string. Code: https://github.com/php/php-src/blob/5b01c4863fe9e4bc2702b2bbf66d292d23001a18/sapi/fpm/fpm/fpm_request.c#L263 However, this information is not logged to the slowlog itself: https://github.com/php/php-src/blob/5b01c4863fe9e4bc2702b2bbf66d292d23001a18/sapi/fpm/fpm/fpm_php_trace.c#L52 . It would be very useful to log the request information to the slowlog as well, as it'd make debugging requests that were proxied to PHP-FPM easier. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=81501&edit=1