From: Dan Nelson
Date: June 27 2002 3:03pm
Subject: Re: cpu consumption.
List-Archive: http://lists.mysql.com/mysql/113188
Message-Id: <20020627150358.GC24908@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 27), Marek Wysmulek said:
> Dear all.
> 
> (Debian 2.4.19, mysql.2.23)
> 
> I'm sorry if case was discussed btu : can someone show me the
> documentation or articles about cpu comsumption being done by mysql
> server or/and clients. Or should I look for load balancing guide.
> 
> Problem is that after ONLY 20 users are connected to the mysql server
> via main socket 0 % of cpu grows to 80 (!) and % of swat also.

It all depends on what your queries are.  300 users doing single-record
lookups may not consume as much CPU as one user doing a complex
multi-table join.

-- 
	Dan Nelson
	dnelson@stripped