Bug #17695 MySQL only could handle 350 concurrent connection
Submitted: 24 Feb 2006 13:59 Modified: 27 Feb 2006 15:32
Reporter: Ady Wicaksono Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:Linux (RedHat Linux 9)
Assigned to: CPU Architecture:Any

[24 Feb 2006 13:59] Ady Wicaksono 
Description:
I have MySQL 5 installed on My Machine,

But it could handle only max about 350 concurrent mysql connection

Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for
a possible OS-dependent bug in

Is it mysql bug, incorrect Linux setting or what?

How to repeat:
To repeat, install MySQL 5 on your machine, and try make more than 350 connection.

Suggested fix:
Downgrade MySQL to MySQL 4.1 or MySQL 4.0, but it's hard to do if you have established data
[24 Feb 2006 14:08] Valeriy Kravchuk 
Thank you for a problem report. Please, sent your my.cnf content and ulimit -a results.
[27 Feb 2006 15:32] Ady Wicaksono 
It was my fault, please remove this bug report. I set memory usage of MySQL near 2Gbytes. Since Kernel Linux limit user process up to 2 Gbytes, yes ... i often hit the limit, including the number of mysql connection.

Thank you