33 lines
798 B
Plaintext
33 lines
798 B
Plaintext
show consensus logs;
|
|
Log_name File_size Start_log_index
|
|
master-bin.000001 # #
|
|
show consensus_log events from 0;
|
|
ERROR HY000: Error when executing command SHOW CONSENSUSLOG EVENTS: Could not find target log
|
|
flush local logs;
|
|
call dbms_consensus.local_purge_log(10000);
|
|
create table t(id int primary key);
|
|
insert into t values(0);
|
|
insert into t values(1);
|
|
insert into t values(2);
|
|
show consensus_log events from 1 limit 10;
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
# # # # # #
|
|
flush local logs;
|
|
call dbms_consensus.force_purge_log(10000);
|
|
insert into t values(3);
|
|
insert into t values(4);
|
|
insert into t values(5);
|
|
show binary logs;
|
|
Log_name File_size Encrypted
|
|
# # No
|
|
drop table t;
|