Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?
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/msg2.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
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/msg2.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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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