MySQL - how to increase open_files_limit?

Question

MySQL

Hello,
There was a problem with the MySQL database server. Often crashes with "Too many open files" error. Naturally, I realized that I needed to raise the limit, but everything turned out to be not so simple ... I was
guided by this article: www.antojose.com/node/50
What I have not tried - the limit does not want to change to any.

[email protected]:~# mysql -se "SHOW VARIABLES LIKE 'open%'" -p
Variable_name   Value
open_files_limit        1024
[email protected]:~#

[email protected]:~# cat /proc/$(pgrep mysqld$)/limits
Limit                     Soft Limit           Hard Limit           Units
Max cpu time              unlimited            unlimited            seconds
Max file size             unlimited            unlimited            bytes
Max data size             unlimited            unlimited            bytes
Max stack size            8388608              unlimited            bytes
Max core file size        0                    unlimited            bytes
Max resident set          unlimited            unlimited            bytes
Max processes             63752                63752                processes
Max open files            1024                 4096                 files
Max locked memory         65536                65536                bytes
Max address space         unlimited            unlimited            bytes
Max file locks            unlimited            unlimited            locks
Max pending signals       63752                63752                signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0
Max realtime priority     0                    0
Max realtime timeout      unlimited            unlimited            us

MySQL Community Server 5.6.29
Debian 8

Answer 1

Could you at least point out where you changed the settings! =)
Perhaps it's not only in mysql, but also in the system (soft and hard limits).