Heya! This fixed it for me, I didn't set kern.threads.max_groups_per_proc: earlier.
What is the max threads can FreeBSD go for? Thanks, -A ----- Original Message ---- From: Ken Menzel <[EMAIL PROTECTED]> To: Abdullah Ibn Hamad Al-Marri <[EMAIL PROTECTED]>; mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Wednesday, October 4, 2006 11:59:27 PM Subject: Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug? Have a look at kern.threads.max_threads_per_proc: 1500 and kern.threads.max_groups_per_proc: 1500 You are probably hitting one of these sysctl's. Here is a link to some other info http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2006-01/msg00002.html There is also a wiki on Freebsd and MySQL at http://wikitest.freebsd.org/MySQL Hope this helps, Ken ----- Original Message ----- From: "Abdullah Ibn Hamad Al-Marri" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 03, 2006 4:13 PM Subject: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug? Hello folks, I hope Greg is reading this list I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading. I have a huge app makes alot of connections to MySQL server. The max I could reach is 1500 threads, even I made the max connection in my.cf 5k and I used kern.threads.max_threads_per_proc: to increase it to 5K. here is the my top in the box. 45101 mysql 1500 4 0 477M 166M sbwait 0 11:36 0.00% mysqld when it reachs 1500 I get this msg below "Could not connect to db" My server has dual xeon and 2 gig of ram. Any help would be appreciated. Thank you, -Abdullah