Discover mysql persistent connections, include the articles, news, trends, analysis and practical advice about mysql persistent connections on alibabacloud.com
What is persistent connection?
In fact, persistent connections are relative to common short connections, that is, to maintain the connection between the client and the server for a long time.
The common short connection procedure is as follows:
A long time ago, I also studied the difference between mysqlnd and libmysql, the connection driver of phpmysqlclient, and the communication between php and mysql, this time I encountered another thing that had something to do with them, the
A long time ago, I also because of the work of the bug, the PHP MySQL client connection driver Mysqlnd and libmysql between the difference between PHP and MySQL communication that thing, this time again encountered a connection with their things,
Verification of retained re-testPHP API, MySQL with Mysqli's persistent connection area ...A long time ago, I was also because of the work of the bug, the PHP MySQL client connection to drive Mysqlnd and libmysql the difference between PHP and MySQL
What is persistent connection?In fact, persistent connections are relative to common short connections, that is, to maintain the connection between the client and the server for a long time.The common short connection procedure is as
Set the maximum number of mysql connections in CentOS to 1040 too persistent connection and centosmysql.When the maximum number of connections is small, the error "1040 too connection" may occur.You can modify the configuration file to modify the
In some cases, mysql_pconnect () is not applicable.
---------------------------
Status 1:
One Web server and one MySQL Server (the two may be on the same host) are used, while the Web server is fixed to only access a database on the MySQL
How to solve the problem that the number of MySQL connections exceeds the limit: the User database name has already more than 'max _ user_connections 'active connections error is reported on the website recently. It is necessary to study this
How to solve the problem that MySQL exceeds the maximum number of connections. Recently, the User database name hasalreadymorethanmax_user_connectionsactiveconnections error is reported on the website. It is necessary to study this problem. Max_user_
Recent website appears User database name has already more than ' max_user_connections ' Active connections error, website paralyzed. It is necessary to study the problem.
Max_user_connections is the maximum number of MySQL user connections set,
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.