On Tue, Sep 7, 2010 at 8:48 AM, Henk van Lingen <H.G.K.vanLingen@uu.nl> wrote:
>
> Thanks for your answer. Dropping the (pkey) index is not an option.
> iostat suggest the thing is CPU bound (%iowait remaining 11% but cpu
> rizing from 1 to 13 %)
How man cores that server have? If you've got 8 cores and one IO
bound on this query it'll hit 12%.. IOBound. rely on iostat -xd
instead.