Bug #39461 Slow Query
Submitted: 15 Sep 2008 20:54 Modified: 20 Oct 2008 13:05
Reporter: Roberto Spadim (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.60 OS:Linux
Assigned to: CPU Architecture:Any
Tags: qc

[15 Sep 2008 20:54] Roberto Spadim 
Description:
slow query see files 

How to repeat:
files attached

Suggested fix:
maybe index optimization
[16 Sep 2008 4:31] Valeriy Kravchuk 
Thank you for a problem report. Please, inform when test data will be available.
[18 Sep 2008 17:33] Sveta Smirnova 
Thank you for the report.

But version 5.0.60 is a bit old. Please upgrade to current version 5.0.67 or 5.0.68, try with it and if problem still exists explain in more details how you want this to be fixed.
[18 Sep 2008 18:24] Sveta Smirnova 
Just for a note: on my debug 5.0.70 server query from comment "[16 Sep 20:29] Roberto Spadim" takes only 0.02 sec
[19 Sep 2008 21:14] Roberto Spadim 
i will wait more time to get 5.1
and test on it,
it's  a production server i can't operate every time it
i will continue test on another server (windows) to check
[19 Sep 2008 21:40] Sveta Smirnova 
Thank you for the feedback.

We will wait results of your testing.
[19 Oct 2008 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[20 Oct 2008 13:05] Roberto Spadim 
i tested on 5.1.16, worked better with 
index_merge, Using sort_union(PRIMARY,hash_baixa); Using where
maybe newer version get better i will test again on a windows machine
thanks