Find the problem Recently, I encountered a problem in the project. Due to too many connections, the prompt "Too many connections" appeared and I needed to increase the number of connections. I modified in /etc/my.cnf: max_connections = 2000 However, the actual number of connections is always limited to 214: mysql> show variables like "max_connections"; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 214 | +-----------------+-------+ 1 row in set think If I set the number of connections to less than 214, for example 200, then the actual number of connections is 200, which means there is no problem with my configuration file. Check the MySQL official documentation, which says: The maximum number of connections MySQL can support depends on the quality of the thread library on a given platform, the amount of RAM available, how much RAM is used for each connection, the workload from each connection, and the desired response time. Linux or Solaris should be able to support at 500 to 1000 simultaneous connections routinely and as many as 10,000 connections if you have many gigabytes of RAM available and the workload from each is low or the response time target undemanding. Windows is limited to (open tables × 2 + open connections) < 2048 due to the Posix compatibility layer used on that platform. It probably means that the maximum number of connections that MySQL can support is limited by the operating system. If necessary, you can increase the open-files-limit. In other words, the number of connections is related to the number of file opens. Workaround [root@sqzr ~]# ulimit -n 1024 It can be seen that the maximum file descriptor limit of the operating system is 1024. To change the maximum file descriptor limit for MySQL in Linux, edit the LimitNOFILE=65535 LimitNPROC=65535 After saving, execute the following command to make the configuration take effect $ systemctl daemon-reload $ systemctl restart mysqld.service The actual number of connections has reached 2000. mysql> show variables like "max_connections"; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 2000 | +-----------------+-------+ 1 row in set refer to https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html https://www.oschina.net/question/853151_241231 Summarize The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM. You may also be interested in:
|
<<: Implementation of adding visit count function in github+Jekyll blog in one minute with JS
>>: ffmpeg Chinese parameter description and usage examples
Today we will learn how to use CSS to create a co...
Table of contents tool Install the plugin Add a ....
CSS Layout - position Property The position attri...
Table of contents 1. The role of nginx process lo...
At the end of last year, I replaced the opensuse ...
background When developing a feature similar to c...
Table of contents What is Express middleware? Req...
background I want to check the webpack version, b...
I don't expect to be an expert DBA, but when ...
Preface Recently, I was working on a report funct...
Preface At work, I need to count the materials su...
Build the image Earlier we used various images fo...
Four practical vue custom instructions 1. v-drag ...
Friends who have bought space and built websites s...
Optimistic Locking Optimistic locking is mostly i...