Re: Slow mysql query, copying to tmp table, using filesort

[Peter Brawley]

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.