Variable Scope

Databases MySQL

When SET GLOBAL affects SESSION scope

Ronald Bradford
June 3, 2010

We have all been caught out with using SET and not realizing that the default GLOBAL Scope (since 5.0.2) does not change the current SESSION scope. I was not aware until today that changing GLOBAL scope has some exceptions that also automatically affect SESSION scope.