title: Buffered warning: Changed limits: max_connections: 214 (requested 800)
body: <p>Everytime I restart MySQL I have this warning: </p>
  
  <blockquote>
    <p>[Warning] Buffered warning: Changed limits: max_connections: 214 (requested 800)</p>
  </blockquote>
  
  <p>So I have to change <code>max_connections</code> variable:</p>
  
  <pre><code>set global max_connections = 800;
  </code></pre>
  
  <p>But <code>/etc/my.cf</code> has <code>max_connections</code> set:</p>
  
  <pre><code>[mysqld_safe]
  log-error=/var/log/mysqld.log
  pid-file=/var/run/mysqld/mysqld.pid
  max_connections = 800
  </code></pre>
  
  <p>I also modified <code>mysqld.service</code>:</p>
  
  <pre><code># Start main service
  ExecStart=/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf
  </code></pre>
  
  <p>I've also updated max open files of Centos from 1024 to 2000: </p>
  
  <pre><code>ulimit -Sa | grep "open files"
  open files                      (-n) 2000
  </code></pre>
  
  <p>But the problem persists.</p>
  
  <p>Mysql log start:</p>
  
  <pre><code>150924 13:15:04 mysqld_safe mysqld from pid file 
  
  /var/run/mysqld/mysqld.pid ended
  150924 13:15:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  2015-09-24 13:15:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2015-09-24 13:15:04 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25) starting as process 29997 ...
  2015-09-24 13:15:04 29997 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
  
  2015-09-24 13:15:04 29997 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 800)
  
  2015-09-24 13:15:04 29997 [Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 2000)
  
  2015-09-24 13:15:04 29997 [Note] Plugin 'FEDERATED' is disabled.
  2015-09-24 13:15:04 29997 [Note] InnoDB: Using atomics to ref count buffer pool pages
  2015-09-24 13:15:04 29997 [Note] InnoDB: The InnoDB memory heap is disabled
  2015-09-24 13:15:04 29997 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  2015-09-24 13:15:04 29997 [Note] InnoDB: Memory barrier is not used
  2015-09-24 13:15:04 29997 [Note] InnoDB: Compressed tables use zlib 1.2.3
  2015-09-24 13:15:04 29997 [Note] InnoDB: Using Linux native AIO
  2015-09-24 13:15:04 29997 [Note] InnoDB: Using CPU crc32 instructions
  2015-09-24 13:15:04 29997 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  2015-09-24 13:15:04 29997 [Note] InnoDB: Completed initialization of buffer pool
  2015-09-24 13:15:04 29997 [Note] InnoDB: Highest supported file format is Barracuda.
  2015-09-24 13:15:04 29997 [Note] InnoDB: 128 rollback segment(s) are active.
  2015-09-24 13:15:04 29997 [Note] InnoDB: Waiting for purge to start
  2015-09-24 13:15:04 29997 [Note] InnoDB: 5.6.25 started; log sequence number 24337684937
  2015-09-24 13:15:04 29997 [Note] Server hostname (bind-address): '*'; port: 3306
  2015-09-24 13:15:04 29997 [Note] IPv6 is available.
  2015-09-24 13:15:04 29997 [Note]   - '::' resolves to '::';
  2015-09-24 13:15:04 29997 [Note] Server socket created on IP: '::'.
  2015-09-24 13:15:04 29997 [Note] Event Scheduler: Loaded 0 events
  2015-09-24 13:15:04 29997 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.6.25'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
  </code></pre>
  
  <p>I tried all Google solutions, but the result is always the same...</p>
  
  <p>MySQL is running on CentOS Linux release 7.1.1503 (Core).</p>
  
  <p>Thanks!</p>