Hi Jeremy, Here's the deal -- I let the MySQL number of open file handles default to MySQL's default setting. I also let the linux "max file handles" setting default... I started getting Error 24 (too many open files--from linux) when issuing queries, which rendered MySQL useless and caused "bad" things to happen to my application.
I increased the linux and MySQL max open files to 64K (didn't touch "table_cache"). I then proceeded to sweat as I watched the number of MySQL open file handles grow... I think that I've misunderstood the "tabke_cache" AND the "open_files_limit" variables. The first reply from someone on this list gave me the answer (but I initially didn't understand) "the number of open file handles will grow to open_files_limit". Simple right? Unfortunately, by setting the MySQL open_files_limit to be equal to the linux max open files limit, I was setting myself up for another Error 24 situation. I've decreased the setting for MySQL "open_files_limit"... I have "table_cache" set to 1024. Thanks (to you and others that have replied) for the assistance... Sam -----Original Message----- From: Jeremy Cole [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 8:42 PM To: Sam Taylor Cc: MySQL Mailing List Subject: Re: Increasing number of open_files Hi Sam, > I'm running a Java (JSP/Servlets/mmJDBC) web application that is using > MySQL, and over the course of a few days I see the number of open files > increasing... after 4 days of usage the number was at 17,000+. What is > typical for MySQL? What are other people seeing for "open_files"? This sounds like you have misunderstood the variable ``table_cache'' and set it way too high. The ``table_cache'' variable is a number of tables, not bytes or kilobytes or anything else. What have you set it's value to? By default it's 64, and most people need not raise it higher than perhaps 1024 or 2048. Regards, Jeremy -- MySQL Training in San Francisco! Visit http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jeremy Cole <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Trainer and Consultant /_/ /_/\_, /___/\___\_\___/ Clarksville, Tennessee USA <___/ www.mysql.com --------------------------------------------------------------------- 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