Increasing max_connections for Mysql
genai_works
PRO
4 months ago
Is it possible to increase max_connections of Mysql server bigger than 1000? Even if I set max_connections variable to 5000, it still allows only ±1000. Seems, it's on a side of OS (like file descriptor or something). Does it require to build a new repository with custom configuration for mysql ?
like this
docker run \
--name mysql \
--ulimit nofile=65536:65536 \
-e MYSQL_ROOT_PASSWORD=my-secret-pw \
-d mysql:latest
or like this
[mysqld]
max_connections = 5000
open_files_limit = 65535
1 Replies
echohack
EMPLOYEE
4 months ago
Status changed to Awaiting User Response Railway • 4 months ago
Status changed to Closed echohack • 4 months ago