You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Query killer

From Wikitech-static
Revision as of 12:54, 10 July 2014 by imported>Nemo bis (copy from bugzilla:58157#c5)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The query killer on production databases is a 60s pt-kill job on slaves after query spikes causing outages in November 2013. When the number of slow queries on a slave grows beyond a threshold the slowest one above 60s is sniped to keep the box alive. This only affects wikiuser, not wikiadmin.