Answer the question
In order to leave comments, you need to log in
How to track why MySQL too many connections crashes?
Site on magento. Periodically crashes with "too many connections" error.
In the config max_connections 250 (should it be increased?)
online is small, at the same time 500 - 1000
How can I track what lays down the base?
Answer the question
In order to leave comments, you need to log in
It does not crash, but refuses to accept new connections due to the exhaustion of the max_connections limit specified in the config.
There is a separate page in the manual
. For mysql, connections are not so heavy relative to the same postgresql and max_connections can be increased quite well.
What connections are open and from where you can see in show processlist
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question