mysql - max_connections 选项不适用于 mysqld

Question

我已经设置max_connections=2000在/etc/my.conf并重新启动mysqld

但仍然max_connections似乎被困在 412

mysql>  SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 412  |
+-----------------+-------+
1 row in set (0.01 sec)

mysql>

我也尝试过重新启动mysqld发布

mysql> SET GLOBAL max_connections = 2000;

但我仍然得到 max_connections | 412来自查询SHOW VARIABLES LIKE "max_connections";

Answer 1

1. 为服务文件创建覆盖

   systemctl编辑mysql.service

2. 添加以下内容

    [Service]
    LimitNOFILE=4096

重新启动 MySQL 服务器

重启mysql服务