MySQL Forums
Forum List  »  General

Re: Why is my entire database getting locked for a slow select query?
Posted by: Rick James
Date: August 26, 2010 08:15PM

Pretty poor ratio:
'Qcache_hits', '53904827'
'Qcache_inserts', '25327433'
Perhaps the query cache is not really useful.

Plan A:
query_cache_type = OFF
See if the system performs adequately.

Plan B:
query_cache_type = DEMAND
Then decide which SELECTs are likely to benefit from caching, and change them to say
SELCT SQL_CACHE ...

Plan C:
Do nothing (if you are happy with the current state)

Options: ReplyQuote


Subject
Written By
Posted
Re: Why is my entire database getting locked for a slow select query?
August 26, 2010 08:15PM


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.