We still sometimes get hit by really slow search queries that take a long time to return. It might be wise to use the thread
timeout killer script that we have for Asksql on searches as well. If the search doesn't return in 30 seconds, there's a good
chance the user won't still be around to pick it up anyway.
Version: unspecified
Severity: enhancement
Platform: PC
We've got an external thread-killer daemon (servmon) which currently serves this need on Wikimedia. Do we need
something more integrated? I don't really like the way the old asksql killer worked (shell-out to run PHP), it wasn't
necessarily clean or portable itself.
bugzilla_wikipedia_org.to.jamesd wrote:
MySQL AB has plans in this area as well, perhaps for their version 5 - ETA 9-12
months or so for production release.