Re: Query with Inner Join to small table suddenly takes FOREVER

[Rick James]

> inner join t_lob l on t.account = l.account
> and t.skill = l.skill

needs compound INDEX(account, skill) (or the opposite order)

> t.account = '12345678'
> and t.startdate between '2014-02-12' and '2014-02-28'

needs compound INDEX(account, startdate) (in that order)

Those two indexes cannot be combined into one.

When the query is slow, is the inner query slow? Or the whole query?

Please provide SHOW CREATE TABLE.

SHOW VARIABLES LIKE '%buffer%';