and how on-the-fly?
Thomas On Wed, 20 Nov 2002 09:18:15 -0500 "Ken Menzel" <[EMAIL PROTECTED]> wrote: > 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 > --------------------------------------------------------------------- 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