MySQL Forums
Forum List  »  Replication

Master binlog Dump hang with status: Finished reading one binlog; switching to next binlog NULL
Posted by: Alex Ng
Date: April 21, 2016 02:35AM

we have 5.5.39-enterprise-commercial-advanced-log, running on redhat7, with SSD, and qps around 7000/s, and tps around 400/s, having 30 slaves pointing to same master.

As some peak time, we have all slave day for about 50minutes, and we check master show processlist, no out-standing locks, cpu/io/network are not very high, and just as normal. but we around 10 binlog generated in master, and waiting to transfer to slave, what's the reason?


77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12576308 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12576908 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12577508 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12578108 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12578708 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12579308 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12579908 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12580508 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12581108 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12581708 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12582308 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12582908 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12583508 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12584108 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12584708 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12585308 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12595508 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12596108 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12596708 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12597308 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12597908 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12599108 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12599708 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12604508 Finished reading one binlog; switching to next binlog NULL
77 slave Search02.xxxx.net:40527 NULL Binlog Dump 12606308 Finished reading one binlog; switching to next binlog NULL

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.