Re: Slow query with order by and limit

[Thomas Wiedmann]

Thanks for the EXPLAIN.

Okay, I have suggest a redundate Index (tid, vid) identical to PRIMARY on table TERM_NODE. Please DROP this Index. Sorry.

ALTER TABLE term_node 
 DROP KEY idx_tid_vid;

From Rick I read this calc about MyISAM buffer:

If using just MyISAM, set key_buffer_size to 20% of _available_ RAM. (Plus innodb_buffer_pool_size=0)

with kind regards,
Thomas