2

I was having an issue with PHP-FPM and mysql. When I needed to process an input file that would generate several selects/inserts/updates for each line, it would stop after approximately 60s with message Lost connection to the server or Mysql server has gone away. The queries were simple, just update a few fields, no BLOBs, less than 1KB each.

Disabling PHP-FPM for MOD_PHP solved the issue - but it was not a ini setting problem, because they both shared the same ini file.

It turned out to be request_slowlog_timeout as suggested by this question. It doesn't make sense because it isn't supposed to terminate or interfere with the script execution, as I understand

My question is, is it a bug in PHP-FPM or it's just that I'm missing something?

Server Config:

Percona Mysql 5.5.19, Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/1.0.0-fips Domain Server mod_fastcgi/2.4.6 mod_perl/2.0.5 Perl/v5.10.1, PHP 5.3.24

Daniel Costa
  • 317
  • 1
  • 3
  • 12

0 Answers0