# query execution time limit

**URL:** <https://forums.percona.com/t/query-execution-time-limit/578>\
**Category:** Other MySQL® Questions\
**Created:** [December 27, 2007, 12:55am UTC](https://forums.percona.com/t/query-execution-time-limit/578 "2007-12-27T00:55:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilys](https://avatars.discourse-cdn.com/v4/letter/i/a587f6/32.png) [@ilys](https://forums.percona.com/u/ilys)\
**Post date:** [December 27, 2007, 12:55am UTC](https://forums.percona.com/t/query-execution-time-limit/578/1 "2007-12-27T00:55:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![scoundrel](https://avatars.discourse-cdn.com/v4/letter/s/3ec8ea/32.png) [@scoundrel](https://forums.percona.com/u/scoundrel)\
**Post date:** [December 27, 2007, 1:21pm UTC](https://forums.percona.com/t/query-execution-time-limit/578/2 "2007-12-27T13:21:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ilys](https://avatars.discourse-cdn.com/v4/letter/i/a587f6/32.png) [@ilys](https://forums.percona.com/u/ilys)\
**Post date:** [December 28, 2007, 12:03am UTC](https://forums.percona.com/t/query-execution-time-limit/578/3 "2007-12-28T00:03:16Z")

</div>

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