Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
open_files_limit problem.

open_files_limit problem.

2007-10-12       - By B. Keith Murphy

 Back
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@(protected)>
To: mysql@(protected)
Sent: Thursday, October 11, 2007 3:02:27 PM (GMT-0500 (See http://GMT-0500.ora-code.com)) 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=kmurphy@(protected)



--
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