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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to