When Variables Take Effect

• When a session system variable is changed, the value remains in effect until the session ends or until it is changed to a different value.
  • The change is not visible to other clients.

• When a global system variable is changed, the value is remembered and used for new connections until the server restarts.
  • The change is visible to any client that accesses that global variable.
  • The global variable change does not affect the session variable for any client that is currently connected.

Are there any status variables?

---

---

© 2007 John Michael Pierobon

Notes