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

同時接続数を 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