Hi,
Any help would be greatly appreciated as I have a production server that is
struggling.
(I only get the digest list, so could you copy me on any replies -
thankyou).
My error log show this...
011002 9:16:11 Error in accept: Too many open files
011002 9:36:43 /usr/local/mysql/libexec/mysqld: Shutdown Complete
011002 09:36:43 mysqld ended
011002 09:36:52 mysqld started
011002 9:36:52 Warning: setrlimit couldn't increase number of open files
to more than 1024
011002 9:36:52 Warning: Changed limits: max_connections: 500 table_cache:
257
/usr/local/mysql/libexec/mysqld: ready for connections
I am getting the too many open files error.
What does the setrlimit log line mean?
How many connections can I have before reaching 'too many connections'?
What can I do about it?
I have looked in docs.
open_files_limit
If this is not 0, then mysqld will use this value to reserve file
descriptors to use with setrlimit(). If this value is 0 then mysqld will
reserve max_connections*5 or max_connections + table_cache*2 (whichever is
larger) number of files. You should try increasing this if mysqld gives you
the error 'Too many open files'.
mine is 0 so it should use quite a big number ( 500 * 5) - is this too big?
Should I set open_file_limits directly to something smaller?
I have ...
/proc/sys/fs/file-max = 8192
/proc/sys/fs/file-nr = 2097 1411 8192
my.cnf
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=2M
set-variable = max_connections=500
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
set-variable = wait_timeout=1800
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
log-bin
low-priority-updates
binlog-ignore-db=e3
server-id = 1
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01
---------------------------------------------------------------------
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
