At the moment on our server, my boss has shell access and runs SQL directly through the mysql application, but sometimes he creates a bad query and the MySQL DB dies until i can kill it (or wait out the 10 or so mins it takes for the query to finish dying). The best solution is to not let him do this, but unfortunately you can't always get your way with this sort of thing.
Anyway, is there a way to assign a timeout period for MySQL queries, and limit them to say 60 seconds? I know its possible to do this when using a scripting language (eg, PHP). But is it possible to set a configuration in MySQL directly to prevent this sort of thing from happening? (And hey, Timeout's are always a good thing to have anyway).
NOTE: Running Mandriva, DB is in MyISAM, and this is for SELECT queries only. (Boss uses it for "quick" reports)