"ROB" <robsia> wrote:50% unused RAM is *not* OK.>
> 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.
40 qps is *nothing*> 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?
A server that big should be able to handle 4000 qps. Probably your
database schema and/or queries are not optimized (missing indexes,
You should turn on the slow-query-log and identify those queries.
Then you can use EXPLAIN to find out, what to optimize.
Axel Schwenke, Senior Software Developer, MySQL AB
Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
MySQL User Forums: [url]http://forums.mysql.com/[/url]