maria-discuss team mailing list archive
Mailing list archive
connection limit, connection drops
I'm using MariaDB 5.5.33a on Debian Wheezy.
I have problems with connections from our PHP Application to MariaDB.
Then there is high traffic the concurrent connections goes up to 1700 -
If we have 1700 - 2200 concurrent connections we have sporadic
connection drops like: "Can't connect to mysql ....."
I have bumped the max_connection to 10000 and set some sysctl variables:
echo 55536 > cat /proc/sys/net/core/somaxconn
echo 10000 > /proc/sys/net/core/netdev_max_backlog
echo "1024 65535" > /proc/sys/net/ipv4/ip_local_port_range
echo "15"> /proc/sys/net/ipv4/tcp_fin_timeout
I have also bumped up the open files for the MySQL user.
The Mysql user of our application has no user connection limit in
The error is still present, does anybody has a idea about it?