Shulou(Shulou.com)05/31 Report--

This article mainly introduces mysql how to set the sql statement execution timeout, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Mysql 5.6 and later, there is a statement execution timeout variable, which is used to limit the timeout of select statements on the server side.

In mysql 5.6, it is called: max_statement_time (millisecond)

After mysql 5.7, change it to: max_execution_time (milliseconds)

After this time, mysql terminates the execution of the select statement, and the client throws an exception:

1907: Query execution was interrupted, max_execution_time exceeded.

There are three settings granularity:

(1) Global settings

SET GLOBAL MAX_EXECUTION_TIME=1000

(2) set a session

SET SESSION MAX_EXECUTION_TIME=1000

(3) set for a statement

SELECT max_execution_time=1000 SLEEP (10), a.* from test a

Thank you for reading this article carefully. I hope the article "how to set the sql statement execution timeout in mysql" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.