rpl_log_pos.result
来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· RESULT 代码 · 共 98 行
RESULT
98 行
stop slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;reset master;reset slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;start slave;show master status;File Position Binlog_Do_DB Binlog_Ignore_DBmaster-bin.000001 98 stop slave;change master to master_log_pos=73;show slave status;Slave_IO_State #Master_Host 127.0.0.1Master_User rootMaster_Port MASTER_PORTConnect_Retry 1Master_Log_File master-bin.000001Read_Master_Log_Pos 73Relay_Log_File #Relay_Log_Pos #Relay_Master_Log_File master-bin.000001Slave_IO_Running NoSlave_SQL_Running NoReplicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0Last_Error Skip_Counter 0Exec_Master_Log_Pos 73Relay_Log_Space #Until_Condition NoneUntil_Log_File Until_Log_Pos 0Master_SSL_Allowed NoMaster_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master #start slave;stop slave;show slave status;Slave_IO_State #Master_Host 127.0.0.1Master_User rootMaster_Port MASTER_PORTConnect_Retry 1Master_Log_File master-bin.000001Read_Master_Log_Pos 73Relay_Log_File #Relay_Log_Pos #Relay_Master_Log_File master-bin.000001Slave_IO_Running NoSlave_SQL_Running NoReplicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0Last_Error Skip_Counter 0Exec_Master_Log_Pos 73Relay_Log_Space #Until_Condition NoneUntil_Log_File Until_Log_Pos 0Master_SSL_Allowed NoMaster_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master #show master status;File Position Binlog_Do_DB Binlog_Ignore_DBmaster-bin.000001 98 create table if not exists t1 (n int);drop table if exists t1;create table t1 (n int);insert into t1 values (1),(2),(3);change master to master_log_pos=98;start slave;select * from t1;n123drop table t1;End of 5.0 tests
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?