on mysql 4.0.10-gamma (rpm install, Redhat advanced server), I
am running into 'too many open files' issues ( error 24 ).
I am using a rather large merge table (30 distinct tables merged),
which is likely the culprit. The error shows up as I have about a
dozen of connections.
I did increase the number of file handles substantionally (16384)
and it looks like this limit is not reached:
cat /proc/sys/fs/file-nr
5328 4758 16384
This is a 2.4 kernel, so inodes are allocated automatically and
there is no inode-max setting.
'open_files_limit' is set to 0.
'table_cache' is set to 1024
cmd line used to run mysqld:
/bin/sh /usr/bin/mysqld_safe --log-slow-queries --datadir=/var/lib/mysql
--pid-file=/var/lib/mysql/x440.pid
...
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
--user=mysql--pid-file=/var/lib/mysql/x440.pid --skip-locking--log-slow-queries
in other words: I checked ulimit...
What am I missing?
hardware: dual Xeon system, 8 GByte RAM
--
--------------------------------------------------------------------
[EMAIL PROTECTED] Collaborative Intrusion Detection
join http://www.dshield.org
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
