108 lines
3.0 KiB
Plaintext
108 lines
3.0 KiB
Plaintext
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;
|