I don't know what max_connections in Mysql use for, but if you want to check it using this command
Code:
SHOW VARIABLES LIKE "max_connections";
on my hosting, the result is
Code:
mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
1 row in set (0.00 sec)
You can change max_connections while MySQL is running via SET:
Code:
SET GLOBAL max_connections = 10000;
After changed, I have the result as following
Code:
mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 10000 |
+-----------------+-------+
1 row in set (0.00 sec)
Hope that helps!
