Closed Bug 803113 Opened 12 years ago Closed 12 years ago

Tune query_cache_size on plugins2.db.phx1

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: dustin, Unassigned)

Details

Per bug 798756#c36 and bug 787185#c22.  It's set to 2000M right now.
I changed from 200M yesterday to 512M, and then to 1024M (1G) and it doesn't look like there was any discernable change (I'd expect things to be worse):

https://ganglia-phx1.mozilla.org/ganglia/?r=custom&cs=10%2F28%2F2012+00%3A00+&ce=10%2F31%2F2012+14%3A40+&c=plugins-db&h=plugins2.db.phx1.mozilla.com&tab=m&vn=&mc=2&z=small&metric_group=ALLGROUPS


You can see when we changed it a while ago in late September, there was a big change:

https://ganglia-phx1.mozilla.org/ganglia/?r=month&cs=08%2F01%2F2012+00%3A00+&ce=10%2F31%2F2012+14%3A40+&c=plugins-db&h=plugins2.db.phx1.mozilla.com&tab=m&vn=&mc=2&z=small&metric_group=ALLGROUPS

My conclusion is that having the query cache is good, but it doesn't need to be huge. I'm setting this back to 2000M and closing this bug.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.