max_execution_time sets the execution timeout for SELECT statements, measured in milliseconds. When the execution time of a SELECT statement exceeds the value set by max_execution_time, the query is terminated and an error is returned.max_execution_time parameter application scenarios:SELECT statements, the max_execution_time parameter is applied to all queries, unless the query contains the MAX_EXECUTION_TIME(N) optimizer hint or N is 0.max_execution_time parameter does not apply to non-read-only SELECT statements, such as those that invoke stored functions with side effects.max_execution_time parameter is not applicable to SELECT statements within stored programs.max_execution_time parameter is adjusted, consider the following factors:max_execution_time to ensure the script runs properly. For scripts with short execution times, you can reduce the value of max_execution_time to conserve system resources.max_execution_time to improve script execution efficiency. When resources are constrained, you need to reduce the value of max_execution_time to avoid resource exhaustion.max_execution_time to ensure the script completes execution within a reasonable time. For applications with low user experience requirements, you can reduce the value of max_execution_time to improve system performance.Required | Description |
Parameter Type | ULONG |
Default Value | 0 |
Value Range | 0 ~ 18446744073709551615 |
Effective Scope | GLOBAL SESSION |
Restart Required | No |
フィードバック