Update on: nginx makes mysqld die all the time

2015-08-25 Thread M. Fioretti
On 2015-08-18 15:23, M. Fioretti wrote: Greetings, I just migrated to nginx + php-fpm from apache a few websites, on a centos 6.6 virtual server. The sites are up but... now mysqld (MariaDB, actually) dies every 10/20 **minutes** with status: Greetings, after a few days, I can report that

Re: nginx makes mysqld die all the time

2015-08-19 Thread oscaretu .
Hello. Perhaphs this can help you about the out of memory: OOM Killer: https://www.google.com/search?client=ubuntuchannel=fsq=OOM+Kilerie=utf-8oe=utf-8 Kind regards, Oscar On Wed, Aug 19, 2015 at 8:02 AM, M. Fioretti mfiore...@nexaima.net wrote: On 2015-08-18 14:36, Steve Wilson wrote:

Re: nginx makes mysqld die all the time

2015-08-19 Thread Steve Wilson
It looks like your machine is running out of memory, again this is something I think I've dealt with in php-fpm by configuring it to recycle the child processes so they don't start consuming too much memory. Here's my fpm pool config file: [www] user = www-data group = www-data listen =

nginx makes mysqld die all the time

2015-08-18 Thread M. Fioretti
Greetings, I just migrated to nginx + php-fpm from apache a few websites, on a centos 6.6 virtual server. The sites are up but... now mysqld (MariaDB, actually) dies every 10/20 **minutes** with status: mysqld dead but subsys locked or mysqld dead but pid file exists for reasons not

Re: nginx makes mysqld die all the time

2015-08-18 Thread Steve Wilson
Hi, When I migrated from apache+mod_php to nginx+php-fpm I found I had a few websites using persistent mysql connections which never closed. I had to disable this in the php.ini so all the sites fell back to using non-persistent connections. I don't know if this will help as it was mysql not

Re: nginx makes mysqld die all the time

2015-08-18 Thread M. Fioretti
On 2015-08-18 14:36, Steve Wilson wrote: Hi, When I migrated from apache+mod_php to nginx+php-fpm I found I had a few websites using persistent mysql connections which never closed. Steve, thanks for this tip. This surely was part of the problem, but not all of it. Sure enough, when I first