Re: Slow Query too much time in Copy to Tmp Table

[Gustavo Mateos]

Thanks for you reply.

We are using MySQL 5.1.66. Just next weekend we are going to upgrade it to 5.5.

Here you have, the EXPLAIN output for this query:

*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: track_acts_store
partitions: NULL
type: range
possible_keys: page_unique,act_time
key: act_time
key_len: 4
ref: NULL
rows: 118449
Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: track_visits_store
partitions: NULL
type: ref
possible_keys: visit_unique
key: visit_unique
key_len: 8
ref: intent_sharing.track_acts_store.act_unique
rows: 1
Extra: