Last modified: 2006-04-25 05:40:20 UTC
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.
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.
MySQL AB has plans in this area as well, perhaps for their version 5 - ETA 9-12 months or so for production release.
No longer relevant.
