>>>>> "root" == root <root@stripped> writes:
root> [ Please email me directly as I am not subscribed to the list ]
root> MySQL starts consumming all the CPU cycles and takes almost a
root> minute to complete queries that normally take less than a second.
root> We are seeing this problem on our web server every few hours.
root> We have tracked it down to a specific query. Yet when we run the
root> queriy manually it takes less than a second to run.
What does 'mysqladmin processlist' say when this happens?