List:General Discussion« Previous MessageNext Message »
From:B. Keith Murphy Date:October 12 2007 3:30pm
Subject:Re: open_files_limit problem.
View as plain text  
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 

Thread
open_files_limit problem.Paul Halliday11 Oct
  • Re: open_files_limit problem.B. Keith Murphy12 Oct