0

I have the following user who keeps running very complex analytics queries, that usually take 1m each query:

Id  User    Host            db  Command Time    State                 Info
97  tvs0XXX ec2...com:47703 ax  Query   55      Creating sort index   SELECT...

Is there a way to set a SELECT timeout for the tvs0000 user above to 5 seconds? How would I do this?

David542
  • 104,438
  • 178
  • 489
  • 842
  • @MarcB -- no, this is for a specific user only. The question you've linked to above is for a general query for any user. – David542 Jul 27 '16 at 20:46
  • http://dev.mysql.com/doc/refman/5.7/en/grant.html "max_whatever" options. there's no option for time limit, just number of queries/connections. – Marc B Jul 27 '16 at 20:48
  • @MarcB I see, so how would I do the grant to set execution time? – David542 Jul 27 '16 at 20:49
  • you can't. there is nothing in grant that allows a time limit. – Marc B Jul 27 '16 at 20:50
  • @MarcB got it, thank you for the clarification. Also, I think this answer might be helpful for other people trying to accomplish the same, so I think re-opening the question and saying the above (I'll choose your answer) would be helpful. – David542 Jul 27 '16 at 20:51

0 Answers0