MySQL

MySQL の同時接続数 (max_connections) の変更

More than 5 years have passed since last update.

同時接続数を 500 に変更

稼働中のサーバで変更。

> set global max_connections=500;

> show global variables like '%connection%';
+--------------------------+-----------------+
| Variable_name | Value |
+--------------------------+-----------------+
| character_set_connection | utf8 |
| collation_connection | utf8_general_ci |
| max_connections | 500 |
| max_user_connections | 0 |
+--------------------------+-----------------+
4 rows in set (0.00 sec)

my.cnf にはこんな感じで。

[mysqld]

max_connections = 500