GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

query execution time limit

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • query execution time limit

    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.

    Comment


    • #3
      But `show processlist' returns time only in seconds (.

      Comment


      • #4
        ilys wrote on Fri, 28 December 2007 00:33

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


        ah. really. I missed, that your limit was in milliseconds. Then I think, the only way is mysql patching...

        Comment

        Working...
        X