Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Ady Wicaksono
Make sense, Kayra, this is my.cnf for my mysql cut here --- [client] port= 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] #thread_stack=128KB #set-variable = table-type=innodb default-table-type = innodb port

Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Ady Wicaksono
[client] port= 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] #thread_stack=128KB #set-variable = table-type=innodb default-table-type = innodb port = 3306 socket = /var/lib/mysql/mysql.sock max_connections= 910 max_connect_

Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Kayra Otaner
It can be both Linux kernel setting and MySQL configuration issue. It can be a kernel issue since: - Although you have 4G on your machine your kernel may set to let only 2G to a user space process. You may need to upgrade your kernel to a 'hugemem' kernel which gives you either 3/1 or 4/4 (you nee

Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Javier Armendáriz
Can you tell us about your config parameters? Probably you must set up your max_connections, max_user_connections http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html Ady Wicaksono escribió: I have MySQL 5 installed on My Machine, But it could handle only max about 350 concurren

Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Ady Wicaksono
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