open_file_limits not increasing

wattie

Verified User
Joined
May 31, 2008
Messages
1,206
Location
Bulgaria
In /etc/my.cnf I set "open_files_limit = 16384" and restarted mysql; however I still get the following:

mysql> SHOW VARIABLES LIKE 'open%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 11095 |
+------------------+-------+
1 row in set (0.00 sec)

Any ideas? The system is FreeBSD 9.1.
 
OK, I found the solution. It was the sysctl.conf kern.maxfilesperproc limiting the mysqld process
 
Back
Top