Im so sorry ask this but i have no useful msg after google.

dba prevent slow query affect mysql server， so we need control select statement execute time. I know variable max_execution_time affect that。 but i can not find func in dtabase/sql.go , Who big man can give me some advice

CodePudding user response：

Execute SET max_execution_time=500 as a SQL statement. This limits the following SQL statements on the same connection to 0.5 seconds.

It is also possible as a SQL comment hint like SELECT /* MAX_EXECUTION_TIME(1000) */ field1, field2 FROM tbl ... like this answer. If you show details about your slow query in a new question performance improvements may be possible.