Update on: nginx makes mysqld die all the time

[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 setting:

mysql.allow_persistent = Off

in php.ini, and then tuning some php-fpm parameters as below, fixed
the problem. There surely still is much more that can be optimized
(and comments on the parameters below are welcome!) and I'll ask
about it later, but I haven't seen any more crashes,
and the websites already load quickly.

Thanks to all who helped!!!

Marco

pm = dynamic

pm.max_children = 12

pm.start_servers = 3

pm.min_spare_servers = 2

pm.max_spare_servers = 3

pm.max_requests = 10




















> mysqld dead but subsys locked
> 
> or
> 
> mysqld dead but pid file exists
> 
> for reasons not really relevant here I cannot post nginx conf
> right away. I **will** do that in a few hours, when I'm back
> at my desk. Since the crashes are so frequent, however, any
> help to save time is very welcome. Even if it's just request
> of other specific info, besides the nginx conf files.
> 
> TIA,
> Marco
> 
> _______________________________________________
> nginx mailing list
> nginx at nginx.org
> http://mailman.nginx.org/mailman/listinfo/nginx

-- 
http://mfioretti.com