query execution time limit


Can I limit query execution time in mysql for some user?

For example, I wish limit maximal query execution time to 20 ms for user ‘test’. and if query executes more than 20 ms. his must be killed.

AFAIK, there is no such limits in mysql so far. But simple script with ‘show processlist’ + kill should do the thing.

But `show processlist’ returns time only in seconds (.