(Sergey Glukhov) In MySQL 8.0.3, we have introduced a new optimizer hint called SET_VAR. This hint allows to change the value of a system variable for a single query.
Read More (Community content)
New optimizer hint for changing the session system variable.