The max_connections in MySQL 5.7 : <p>I met a problem, the value of max_connction in MySQL is 214 after I set it 1000 via edit the my.cnf, just like below:</p>

<pre><code>hadoop@node1:~$ mysql -V
mysql  Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using  EditLine wrapper
</code></pre>

<p>MySQL version: 5.7</p>

<p>OS version   :   ubuntu 16.04LTS</p>

<pre><code>mysql&gt; show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.00 sec)
</code></pre>

<p>As we can see, the variable value of max_connections is 151. Then , I edit the configuration file of MySQL.</p>

<pre><code>yang2@node1:~$ sudo vi /etc/mysql/my.cnf
[mysqld]

character-set-server=utf8
collation-server=utf8_general_ci
max_connections=1000
</code></pre>

<p>Restart MySQL service after save the configraion.</p>

<pre><code>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:~$ 
</code></pre>

<p>Now, we guess the max_connection is 1000, really?</p>

<pre><code>mysql&gt; show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 214   |
+-----------------+-------+
1 row in set (0.00 sec)
</code></pre>

<p>It is 214. I do not really understand this result, who can help me? thx!</p>
