????MySQL ?????????????????????????????????????д????????????????????????????????????????潫???????????????????????Щ??????????
???????????????
????MySQL ??????????????????????????и??????ж??????????(???????????)????????????????????????????????????????????????????????????￡????????????????????????????????????
?????????????????????????????????????????????LOAD DATA FROM MASTER????????LOAD DATA FROM MASTER????????б????MyISAM?洢?????????????????????????????佫?????????????
????MySQL ???3?????????и???????????1??????????????????????????????????????START SLAVE?????????????????I/O???????????????????????????????????????????е????
?????????????????????????????????е????????????????????????????????????????SHOW PROCESSLIST??????е?Binlog Dump????
???????????I/O?????????????Binlog Dump???????????????????????????????????????е????????У????м??????
??????3???????SQL???????????????????????м?????????????а?????????
?????ж?????????????????????????????????????????????????????????????????????I/O??SQL????
??????????????????
????1.????????????
????Sending binlog event to slave
????????????????????????????????????????????Щ????????????????????????????????????????????????????????????
????Finished reading one binlog; switching to next binlog
?????????????????????????????????????????????????????????????
????Has sent all binlog to slave; waiting for binlog to be updated
??????????????????????????????????2???????????????????????????????У?????????????????μ???μ??μ???????????????е????????
????Waiting to finalize termination
????????????????????????????
????2.?????I/O?????
????Connecting to master
??????????????????????????
????Checking master version
??????????????????????????????????????????
????Registering slave on master
??????????????????????????????????????????
????Requesting binlog dump
???????????????????????????????????????????????????????????????????????????????????????????λ?????????????????????
????Waiting to reconnect after a failed binlog dump request
??????????????????????????(???????????)???????????????????????????????????????–master-connect-retry?????????????????
????Reconnecting after a failed binlog dump request
???????????????????????????????
????Waiting for master to send event
???????????????????????????????????????????????????????????????У????????????????????????slave_read_timeout????????????????????????????ж??????????????
????Queueing master event to the relay log
?????????????????????????????????м??????SQL??????????
????Waiting to reconnect after a failed master event read
????????(???????????)???????????????????????????master-connect-retry??
????Reconnecting after a failed master event read
???????????????????????????????????????????????????Waiting for master to send event??
????Waiting for the slave SQL thread to free enough relay log space
????????????????relay_log_space_limit????м???????????????????С?????????I/O???????????SQL???????м?????????????????м??????????????????