MySQL Number of connections

I am using a database that does not have other related settings for it, and recently there are frequent connection anomalies, which are too many connections.

MySQL view maximum number of connections and modify maximum connections

1. View the maximum number of connections (you can view other global parameters via show variables). Typically, the maximum number of connections to MySQL is 100 by default, up to 16384.
Show variables like '%max_connections% ';

Display variable information, selectable range, Global | Session | Local, follow show behind

2. Modify the maximum number of connections
Set GLOBAL max_connections = 200;

When the connection request is greater than the number of connections set, there is an error that the database could not be connected, such as: "Can not connect to MySQL server." Too many connections "-mysql 1040 error because the number of connections that have not yet been released to MySQL has reached the maximum MySQL limit. The problem with this approach is that the maximum number of connections set is only valid in the MySQL current service process and will revert to its original state once MySQL restarts. Because the initialization after MySQL starts is to read the data from its configuration file, this method does not make changes to its configuration file.

Second: Modify the MySQL maximum connection number (Max_connections) by modifying the configuration file.

This approach is simple, just modify the MySQL configuration file my.ini or my.cnf parameters max_connections, change it to max_connections=1000, and then restart MySQL. But one of the hardest is My.ini where this file is found. Usually there are two possible, one is in the installation directory, the other is in the directory of data files, when installed if there is no man to change the directory, generally in the C:/programdata/mysql down the directory, Linux system generally in/etc directory.

the variable description in the global variable, please refer to http://www.jb51.net/article/48082.htm

MySQL Number of connections