Re: Mysql high cpu usage problem
From: Eric Anderson (anderson_at_centtech.com)
Date: 10/28/04
- Previous message: Omer Faruk Sen: "Mysql high cpu usage problem"
- In reply to: Omer Faruk Sen: "Mysql high cpu usage problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 28 Oct 2004 11:09:14 -0500 To: Omer Faruk Sen <ofsen@enderunix.org>
Omer Faruk Sen wrote:
> Hi,
> I have a system with apache+php+mysql. The system was fine for a long
> time but my problem started a few weeks ago.
> I have two 2.8 Ghz Xeon CPU's. Hyperthreading is enabled. 2 gigs of RAM.
> machdep.hlt_logical_cpus=0 and polling is enabled.
> Mysql (which was compiled with linux_threads and staticly linked
> libraries) has started to consume lots of cpu time (mainly system and
> nice times)
> Here's a moment from top output:
> last pid: 60888; load averages: 114.70, 114.42,
> 115.72 up 2+01:10:28 10:44:18
> 3 processes: 2 running, 1 sleeping
> CPU states: 1.7% user, 52.3% nice, 44.9% system, 1.1% interrupt, 0.0%
> idle
> Mem: 494M Active, 1034M Inact, 357M Wired, 97M Cache, 199M Buf, 21M Free
> Swap: 3072M Total, 104K Used, 3072M Free
> What's worth attention here is that, cpu spends nearly all of its time
> in kernel mode.
> Number of hits, the web server gets did not change much, maybe a little
> rise.
> Can you please provide some info tracking down the problem?
Have you optimized your tables/indexes recently?
Also - do you have a large number of outstanding connections to the db?
Eric
-- ------------------------------------------------------------------ Eric Anderson Sr. Systems Administrator Centaur Technology Talk sense to a fool and he calls you foolish. ------------------------------------------------------------------ _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"
- Previous message: Omer Faruk Sen: "Mysql high cpu usage problem"
- In reply to: Omer Faruk Sen: "Mysql high cpu usage problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
