How to increase open files limit mysql in linux [duplicate]
By Emma Martinez •
i want to increase "open files limit mysql" to 2084. what are the commands to run through ssh?
02 Answers
To see the current limit, type:
ulimit -aTo check the limit for a particular user (I guess you would be interested in mysql user), type:
su mysql ulimit -aTo increase/modify the limit, do:
vi /etc/security/limits.confand add:
mysql hard nofile 2084
mysql soft nofile 2084Do 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 2084If 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
More in general
"Zoraya ter Beek, age 29, just died by assisted suicide in the Netherlands. She was physically healthy, but psychologically depressed. It's an abomination that an entire society would actively facilitate, even encourage, someone ending their own life because they had no hope. Th…"
