MySQL 最大接続数変更

こんな風にする
mysql> show variables like ‘%connection%’;
+————————–+—————–+
| Variable_name | Value |
+————————–+—————–+
| character_set_connection | utf8 |
| collation_connection | utf8_general_ci |
| max_connections | 100 |
| max_user_connections | 0 |
+————————–+—————–+
4 rows in set (0.00 sec)
mysql> set global max_connections=512;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like ‘%connection%’;
+————————–+—————–+
| Variable_name | Value |
+————————–+—————–+
| character_set_connection | utf8 |
| collation_connection | utf8_general_ci |
| max_connections | 512 |
| max_user_connections | 0 |
+————————–+—————–+
4 rows in set (0.00 sec)

Thank you for reading this post, don't forget to subscribe!