MySQL Forums
Forum List  »  MySQL Administrator

Innodb Query Slow Down with Sorting Result State
Posted by: Devang Modi
Date: October 10, 2010 09:20AM

Hi;

We are facing a typical issue with mysql server the issue is "Select Query To much Slow Down" with "Sorting Result" status.

We have highly capable server with Xeon Processor and 48 MB of RAM.

Can some one tell which parameter affects such reverse effect, our sort_result_buffer = 512 MB and Innodb_* = 10 Gb and 1 GB Respective.

We also enables Query Cache that is 512MB.

We also notice that Slow Query logs is empty means this query did not logged to slow query log.


Devang

Options: ReplyQuote


Subject
Written By
Posted
Innodb Query Slow Down with Sorting Result State
October 10, 2010 09:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.