Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

query execution time limit

ilysilys EntrantInactive User Role Beginner

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.


  • scoundrelscoundrel Contributor Inactive User Role Beginner
    AFAIK, there is no such limits in mysql so far. But simple script with 'show processlist' + kill should do the thing.
  • ilysilys Entrant Inactive User Role Beginner
    But `show processlist' returns time only in seconds (.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.