設(shè)置mysql 5.6最大連接數(shù)的方法

mysql5.6連接數(shù)默認(rèn)是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> 

可以修改臨時(shí)生效：

mysql> set GLOBAL max_connections=500；

臨時(shí)修改為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> 

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

修改/etc/my.cnf(如果是二進(jìn)制安裝，修改對(duì)應(yīng)的my.cnf文件)

max_connections=1500

重啟，永久生效

顯示當(dāng)前運(yùn)行的Query：mysql> show processlist

顯示當(dāng)前狀態(tài)：mysql> show status