Hi Thomas, This would be a question for your OS support list, however an example from FreeBSD:
bash-2.04$ sysctl -a | grep files kern.maxfiles: 20000 kern.maxfilesperproc: 19000 kern.openfiles: 1569 bash-2.04$ su tuvok# sysctl kern.maxfiles=20001 kern.maxfiles: 20000 -> 20001 tuvok# Hope this helps, but it is off topic for this list. Ken ----- Original Message ----- From: "Thomas Seifert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 20, 2002 9:25 AM Subject: Re: table_cache too high? > > 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 > > --------------------------------------------------------------------- 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
