CODEWITHSUNDEEP
mysqltime
Arman
Arman

Reputation: 4626

How to controll Mysql query execution time?

I have several EVENTS executing every two seconds, I would like to kill those which are running longer than 1 second.

Are there way to control query execution time on MySQL 5.5?

cheers Arman.

Upvotes: 0

Views: 272

Answers (1)

Spiny Norman
Spiny Norman

Reputation: 8327

You can use the SHOW PROCESSLIST command to see running processes in MySQL.

Here's a link: http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html.

Upvotes: 1

Related Questions