Ingo Strüwing wrote:
> Hi Jay,
>
> a happy and successful new year to you.
> Thank you for all your helpful comments throughout
> the last year.
> Please keep up your good work. I was especially
> glad whenever you jumped in in SQL questions. This
> is unfortunately not one of my strengths.
I'm very happy to help out! In fact, today is my first day on the job for MySQL! I was hired on Thursday as the North American Community Relations Manager. You'll probably be hearing a lot more from me... :)
> Back to your question:
> Do you mean that you expected that MySQL should be
> configured so that it uses more memory? While I
> would agree in the general case, this kind of
> tuning is usually done to lower the I/O rate. But
> I won't expect that it would solve the CPU time
> problem. I might have misunderstood your question
> though.
No, actually I was referring to the fact that he has 2G of RAM in the machine, but only 1G is recognized. Perhaps the OP has not enabled high mem usage in the kernel?
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com