Original: https://my.oschina.net/waknow/blog/205654Summary: When using the Go link database, too many connections errors occur after a period of time due to improper connection release. Therefore, appropriate selection functions and timely release
This is a creation in
Article, where the information may have evolved or changed.
These days with go write a simple server, connect MySQL database, provide API to other program calls to implement and delete adaptation and other services. The go
Mysql Error prompted too many connections, recently encountered this error, after the internet to solve the data, here record, to help needy friends,
The workaround is to modify the/ETC/MYSQL/MY.CNF and add the following line:
Set-variable =
Onenumber of IIS connectionsGenerally purchased virtual host friends are familiar with the purchase, will limit the number of IIS connections, as the name implies that the IIS server can accommodate the maximum number of connections requested by the
MySQL study--"Too many connections" error solutionThe error message is as follows :Can not connect to MySQL serverError:too Many connectionsErrno.: 1040Similar Error Report have beed dispatched to administrator before.The following is a description
From the official documentation know that the Linux compiler installed MySQL default connection of 100, so for the needs of the site is not enough.MySQL official tells us that we need to modify the value of max_connections, then how can we modify it?
The workaround is to modify the/ETC/MYSQL/MY.CNF and add the following line:
Set-variable = max_connections=500
Or add parameters to the startup command max_connections=500
is to modify the maximum number of connections, and then restart MySQL. The
The wrong hint is as follows
#/home/binbin.zhengbb/ssh/update_dns.sh
ERROR 1040 (08004): Too Many connections
ERROR 1040 (08004): Too Many connections
The reason for this error is that the amount of traffic is really high, the MySQL server will
From the official documentation that Linux compiled installed on the MySQL default connection of 100, so the site is not enough for the needs.
MySQL official told us that we need to modify the value of max_connections, so how do we modify it? There
Database connection Error: Error 1040 (HY000): Too Many connections 1. View the number of connectionshost -u root-p123456 Status This command returns several values for the current state of MySQLuptime:18869 threads:1 questions:1 Slow queries:0
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.