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
[email protected]
http://mailman.nginx.org/mailman/listinfo/nginx
--
http://mfioretti.com
_______________________________________________
nginx mailing list
[email protected]
http://mailman.nginx.org/mailman/listinfo/nginx