CPU usage

Hello,

I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM
and noticed that CPU is used at 90%.

RAM usage is ok. Approx 50% free.

I have approx 40 queries per second and I wonder if there isa anything
I can do in my database config to improve performance apart from
changing CPU. Do you suggest more CPU?

Any suggestions? Thanks!

"ROB" <robsia@gmail.com> wrote:
>
> I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM
> and noticed that CPU is used at 90%.
>
> RAM usage is ok. Approx 50% free.

50% unused RAM is *not* OK.

> I have approx 40 queries per second and I wonder if there isa anything
> I can do in my database config to improve performance apart from
> changing CPU. Do you suggest more CPU?

40 qps is *nothing*

A server that big should be able to handle 4000 qps. Probably your
database schema and/or queries are not optimized (missing indexes,
denormalized schema).

You should turn on the slow-query-log and identify those queries.
Then you can use EXPLAIN to find out, what to optimize.


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

"ROB" <robsia@gmail.com> wrote in message
news:1141740572.523537.73410@v46g2000cwv.googlegro ups.com...
> I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM
> and noticed that CPU is used at 90%.

What operating system brand and version? e.g. FreeBSD 4.4, Windows XP Pro
sp2.
What MySQL version? e.g. 4.0, 4.1, 5.0.

There are certain combinations of OS and MySQL that have been reported to
cause spurious increases in CPU load.

Regards,
Bill K.