开发者

How to controll Mysql query execution time?

开发者 https://www.devze.com 2023-02-01 03:15 出处:网络
I have several EVENTS executing every two seconds, I would like to kill those which are running longer than 1 second.

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 quer开发者_C百科y execution time on MySQL 5.5?

cheers Arman.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消