If you with Linux, you can use the 'sysctl' programm. sysctl -h gives you the parameters (i.e -u is for the maximum number of processes created by a user). I use the sysctl command in the safe_mysqld script to increase this number. if you want to set a parameter systemwide you may also use /etc/sysctl.conf.
Regards, Philipp ----- Original Message ----- From: "Thomas Seifert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 20, 2002 3:25 PM 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
