query execution time limit

MySQL & MariaDB Other MySQL® Questions
1

Hi!

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.

2

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

3

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