Hi Johan,
>What's the recommended setting for ulimit on a system running
>MySQL 3.23.27, Red Hat 7.0, and PHP which now and then
>when connecting with mysql_pconnect() produce the error:
>"Can't create a new thread (errno 11).
>If you are not out of available memory, you can consult the
>manual for a possible OS-dependent bug"
How many processes does the mysqld have when PHP tells you this?
You could use this command to monitor the current status by running:
mysqladmin -i 5 -u xxx -pyyy status
>core file size (blocks) 1000000
>data seg size (kbytes) unlimited
>file size (blocks) unlimited
>max locked memory (kbytes) unlimited
>max memory size (kbytes) unlimited
>open files 1024
>pipe size (512 bytes) 8
>stack size (kbytes) 8192
>cpu time (seconds) unlimited
>max user processes 2048
>virtual memory (kbytes) unlimited
With these settings you won't be able to run much over 500 processes
because each process will need at least 2 filehandles to run a query
and the master-daemon will use a few filedescriptors too. Try a
"ulimit -n 8192" in your scripts for starting mysqld.
cu
Jan Tegtmeier
NetGate Internetservice / Germany
---------------------------------------------------------------------
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