List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 17 2004 7:30pm
Subject:Re: MySQL 4.0.2 is topping out at 1024 threads!
View as plain text  
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
Thread
MySQL 4.0.2 is topping out at 1024 threads!Matt Babineau16 Nov
Re: MySQL 4.0.2 is topping out at 1024 threads!Gleb Paharenko17 Nov
  • Re: MySQL 4.0.2 is topping out at 1024 threads!Dan Nelson17 Nov
    • RE: MySQL 4.0.2 is topping out at 1024 threads!Matt Babineau17 Nov
      • RE: MySQL 4.0.2 is topping out at 1024 threads!Alvaro Avello17 Nov
        • RE: MySQL 4.0.2 is topping out at 1024 threads!Matt Babineau17 Nov
      • Re: MySQL 4.0.2 is topping out at 1024 threads!Dan Nelson17 Nov
RE: MySQL 4.0.2 is topping out at 1024 threads!Matt Babineau17 Nov