Paul,
Take a look at the ulimit command. We had a similar issue, and it turns out there are OS
level per-process limits as well. We have now configured the /etc/init.d/mysql file set
the ulimit to what we need.
here is the snippet form the file:
echo $echo_n "Starting MySQL"
ulimit -n 4096
We just added the ulimit line.
Hope that helps.
Keith
----- Original Message -----
From: "Paul Halliday" <paul.halliday@stripped>
To: mysql@stripped
Sent: Thursday, October 11, 2007 3:02:27 PM (GMT-0500) America/New_York
Subject: open_files_limit problem.
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/mysql?unsub=1
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://blog.paragon-cs.com
(o) 919-433-0786
(c) 850-637-3877
