mysql复制风暴_【案例】主从替换之后的复制风暴

bool show_master_info(THD* thd, Master_info* mi)

{

/*省略*/

/*

Seconds_Behind_Master: if SQL thread is running and I/O thread is

connected, we can compute it otherwise show NULL (i.e. unknown).

*/

if ((mi->slave_running == MYSQL_SLAVE_RUN_CONNECT) &&

mi->rli.slave_running)

{

long time_diff= ((long)(time(0) - mi->rli.last_master_timestamp)

- mi->clock_diff_with_master);

/*

Apparently on some systems time_diff can be <0. Here are possible

reasons related to MySQL:

- the master is itself a slave of another master whose time is ahead.

- somebody used an explicit SET TIMESTAMP on the master.

Possible reason related to granularity-to-second of time functions

(nothing to do with MySQL), which can explain a value of -1:

assume the master's and slave's time are perfectly synchronized, and

that at slave's connection time, when the master's timestamp is read,

it is at the very end of second 1, and (a very short time later) when

the slave's timestamp is read it is at the very beginning of second

2. Then the recorded value for master is 1 and the recorded value for

slave is 2. At SHOW SLAVE STATUS time, assume that the difference

between timestamp of slave and rli->last_master_timestamp is 0

(i.e. they are in the same second), then we get 0-(2-1)=-1 as a result.

This confuses users, so we don't go below 0: hence the max().

last_master_timestamp == 0 (an "impossible" timestamp 1970) is a

special marker to say "consider we have caught up".

*/

protocol->store((longlong)(mi->rli.last_master_timestamp ?

max(0, time_diff) : 0));

}

else

{

protocol->store_null();

}

/*省略*/

}