Re: Performance problem MySQL 4.0.20

[Alex Arul Lurthu]

On 7/6/07, spikerlion@stripped <spikerlion@stripped> wrote:
>
> How does the cpu power influence the speed of a query?
>
>
Sort is a cpu intensive process.

*Check if you are suffering from locks on the tables you look up.*

Also, was the table in the system where the queries are running faster
rebuilt recently. You can try rebuilding the tables.

How is the overrall system load on both machines. Is one overloaded than the
other ? The machine which takes longer to excute the query might be busy
serving some other process other than MySQL.


Thanks
Alex