MySQL Forums
Forum List  »  Performance

Re: Performance improvement with my.cnf configs
Posted by: Rick James
Date: April 24, 2014 08:08PM

> query_cache_size - 4G

Bad value -- it will spend too much time pruning it.

Set long_query_time=1, wait a day, then use pt_query_digest on the slowlog. Then let's see the top 5 queries, together with the SHOWs and EXPLAINs in the comments.

Seriously, it is probably the queries and/or the schema, not the tuning or the hardware.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Performance improvement with my.cnf configs
894
April 24, 2014 08:08PM


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.