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.
Subject
Views
Written By
Posted
2185
April 23, 2014 10:23AM
Re: Performance improvement with my.cnf configs
894
April 24, 2014 08:08PM
951
April 24, 2014 09:41PM
928
April 25, 2014 08:24PM
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.