Skip to content

MySQL

MySQL Buffered warning: Changed limits: max_connections: 214 (requested 800)

This is always an interesting one, comes up from time to time especially if you run a server with heavy database traffic. Possibly you’ve modified you my.cnf with various tweaked settings for ‘max_connections’ or ‘open_files_limit’ but your your ‘mysqld.log’ you start getting: [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 800)…