I am trying to change this value and it doesn't seem to work.

Looking at the processes I have:

mysql   21752  0.0  0.1  1652  1092  p3  I     3:50PM   0:00.01
/bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql
--pid-file=/var/db/mysql/nsccmadb2.campus.nscc.ca.pid
mysql   21770  0.0  1.3 58188 26168  p3  S     3:50PM   0:00.21
/usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf
--basedir=/usr/local --datadir=/var/db/mysql
--pid-file=/var/db/mysql/nsccmadb2.campus.nscc.ca.pid


Within /var/db/mysql/my.cnf I have:

[mysqld_safe]
open_files_limit = 32768

[mysqld]
open_files_limit = 32768

But when I try something like "mysql> show variables like '%files%';":

I get:

open_files_limit 11095

Is there another variable that needs to be adjusted to bump this up?

Thanks.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to