使用統計資訊來檢測叢集內複製的延遲

使用集群貨幣統計資訊來幫助主動發現集群內資料庫複製的延遲。

程序

在叢集中某台伺服器的控制台輸入以下指令，查看統計資料： 
show stat replica.cluster.currency.*

一組貨幣統計數據報告資料庫上次與叢集中的每個其他伺服器進行複製的時間範圍。統計資料按伺服器分組。

例如，以下輸出顯示伺服器在一分鐘內複製的所有 98 個副本與伺服器 Mail2/Renovations 相同：
[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