Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again
Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator: it happend again and I can't fix it, may be someone has a working solution and information on that: surely -> man systemd LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the systemd script by hand /etc/security/limits.conf don't matter /etc/systemd/system/servicename.service.d/ is your friend https://www.freedesktop.org/software/systemd/man/systemd-system.conf.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again
Hi, it happend again and I can't fix it, may be someone has a working solution and information on that: I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the systemd script by hand. Depending on how you start mysql (restart, or at systemboot time ...) the limit get set or not. Question: Is that may be a known bug or something? the old topic is here: http://grokbase.com/t/centos/centos/154x78377b/mysql-5-6-centos-7-and-errno-24-too-many-open-files Regards . Götz smime.p7s Description: S/MIME Cryptographic Signature
RE: Error in accept: Too many open files
Hi, It's quite simple and quick change in *nix. But would recommend to check your server performance first (processlist, tmp tables, slow query log etc). Regards, m Jerry Schwartz je...@gii.co.jp pisze: You are seeing *NIX error messages. You need to increase the operating system settings that control the number of files that a process can open. I'm very rusty, and never really used Linux, so I can't tell you the exact parameters. There are probably two: total number of open files, and files per process. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Brent Clark [mailto:brentgclarkl...@gmail.com] Sent: Tuesday, April 26, 2011 3:44 AM To: mysql mailing list Subject: Error in accept: Too many open files Hiya I recently imported data on a new server (5.1). But before the importing I added the feature 'innodb_file_per_table'. I now want to enable Master - Master replication, but the problem is, im seeing the following --- --- Apr 24 23:32:50 maj-web01 mysqld: 110424 23:32:50 [ERROR] Error in accept: Too many open files Apr 24 23:35:03 maj-web01 mysqld: 110424 23:35:03 [ERROR] /usr/sbin/mysqld: Can't open file: './maj_fs2/sites.frm' (errno: 24) --- --- Ive been going through High Performance MySQL, and a key area the book address is the config option 'innodb_open_files'. If I do a file count for *.ibd files, I only have 147 files, and I see the limit is 300 mysql show global variables like 'innodb_open_files'\G; *** 1. row *** Variable_name: innodb_open_files Value: 300 1 row in set (0.00 sec) Could the other option to look at be 'open_files_limit'? The database is a mixture of innodb and Myiasm. I really need to get replication working, if someone could help my understand this issue, it would be appreciated. Regards Brent Clark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mis...@poczta.fm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Error in accept: Too many open files
Hiya I recently imported data on a new server (5.1). But before the importing I added the feature 'innodb_file_per_table'. I now want to enable Master - Master replication, but the problem is, im seeing the following -- Apr 24 23:32:50 maj-web01 mysqld: 110424 23:32:50 [ERROR] Error in accept: Too many open files Apr 24 23:35:03 maj-web01 mysqld: 110424 23:35:03 [ERROR] /usr/sbin/mysqld: Can't open file: './maj_fs2/sites.frm' (errno: 24) -- Ive been going through High Performance MySQL, and a key area the book address is the config option 'innodb_open_files'. If I do a file count for *.ibd files, I only have 147 files, and I see the limit is 300 mysql show global variables like 'innodb_open_files'\G; *** 1. row *** Variable_name: innodb_open_files Value: 300 1 row in set (0.00 sec) Could the other option to look at be 'open_files_limit'? The database is a mixture of innodb and Myiasm. I really need to get replication working, if someone could help my understand this issue, it would be appreciated. Regards Brent Clark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error in accept: Too many open files
300 is pretty low - MySQL counts every instance of a table in any query as an open file. A query that uses the same table twice (with an alias, for example) thus counts for two open files. This may also be outside of MySQL, the ulimit for the user running the daemon may have open files restrictions, too. - Original Message - From: Brent Clark brentgclarkl...@gmail.com To: mysql mailing list mysql@lists.mysql.com Sent: Tuesday, 26 April, 2011 9:44:16 AM Subject: Error in accept: Too many open files Hiya I recently imported data on a new server (5.1). But before the importing I added the feature 'innodb_file_per_table'. I now want to enable Master - Master replication, but the problem is, im seeing the following -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Error in accept: Too many open files
You are seeing *NIX error messages. You need to increase the operating system settings that control the number of files that a process can open. I'm very rusty, and never really used Linux, so I can't tell you the exact parameters. There are probably two: total number of open files, and files per process. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Brent Clark [mailto:brentgclarkl...@gmail.com] Sent: Tuesday, April 26, 2011 3:44 AM To: mysql mailing list Subject: Error in accept: Too many open files Hiya I recently imported data on a new server (5.1). But before the importing I added the feature 'innodb_file_per_table'. I now want to enable Master - Master replication, but the problem is, im seeing the following --- --- Apr 24 23:32:50 maj-web01 mysqld: 110424 23:32:50 [ERROR] Error in accept: Too many open files Apr 24 23:35:03 maj-web01 mysqld: 110424 23:35:03 [ERROR] /usr/sbin/mysqld: Can't open file: './maj_fs2/sites.frm' (errno: 24) --- --- Ive been going through High Performance MySQL, and a key area the book address is the config option 'innodb_open_files'. If I do a file count for *.ibd files, I only have 147 files, and I see the limit is 300 mysql show global variables like 'innodb_open_files'\G; *** 1. row *** Variable_name: innodb_open_files Value: 300 1 row in set (0.00 sec) Could the other option to look at be 'open_files_limit'? The database is a mixture of innodb and Myiasm. I really need to get replication working, if someone could help my understand this issue, it would be appreciated. Regards Brent Clark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: 100+ databases, too many open files - am I out of line?
Hello. MySQL was developed to hold huge count of users and databases. In addition to: http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html You may read: http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html (There is also some tips about the magic number 1024). Andreas Karlsson [EMAIL PROTECTED] wrote: Hi. I have database structure of about 45 tables, and a separate database for each of the 100+ users. Everything has been working nicely for quite some time. When I wrote a function that looped through all the DBs and ran some queries, MySQL hung and I got too many open files in my .err-file. (Mysql 4.0.22, trustix linux, reiserfs, mysql:open-files-limit at 1024) I am trying different ways of raising the limit, and that shouldn't be a problem. My question is if I am doing this the wrong way? Will I be able to keep my structure, reach 500 users and keep things running smoothly? Is it a problem to have that many databases? Thanx! /Andreas --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 2004-11-19 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
100+ databases, too many open files - am I out of line?
Hi. I have database structure of about 45 tables, and a separate database for each of the 100+ users. Everything has been working nicely for quite some time. When I wrote a function that looped through all the DBs and ran some queries, MySQL hung and I got too many open files in my .err-file. (Mysql 4.0.22, trustix linux, reiserfs, mysql:open-files-limit at 1024) I am trying different ways of raising the limit, and that shouldn't be a problem. My question is if I am doing this the wrong way? Will I be able to keep my structure, reach 500 users and keep things running smoothly? Is it a problem to have that many databases? Thanx! /Andreas --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 2004-11-19 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 100+ databases, too many open files - am I out of line?
Everything has a limit. Sometimes it's just ridiculously high that it might as well be infinity. This is not the case with open files. I'm not sure if MySQL has it's own limit or if it is constrained by the operating system, like it is with file size. Max open files is a function of the OS, not the file system. Under Unix (or Linux), this is a setting you can adjust from the default (4k for Linux I think). Under Windows, I'm not sure what the limit is or how easy it is to change, but I pretty sure the default is pretty high. Although, older versions of MS Word would hit the open file limit because of the way Word handled the undo history. Think about that, that's one user with one document open, potentially hitting the open file limit. Regardless, the max is still a reasonably finite number, 65K I think. That max may be higher on 64 bit systems. But don't forget, unix/linux also sets limits for users which you would have to change. Your design is most definitely not scalable. Every user adds another 45 tables. If you get up to 500 users, thats going to be over 22,000 files. The number of file handles used is going to be even higher, at least double, since MySQL will need file handles for the indexes. That's not even counting the MySQL system tables. Even if the OS could handle that many file handles (on top of the ones the OS uses itself), the system would probably slow to a crawl trying to keep track of all those locks and constantly flushing and loading files from the cache. I think you are doing this the wrong way. You won't be able to keep things running smoothly as you add users. It is a problem having that many tables. A rule I always try to follow is that the number of users should have no effect on your underlying design. Adding a user should not change your design, but in your case it does, your whole system is replicated just because you added one user. You should implement row level security, which MySQL doesn't support so you need to do it in your front end. It's not an easy task to do, but it creates a scalable system. If you don't want to go this route, then you could use a database that supports row level security, like Oracle. To stick with open source, you may need to look into something like Ingres. As a stop gap measure, you may try closing your connections to MySQL as you are looping through the user databases. MySQL may then release the file handles for the disconnected databases, otherwise I think it leaves them open for your entire session. You may try looking into these unix/linux commands: lsof file-nr file-max On Nov 22, 2004, at 5:52 AM, Andreas Karlsson wrote: Hi. I have database structure of about 45 tables, and a separate database for each of the 100+ users. Everything has been working nicely for quite some time. When I wrote a function that looped through all the DBs and ran some queries, MySQL hung and I got too many open files in my .err-file. (Mysql 4.0.22, trustix linux, reiserfs, mysql:open-files-limit at 1024) I am trying different ways of raising the limit, and that shouldn't be a problem. My question is if I am doing this the wrong way? Will I be able to keep my structure, reach 500 users and keep things running smoothly? Is it a problem to have that many databases? Thanx! /Andreas --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 2004-11-19 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error: Too many open files
Hello, this maybe a more related issue with DBI API but I thought I try first posting here to see why we would be getting this error (24) - Too many open files Error Message: DBD::mysql::st execute failed: File './mysql/user.MYD' not found (Errcode: 24) What would be causing this type of error too occur Thx's -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: too many open files, error 24, but max-files is large
On Wed, 2003-03-05 at 15:16, Johannes Ullrich wrote: 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 475816384 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 Hi, You should check your soft limit: ulimit -aS This might be significantly lower than the hard limit for your system, and will be the value inherited my mysql when it starts up. MySQL uses max_connections and table_cache_size to figure out what its max requirement will be. If this requirement is higher than the soft limit, MySQL raises the soft limit using setrlimit() The code that sets the limit is in sql/mysqld.cc: uint wanted_files=10+(uint) max(max_connections*5, max_connections+table_cache_size*2); set_if_bigger(wanted_files, open_files_limit); On my debian box woody box, the soft limit defaults to 1024. If your system is similar, then mysql might raise the limit to 2048+max_connections. Be aware that if you join your merge table to another merge table (or itself), the number of file descriptors used can grow rapidly. A quick spot check can be performed by running 'ls /proc/mysql-thread/fd | wc -l' == Martin - 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
too many open files, error 24, but max-files is large
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 5328475816384 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
RE: repost: Too many open files
Thanks for all the replies. They have all helped me solve the actual problem, which was fairly obvious once you know it, as always. I was starting the mysql server from a prompt as user mysql, not root. Only root has the privileges to up the open file limit of a bash session. This explained the setrlimit warning in the error log. Once I started the server as root then this warning went away, and I presume the open file limit was raised to what was requested. Again, thanks for all the help. Robin -Original Message- From: Adams, Bill TQO [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 19:08 To: Colin Faber Cc: Robin Keech; [EMAIL PROTECTED] Subject: Re: repost: Too many open files Colin Faber wrote: it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Or in Linux (in my rc.local): echo Set max files to 32768 echo 32768 /proc/sys/fs/file-max --Bill mysql --- Incoming 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 --- 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
repost: Too many open files
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 14118192 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
Re: repost: Too many open files
it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Robin Keech wrote: 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 14118192 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 - 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
Re: repost: Too many open files
Colin Faber wrote: it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Or in Linux (in my rc.local): echo Set max files to 32768 echo 32768 /proc/sys/fs/file-max --Bill mysql - 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
Too many open files
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