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)
support.mozilla.org
Knowledge Base Software
Tracking
(Not tracked)
RESOLVED
FIXED
0.6
People
(Reporter: xb95, Assigned: laura)
Details
(Whiteboard: sumo_only)
Attachments
(1 file)
1.21 KB,
patch
|
nkoth
:
review+
|
Details | Diff | Splinter Review |
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!
Updated•16 years ago
|
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
Assignee | ||
Comment 1•16 years ago
|
||
Going to try to get these into Tuesday's code freeze.
Target Milestone: --- → 0.6
Comment 2•16 years ago
|
||
Can I mark this blocking? Getting wake up pages on this blows.
Target Milestone: 0.6 → ---
Updated•16 years ago
|
Target Milestone: --- → 0.6
Updated•16 years ago
|
Severity: normal → critical
Assignee | ||
Comment 3•16 years ago
|
||
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.
Updated•16 years ago
|
Assignee: nobody → laura
Assignee | ||
Comment 4•16 years ago
|
||
I feel there has to be a less hackish way than this, but it works.
Attachment #327704 -
Flags: review?(nelson)
Comment 5•16 years ago
|
||
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+
Assignee | ||
Comment 7•16 years ago
|
||
Thanks for committing Nelson!
Updated•16 years ago
|
Keywords: push-needed
Updated•15 years ago
|
Whiteboard: tiki_feature
Comment 8•15 years ago
|
||
I don't think this one should be upstreamed as issue 448497 reverts it. Also, memcache can now be used for sessions.
Updated•15 years ago
|
Whiteboard: tiki_feature → sumo_triage
Updated•15 years ago
|
Whiteboard: sumo_triage → sumo_only
You need to log in
before you can comment on or make changes to this bug.
Description
•