maria-developers team mailing list archive
Mailing list archive
Re: MYSQL_THDVAR and SET GLOBAL
>>>>> "MARK" == MARK CALLAGHAN <mdcallag@xxxxxxxxx> 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.