In the last episode (Nov 17), Matt Babineau said: > This is a very strange problem. As you can see there isn't a lot going on, > under a million queries. No problem right? This is a dual cpu 2.8 Ghz > server. Ok Great. I am also including my.cnf so you can see my > configuration. > > Here is some more info on the problem I am experiencing: > > mysql> status > -------------- > mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) > > > Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush tables: > 1 Open tables: 27 Queries per second avg: 11.044 > --------------
So your real problem is not really the one you originally asked about? You now seem more interested in reducing the number of threads instead of raising the limit. Just run "show processlist", see what's taking up all your connections, and fix the clients :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]