Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048.
Good luck Ken ----- Original Message ----- From: "Lance Lovette" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? > My database has many hundreds of tables. Originally I set my table_cache to > 512. Today I realize this might not be a good idea. By default > open_files_limit is 0. According to my understanding of the manual this > means each MySQL process will open at most 1124 file handles: > > max_connections + (table_cache * 2) > = 100 + (512 * 2) > = 1124 > > ulimit -n says the process file handle limit is 1024. Am I correct in > assuming this configuration could potentially put the server in an unstable > situation? > > Thanks! > Lance > > > -------------------------------------------------------------------- - > 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
