My Mysqld stopped accepting connections with
Error log:
010910 15:34:19 Error in accept: Too many open files
010910 15:49:02 /usr/local/mysql/libexec/mysqld: Normal shutdown
when trying to connect I got:
ERROR 2013: Lost connection to MySQL server during query
changed max_connections and restarted server
got error.log :
010910 15:49:04 /usr/local/mysql/libexec/mysqld: Shutdown Complete
010910 15:49:04 mysqld ended
010910 15:49:15 mysqld started
010910 15:49:15 Warning: setrlimit couldn't increase number of open files
to more than 1024
010910 15:49:15 Warning: Changed limits: max_connections: 300 table_cache:
357
/usr/local/mysql/libexec/mysqld: ready for connections
Documentation states:
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'.
Can I increase setrlimits limit to more then 1024, or is that the ceiling on
my OS/ hardware?
(I thought about dropping the value of wait_timeout from 8 hours to 4 (or 2)
hours, as this would disconnect idle clients. I have numerous apache
clients, all with many children hanging onto a connection. Any thoughts
about this before I do it?)
Thanks,
Robin
Running Redhat Linux 7.1
on intel
Mysql version 3.23.37-log
Some Variables:
| open_files_limit | 0
| max_connections | 300
| max_user_connections | 0
| max_tmp_tables | 32
---------------------------------------------------------------------
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
