MySQL Forums
Forum List  »  Performance

Re: Utilize maximum system resources for better performance
Posted by: Peter Brawley
Date: July 14, 2015 11:30AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Utilize maximum system resources for better performance
1051
July 14, 2015 11:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.