Hi!
"MARK" == MARK CALLAGHAN <mdcallag@gmail.com> writes:
MARK> Is there an easy way to prevent SET GLOBAL ... from being done for MARK> plugin variables declared via MYSQL_THDVAR_...? For the following MARK> variable I can do SET GLOBAL innodb_fake_changes=1 and that sets a MARK> global variable. MARK> static MYSQL_THDVAR_BOOL(fake_changes, PLUGIN_VAR_OPCMDARG, MARK> "In the transaction after enabled, UPDATE, INSERT and DELETE only MARK> move the cursor to the records " MARK> "and do nothing other operations (no changes, no ibuf, no undo, no MARK> transaction log) in the transaction. " MARK> "This is to cause replication prefetch IO. ATTENTION: the MARK> transaction started after enabled is affected.", MARK> check_fake_changes, NULL, FALSE); You can only do SET GLOBAL if you have SUPER privilege. Isn't that enough to ensure no one does it by mistake? Don't think there is an easy way to disable global for non super user. Sergei should know (as he implemented this) and he should also be able to add an option that variables should not be settable by SET GLOBAL. Regards, Monty