how to set mysql max_execution_time property use go

Issue

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

Solution

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.

Answered By – danblack

Answer Checked By – Robin (GoLangFix Admin)

Leave a Reply

Your email address will not be published.