RedHat 7.1 MySQL Version 3.23.42 Couple of questions about MySQL and the "open_files" stat as reported by "mysqladmin extended-status".
I've changed my configuration (both MySQL and Linux) to increase the max number of open files -- I don't have a problem here. But, I do see that the "open_files" stat returned from "mysqladmin extended-status" continues to grow... Can anyone tell me what operations cause MySQL to open files (and keep them open)? 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"? Can anyone recommend a diagnostic technique that I can use to determine why I'm keeping so many files open? I'm not hitting any boundary conditions at this point, but it seems to me that I could, and I'd like to understand the situation a little better before I have a crisis. TIA, Sam --------------------------------------------------------------------- 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