All Hardware: Solaris 4 cpu, 16G ram, 900MHz, ver 5.8 MySQL: 4.0.20 binary install, 32 bit version
Admin install, I maintain the my.cnf, and do db admin. Installed a production db (10 million rows) with no problems. However, can only open 20 or so connections to mysqld. The error is: ERROR 1135: Can't create a new thread (error 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug The command "perror 11" returns "Resource temporarily unavailable". The my.cnf config is based on my-huge.cnf with the key-buffer set to 4000m. The max number of connections is set to 100. That's standard. Looked at file descriptors using command "pfiles pid" and it has over 1k on that process. I get the error while using client mysql, or using the normal client (java jdbc). I have an older development solaris box with 4.0.18 installed (64 bit version) and it can do connections up to 100 with no problems. This was confirmed with by creating a java program and doing connections in a loop. Does anyone have any ideas as to what to check or what else to do? Kinda desperate David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
