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: 22.214.171.124 Dynamic System Variables.