rpl_replication_delay.result

来自「这个文件是windows mysql源码」· RESULT 代码 · 共 122 行

RESULT
122 行
字号 
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 slave status /* Second_behind reports 0 */;;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	9306Connect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	98Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	YesReplicate_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	98Relay_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	0drop table if exists t1;Warnings:Note	1051	Unknown table 't1'create table t1 (f1 int);flush logs /* contaminate rli->last_master_timestamp */;lock table t1 write;insert into t1 values (1);show slave status /* bug emulated: reports slave threads starting time about 3*3 not 3 secs */;;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	9306Connect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	359Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	YesReplicate_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	271Relay_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	10unlock tables;flush logs /* this time rli->last_master_timestamp is not affected */;lock table t1 write;insert into t1 values (2);show slave status /* reports the correct diff with master query time about 3+3 secs */;;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	9306Connect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	447Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	YesReplicate_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	359Relay_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	6unlock tables;drop table t1;

rpl_replication_delay.result - 源码说明

本页面展示了「这个文件是windows mysql源码」中的 rpl_replication_delay.result 源码文件，采用 RESULT 编程语言编写，共 122 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与windows相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?