Mysql/設定

設定ファイル

/etc/my.cnf

最大接続数変更

default

mysql> show variables like 'max_connections%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |

変更

$ /etc/my.cnf
[mysqld]
max_connections=500

mysql> show variables like 'max_connections%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 500   |