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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
