MySQL Forums
Forum List  »  Performance

Re: Slow mysql query, copying to tmp table, using filesort
Posted by: Peter Brawley
Date: December 08, 2015 10:48PM

12 secs to examine half a million rows is too much, especially when Explain output looks this unproblematic.

Probably you can better performance from InnoDB tables if you tune InnoDB well.

Does it still take 12 secs if you filter out 90% of those 3,917 result rows?

Is your hardware adequate?

Values returned by attributenames.name, search_attribute_values.value, search_attribute_values.absolutevalue---the three Select expressions that are neither aggregates nor Grouped By---will be arbitrry unless those columns have unique values for the grouping columns. emove them from the Select list, or add them them to the Group By clause.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow mysql query, copying to tmp table, using filesort
1369
December 08, 2015 10:48PM


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.