From: Dan Nelson
Date: November 17 2004 7:30pm
Subject: Re: MySQL 4.0.2 is topping out at 1024 threads!
List-Archive: http://lists.mysql.com/mysql/175979
Message-Id: <20041117193034.GD3342@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped