Hello.
There is no builtin possibility for this, but you may write your
own tool which will be parsing the output of 'mysqladmin processlist'
and invoke 'mysqladmin kill' for long threads.
John Ricci wrote:
> Hi
>
> Is there a way to setup a maximum query execution time per user. I
> understand the options max_connections and max_questions. But I am
> looking for a way to kill a query per user if it takes longer than XX
> minutes!
>
> Thanks
>
> John
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
