I
I
ipokos2018-03-03 23:42:28
MySQL
ipokos, 2018-03-03 23:42:28

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

1 answer(s)
M
Melkij, 2018-03-03
@ipokos

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 question

Ask a Question

731 491 924 answers to any question