当前位置: 代码迷 >> MySQL >> mysql 增多连接数
  详细解决方案

mysql 增多连接数

热度:255   发布时间:2016-05-05 16:31:01.0
mysql 增加连接数
mysql Error 1040 too many connection解决办法:
[email protected]_mysql:~$ mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 35761Server version: 5.6.27-0ubuntu0.14.04.1 (Ubuntu)Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set global max_connections = 3600;Query OK, 0 rows affected (0.00 sec)mysql> select VARIABLE_VALUE from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME='MAX_CONNECTIONS';+----------------+| VARIABLE_VALUE |+----------------+| 3600           |+----------------+1 row in set (0.00 sec)mysql> quitBye[email protected]_mysql:~$ sudo service mysql restart[sudo] password for cjd: mysql stop/waitingmysql start/running, process 11517[email protected]_mysql:~$ 
  相关解决方案