Docker MySQL solves the problem of too many connections

Little scum · Posted on 10/8/2021 10:33:06 AM

The MySQL database is deployed using a Docker container, and when the number of client connections exceeds a certain number, the error "Too many connections" will be reported.

docker mysql image address:The hyperlink login is visible.

The image I am using is mysql:5.7.34 version, max_connections the default number is 151, as shown in the image below:

Temporary solutions

To set the maximum number of connections, the sql command is as follows:

Login is visible.

MySQL performance optimization sets max_connections maximum number of connections
https://www.itsvse.com/thread-10049-1-1.html

After restarting the docker container, the maximum number of connections is reset to the default of 151。

Thorough solution

Modify the /etc/mysql/mysql.cnf configuration file in the container and use the following command to copy the files in the container to the host machine:

Login is visible.

Modify the mysql.cnf file using the vim command as follows:

Login is visible.

Copy the host's files into the container with the following command:

Login is visible.

Restart the mysql container, and query the maximum number of connections through the SQL command, which shows the value we configured.

(End)

flying fish · Posted on 10/8/2021 8:59:42 PM

Another week has passed, let's take a look again

[Source] Docker MySQL solves the problem of too many connections

Related Posts

Sections viewed