Kill long running queries with stricter conditions

Authored by jcrespo on Apr 5 2017, 3:14 PM.

Description

Kill long running queries with stricter conditions

  • Kill wikiuser queries (webrequests) running longer than 60 seconds
  • Kill wikiuser queries sleeping longer than 60 seconds
  • On overload (more than max_connections / 2 threads, that is 5000 open connections, when normally there should be no more than 50-200), kill all queries longer than 10 seconds
  • Kill all query types, not only selects (there was a bug where " ( select" wasn't killed)

Bug: T160984
Change-Id: I2ce51a88a77cbb580c8e32147e7f58b7c9c10899

Details

Committed
jcrespoApr 21 2017, 11:38 AM
Parents
rOSOFa01f67b59fa6: s2,5.hosts: Move db1063 from s2 to s5
Branches
Unknown
Tags
Unknown
References
refs/changes/59/346559/5
ChangeId
I2ce51a88a77cbb580c8e32147e7f58b7c9c10899