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
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
If you show details about your slow query in a new question performance improvements may be possible.
Answered By – danblack
Answer Checked By – Robin (GoLangFix Admin)