Thanks for all the replies. They have all helped me solve the actual problem, which was fairly obvious once you know it, as always.
I was starting the mysql server from a prompt as user mysql, not root. Only root has the privileges to up the open file limit of a bash session. This explained the setrlimit warning in the error log. Once I started the server as root then this warning went away, and I presume the open file limit was raised to what was requested. Again, thanks for all the help. Robin > -----Original Message----- > From: Adams, Bill TQO [mailto:[EMAIL PROTECTED]] > Sent: 02 October 2001 19:08 > To: Colin Faber > Cc: Robin Keech; [EMAIL PROTECTED] > Subject: Re: repost: Too many open files > > Colin Faber wrote: > > > it sounds like you've run out of file descriptors, I suggest > > rebuilding your kernel to handle more. > > > > In a bsd kernel you can do this simply by upping the maximum number of > > users allowed to access the machine at any given time. > > Or in Linux (in my rc.local): > > echo "Set max files to 32768" > echo 32768 >/proc/sys/fs/file-max > > --Bill > > mysql > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 --------------------------------------------------------------------- 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
