java mysql max_MySQL 5.7中的max_connections

我遇到了一个问题，在我通过编辑my.cnf设置1000后，MySQL中max_connction的值是214，如下所示：

hadoop@node1:~$ mysql -V

mysql Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using EditLine wrapper

MySQL版本：5.7

操作系统版本：ubuntu 16.04LTS

mysql> show variables like 'max_connections';

+-----------------+-------+

| Variable_name | Value |

+-----------------+-------+

| max_connections | 151 |

+-----------------+-------+

1 row in set (0.00 sec)

我们可以看到，max_connections的变量值是151.然后，我编辑MySQL的配置文件 .

yang2@node1:~$ sudo vi /etc/mysql/my.cnf

[mysqld]

character-set-server=utf8

collation-server=utf8_general_ci

max_connections=1000

保存混淆后重启MySQL服务 .

yang2@node1:~$ service mysql restart

==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===

Authentication is required to restart 'mysql.service'.

Multiple identities can be used for authentication:

1. yangqiang,,, (yang2)

2. ,,, (hadoop)

Choose identity to authenticate as (1-2): 1

Password:

==== AUTHENTICATION COMPLETE ===

yang2@node1:~$

现在，我们猜max_connection是1000，真的吗？

mysql> show variables like 'max_connections';

+-----------------+-------+

| Variable_name | Value |

+-----------------+-------+

| max_connections | 214 |

+-----------------+-------+

1 row in set (0.00 sec)

这是214.我真的不明白这个结果，谁可以帮助我？谢谢！