使用統計資料以偵測叢集內抄寫的延遲

使用叢集貨幣統計資料以協助主動找出叢集內資料庫抄寫中的延遲。

程序

在叢集中伺服器的主控台輸入下列指令,以查看統計資料:
show stat replica.cluster.currency.*

一組貨幣統計資料會報告資料庫上次以叢集中其他每部伺服器進行抄寫的時間範圍。統計資料是依據伺服器進行分組。

比方說,下列輸出會顯示伺服器與 Mail2/Renovations 伺服器在一分鐘內抄寫,相同的所有 98 個抄本:
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Outside8Hours = 0
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Uninitialized = 0
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Within15Min = 0
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Within1Hour = 0
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Within1Min = 98
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Within4Hours = 0
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Within5Min = 0
[00134C:000008-00000000000004AC]   Replica.Cluster.Currency.Mail2/Renovations.Within8Hours = 0