Aug 2005

Change MySQL server variables at runtime

(8:47 am) Tags: [How do I..., Sysadmin]

I was in the need this morning to set some MySQL variables without taking the database server down. This is possible, if you can find the right piece of documentation to tell you how. The proper documentation would be this: 4.3.4 Using Options to Set Program Variables.

Note that not all options can be set. The list of allowed variables to be set this way is listed here: Dynamic System Variables.

Popularity: 17%

Comments are closed.