設置mysql 5.6最大連接數的方法

mysql5.6連接數默認是151

mysql> select version();

+------------+

| version()  |

+------------+

| 5.6.25-log |

+------------+

1 row in set (0.00 sec)

mysql> show variables like '%max_connection%';

+-----------------+-------+

| Variable_name   | Value |

+-----------------+-------+

| max_connections | 151   |

+-----------------+-------+

1 row in set (0.00 sec)

mysql> 

可以修改臨時生效：

mysql> set GLOBAL max_connections=500；

臨時修改為500，重啟后失效

mysql> set GLOBAL max_connections=500;

Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%max_connection%';

+-----------------+-------+

| Variable_name   | Value |

+-----------------+-------+

| max_connections | 500   |

+-----------------+-------+

1 row in set (0.00 sec)

mysql> 

可以通過修改mysql配置文件，永久生效

修改/etc/my.cnf(如果是二進制安裝，修改對應的my.cnf文件)

max_connections=1500

重啟，永久生效

顯示當前運行的Query：mysql> show processlist

顯示當前狀態：mysql> show status