Too many connections

from the Artful MySQL Tips List


Limits on max_connections in MySQL ...

The default max connections = 151

At 214, connections are limited by max open files

At 4,915, connections are limited by systemd max_tasks

Near 8,000, connections are limited by the maximum number of processes as reported by running pgrep -o mysql )/limits

If you needt 10,000 processes, try ...


root@debian:~# cat /etc/systemd/system/mysql.service.d/override.conf

[Service]

LimitNOFILE=11000

LimitNPROC=11000

TasksMax=11000



More

Return to the Artful MySQL Tips page