https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Sage Ross changed:
What|Removed |Added
Status|NEW |RESOLVED
Resolution|---
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #15 from Terry Chay ---
Let's table this until Ori gets back from Israel/Amsterdam. :-)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Jeroen De Dauw changed:
What|Removed |Added
Blocks||42932
--
You are receiving this mail
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Jeroen De Dauw changed:
What|Removed |Added
Status|ASSIGNED|NEW
Assignee|jeroen_ded...@
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Sage Ross changed:
What|Removed |Added
Blocks||44114
--
You are receiving this mail beca
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #13 from Sage Ross ---
>> Just having the top two tables
>Any particular reason to get rid of the third one?
Not really, except that the first two are data that I'd like to be able to
check regularly, so if the slow part comes fro
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #12 from Jeroen De Dauw ---
> It could be made AJAXy..
I discussed this with Frank many months ago and we decided this really is not
high on the list priority wise :)
> We need to find what's slow and deal with/disable that.
Yeah
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #11 from Sam Reed (reedy) ---
It could be made AJAXy.. With API a few different calls, it shouldn't time out
broken into chunks.
We need to find what's slow and deal with/disable that.
Added a few more specific profiling calls to
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Sage Ross changed:
What|Removed |Added
CC||rages...@gmail.com
--- Comment #10 from Sa
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Jeroen De Dauw changed:
What|Removed |Added
CC||e...@wikimedia.org,
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #9 from Jeroen De Dauw ---
Disabled the page pending resolution of this bug since apparently it's so
serious: https://gerrit.wikimedia.org/r/#/c/43022/
Still not clear on how to proceed though :)
--
You are receiving this mail be
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Jeroen De Dauw changed:
What|Removed |Added
Status|NEW |ASSIGNED
--- Comment #8 from Jeroen D
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Rob Lanphier changed:
What|Removed |Added
CC||ro...@wikimedia.org
--- Comment #7 from
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #6 from Jeroen De Dauw ---
> really not acceptable for a landing page like this to be prohibitively slow on
first load.
Fully agree this is not acceptable and should be fixed. However, it's not a
landing page - in fact nothing link
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #5 from Jeroen De Dauw ---
> I've had user_touched locks
Is that related to this bug at all? If so, how? Sounds like a separate issue to
me.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watc
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #4 from Jeroen De Dauw ---
Reedy, can you pinpoint which parts of the queries are causing problems? It's
not clear to me. Seems like they should run fine, unless some tables have
gotten several orders of magnitude better then I'd ex
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
Andre Klapper changed:
What|Removed |Added
Keywords||performance
Priority|Unprior
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #3 from Sam Reed (reedy) ---
mysql:wikiadmin@db63 [enwiki]> EXPLAIN SELECT /* ORMTable::rawSelect Reedy */
course_id,course_org_id,course_name,course_title,course_start,course_end,course_description,course_token,course_students,cou
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #2 from Sam Reed (reedy) ---
Oh.
That's only for the first table. enwiki has Totals per term and Gender
breakdown
I've had user_touched locks, 504s..
--
You are receiving this mail because:
You are on the CC list for the bug.
Yo
https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #1 from Sam Reed (reedy) ---
Ouch.
Based on the queries I can see on my local wiki (explain then against enwiki):
mysql:wikiadmin@db63 [enwiki]> SELECT /* ORMTable::rawSelect 192.168.0.18 */
student_id FROM `ep_students` WHERE
20 matches
Mail list logo