Re: Utilize maximum system resources for better performance

[Peter Brawley]

Re the Explain result, Using Where doesn't mean a lot with a yes-no column, otherwise indexing seems to be doing all it can for your query.

> first query takes longer time while queries thereafter are quicker

Takes time to seed caches.

Select From ... can use one index,

Overall, MyISAM query performance improves with key_buffer_size set near ...

select sum(index_length)
from information_schema.tables
where engine='myisam';

For busy servers, MySQL recommends

- cold key cache=20% of total key cache size, for oft-modified tables

- hot key cache=20% of total key cache size, for queries on never-updated tables,

- default key cache=60% of total key cache size,for all other queries.

Worth trying: increase key_buffer_size till key_reads/uptime is acceptable when the buffer is full.

And when Qcache_hits/Qcache_inserts < 5, reuse is poor so you could try disabling the cache altogether.