MySQL Forums
Forum List  »  General

Re: Monitor a Query then retrieve data using process ID
Posted by: Rick James
Date: June 25, 2016 10:49PM

Tread cautiously on the Query Cache.

* Do not have query_cache_size more than 50M -- pruning is costly.
* If you are frequently writing to the tables, the QC is of little use.

Have you "over-normalized"? If so, it may be beneficial to avoid some of the JOINs. I can explain if I can see the query.

Options: ReplyQuote




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.