How to increase open files limit mysql in linux

Question

i want to increase "open files limit mysql" to 2084. what are the commands to run through ssh?

Answer 1

To see the current limit, type:

ulimit -a

To check the limit for a particular user (I guess you would be interested in mysql user), type:

su mysql ulimit -a

To increase/modify the limit, do:

vi /etc/security/limits.conf

and add:

mysql hard nofile 2084 
mysql soft nofile 2084

Do the same for /etc/security/limits.d/90-nproc.conf.

You can also temporary increase the open files limit for the user you're currently logged in with:

ulimit -Hn 2084

Answer 2

If you're looking for the MySQL internal limit, it is defined in my.cnf file by the variable open_files_limit = 2084 (see MySQL doc for details).

Depending on your version, the file to edit should be either /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf