[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #10 from Aaron Schulz 2012-08-09 01:06:21 UTC --- https://gerrit.wikimedia.org/r/#/c/17379/ was already merged to master for this. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are recei

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #9 from Asher Feldman 2012-08-08 21:38:34 UTC --- ChronologyProtector seems like it could be a good bet for moving these to slave reads... Row caching would be even nicer :) What about these three: SELECT /* Revision::newFromTitl

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Aaron Schulz changed: What|Removed |Added CC||tstarl...@wikimedia.org --- Comment #8

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #7 from Asher Feldman 2012-08-01 19:30:39 UTC --- I was just tracking queries to the enwiki master from my ip address while browsing wikipedia as a logged out user. Loading https://en.wikipedia.org/wiki/The_Squire_of_Long_Hadley r

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #6 from Asher Feldman 2012-08-01 19:24:04 UTC --- It looks like the change in 1.20wmf8 that was supposed to shift some of these to slaves didn't have an impact. In the last 24 hours, select page_latest from Revision::newFromTitle

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #5 from Rob Lanphier 2012-06-29 18:47:49 UTC --- There's a draft in Gerrit that Aaron is working on now (private only because there's not yet a "public draft" feature in Gerrit). Once Aaron gets this reviewed by Asher on the perfo

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Rob Lanphier changed: What|Removed |Added CC||ro...@wikimedia.org AssignedTo|

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Mark A. Hershberger changed: What|Removed |Added Priority|Unprioritized |Normal CC|

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Aaron Schulz changed: What|Removed |Added Priority|High|Unprioritized --- Comment #4 from Aaron

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #3 from Asher Feldman 2012-05-22 22:06:36 UTC --- Even if many of these queries could (or do) go to slaves, I don't think they should happen at all. Memcached could be used quite effectively here if keys were actively set on revis

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Sam Reed (reedy) changed: What|Removed |Added Keywords||platformeng Priority|Unpr

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Aaron Schulz changed: What|Removed |Added CC||aschulz4...@gmail.com --- Comment #2 fr

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 --- Comment #1 from Aaron Schulz 2012-05-22 18:54:24 UTC --- Why are these hitting the master? I guess more info will be needed on the callers. They should probably be audited. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.c

[Bug 37030] Allow caching for Revision::newFromTitle to reduce database load

https://bugzilla.wikimedia.org/show_bug.cgi?id=37030 Siebrand changed: What|Removed |Added Keywords||performance CC|