470,599 Members | 1,508 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,599 developers. It's quick & easy.

CPU

HD
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 is anything
I can do in my database config to improve performance, apart from
changing CPU. Do you suggest more CPU?
Any suggestions? Thanks!

Mar 7 '06 #1
2 1072
HD
I forgot to mention that we are on Debian 3.1

Mar 7 '06 #2
"HD" <ro****@gmail.com> wrote in message
news:11**********************@j52g2000cwj.googlegr oups.com...
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 is anything
I can do in my database config to improve performance, apart from
changing CPU. Do you suggest more CPU?


First, you need to verify what is eating up the cpu.
Start with the "top" utility on your debian system and use it to analyze cpu
usage.

A good guess on may part would be that with an average 40queries/sec, the
cpu is heavily engaged answering queries ;-)
You need to enable your binary log and you need to do some analysis of this
to identify where the heavy query load is coming from. You *might* simply
just be overloaded with users and applications making query demands.

On the other hand, and I consider this more likely, you have 1 or 2 abusers
overloading the system with unececssary and/or bad queries. It's all too
common for people to write apps that machine gun query a system 10 times a
second for something that would would work perfectly well when done once
every 10 minutes - with drastic performance consequences.

Does it make sense to you to have 40 queries/second ?
Thomas Bartkus


Mar 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.