Closed Bug 441858 Opened 16 years ago Closed 16 years ago

SUMO sending all queries for 'sessions' table to the master

Categories

(support.mozilla.org :: Knowledge Base Software, task)

task
Not set
critical

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: xb95, Assigned: laura)

Details

(Whiteboard: sumo_only)

Attachments

(1 file)

The SUMO site is sending all SELECT queries on the 'sessions' table to the master and not using the slaves.  The slaves feel underutilized.

This is leading to the master paging IT 3-5 times a day because it is bogging down with these queries.  This is a large table, 1.7G, and the DB is not able to efficiently cache it in memory.  Because of that, when enough of these queries come in, the disks hit 100% utilization, and the server performance bogs down for a few minutes.

Would be great to get these queries split out to the slaves if we can.  Thanks!
Component: Webdev → Knowledge Base Software
OS: Mac OS X → All
Product: mozilla.org → Sumo
QA Contact: webdev → kb-software
Hardware: PC → All
Version: other → unspecified
Going to try to get these into Tuesday's code freeze.
Target Milestone: --- → 0.6
Can I mark this blocking?  Getting wake up pages on this blows.
Target Milestone: 0.6 → ---
Target Milestone: --- → 0.6
Severity: normal → critical
You can, but it won't go out tonight, 'cos if I make a change like this without
QA to tonight's push Justin's head will explode.
Assignee: nobody → laura
I feel there has to be a less hackish way than this, but it works.
Attachment #327704 - Flags: review?(nelson)
Comment on attachment 327704 [details] [diff] [review]
Force ADODB to use slaves for this query.

let's get this staged
Attachment #327704 - Flags: review?(nelson) → review+
this is in r16609 (trunk) and r16610 (production)
Thanks for committing Nelson!
Status: NEW → RESOLVED
Closed: 16 years ago
Keywords: push-needed
Resolution: --- → FIXED
Whiteboard: tiki_feature
I don't think this one should be upstreamed as issue 448497 reverts it. Also, memcache can now be used for sessions.
Whiteboard: tiki_feature → sumo_triage
Whiteboard: sumo_triage → sumo_only
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: