MySQL Forums
Forum List  »  Optimizer & Parser

Mysql high cpu usage problem
Posted by: vikki saggu
Date: January 07, 2006 02:29PM

Hi,

I have a linux server with apache+php+mysql.

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql high cpu usage problem
2767
January 07, 2006 02:29PM
2087
January 31, 2006 07:13AM
2458
March 20, 2006 05:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.