create table test.t1(a int primary key);
create table test.t2(a int primary key)engine=myisam;
flush binary logs;
flush engine logs;
flush error logs;
flush general logs;
flush hosts;
flush logs;
flush privileges;
flush optimizer_costs;
flush relay logs;
flush status;
flush user_resources;
flush tables;
unlock tables;
flush tables test.t1;
unlock tables;
flush tables with read lock;
unlock tables;
flush tables test.t1 with read lock;
unlock tables;
flush tables test.t1 for export;
unlock tables;
repair table test.t2;
Table	Op	Msg_type	Msg_text
test.t2	repair	status	OK
analyze table test.t1;
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
optimize table test.t1;
Table	Op	Msg_type	Msg_text
test.t1	optimize	note	Table does not support optimize, doing recreate + analyze instead
test.t1	optimize	status	OK
flush binary logs;
flush engine logs;
ERROR HY000: The server is not allowed to do current operation.
flush error logs;
ERROR HY000: The server is not allowed to do current operation.
flush general logs;
ERROR HY000: The server is not allowed to do current operation.
flush hosts;
ERROR HY000: The server is not allowed to do current operation.
flush logs;
flush privileges;
ERROR HY000: The server is not allowed to do current operation.
flush optimizer_costs;
ERROR HY000: The server is not allowed to do current operation.
flush relay logs;
ERROR HY000: The server is not allowed to do current operation.
flush status;
ERROR HY000: The server is not allowed to do current operation.
flush user_resources;
ERROR HY000: The server is not allowed to do current operation.
flush tables;
ERROR HY000: The server is not allowed to do current operation.
unlock tables;
flush tables test.t1;
ERROR HY000: The server is not allowed to do current operation.
unlock tables;
flush tables with read lock;
unlock tables;
flush tables test.t1 with read lock;
unlock tables;
flush tables test.t1 for export;
unlock tables;
repair table test.t2;
ERROR HY000: The consensus follower is not allowed to to do current operation.
analyze table test.t1;
ERROR HY000: The server is not allowed to do current operation.
optimize table test.t1;
ERROR HY000: The consensus follower is not allowed to to do current operation.
truncate table test.t1;
ERROR HY000: The consensus follower is not allowed to to do current operation.
set sql_log_bin=0;
flush binary logs;
flush engine logs;
flush error logs;
flush general logs;
flush hosts;
flush logs;
flush privileges;
flush optimizer_costs;
flush relay logs;
flush status;
flush user_resources;
flush tables;
unlock tables;
flush tables test.t1;
unlock tables;
flush tables with read lock;
unlock tables;
flush tables test.t1 with read lock;
unlock tables;
flush tables test.t1 for export;
unlock tables;
repair table test.t2;
Table	Op	Msg_type	Msg_text
test.t2	repair	status	OK
analyze table test.t1;
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
optimize table test.t1;
Table	Op	Msg_type	Msg_text
test.t1	optimize	note	Table does not support optimize, doing recreate + analyze instead
test.t1	optimize	status	OK
truncate table test.t1;
drop table t1, t2;