How to set a maximum execution time for a mysql query ?

Question

I would like to set a maximum execution time for sql queries like set_time_limit() in php. How can I do ?

Answer 1

If you are using InnoDB storage you can set a timeout in it's configuration

http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html

Answer 2

set_time_limit(0);