http://blog.chinaunix.net/uid-16844903-id-4054635.html website Link: http://www.percona.com/doc/ Percona-monitoring-plugins/1.0/cacti/galera-templates.html
- Galera Writeset Traffic
- Galera Writeset Count
- Galera Writeset Size
- Galera Replication Queues
- Galera parallelization efficency
- Galera Writing Conflicts
- Galera Cluster Size
- Galera Flow Control
Galera Writeset Traffic
This diagram shows:
- Wsrep Replicated Bytes
In the cluster, the data that is copied from this node. That is, the outgoing data.
- Wsrep Received Bytes
In a cluster, the data that this node receives from other nodes.
Galera Writeset Count
- Wsrep Replicated
The number of transactions replicated from this node in the cluster
- Wsrep Received
The number of times that this node receives transactions from other nodes in the cluster
Galera Writeset Size
- Writeset Size Replicated
Average transaction size sent to other nodes
- Writeset Size Received
The average transaction size received from other nodes is the following variable associated with the graph:
Writesets size of Wsrep_replicated_bytes sent to other nodes
Wsrep_received_bytes writesets size received from other nodes
wsrep_replicated number of writesets sent to other nodes
Wsrep_received number of writesets received from other nodes
Galera Replication Queues
- Wsrep Local Send Queue
The length of the current send queue. That is, the number of writesets waiting to be sent.
- Wsrep Local Recv Queue
The length of the current receive queue, that is, the number of writesets waiting to be executed.
Galera parallelization efficency
Parallelization efficiency, this graph shows the average distance that can be executed or committed in parallel in the highest and lowest sequence.
- Wsrep Apply Window
Average distance between highest and lowest concurrently applied sequence number.
- Wsrep Commit Window
Average distance between highest and lowest concurrently committed sequence number.
- Wsrep Cert Deps Distance
Average distance between highest and lowest sequence Numbet that can is possibly applied in parallel.
Galera Writing Conflicts
Write conflicts. Before committing a transaction locally, the validation test fails and the client receives a deadlock error. At this point, the transaction is denied execution on the local node.
- Wsrep Local Cert Failures
The number of local transaction authentication test failures.
- Wsrep Local Bf Aborts
The number of transactions that were aborted in the application transaction in the replication.
Galera Cluster Size
- Wsrep Cluster Size
Number of nodes in the cluster
Galera Flow Control
Throttle control. The figure shows the number of Fc_pause events sent and received.
- Wsrep Flow Control Paused
Because throttle control replication is paused (compared to the last state query)
- Wsrep Flow Control Sent
The number of Fc_pause events sent since the last status query
- Wsrep Flow Control Recv
The number of Fc_pause events received since the last State query
|
IMPORTANT NOTE
This throttling control graphic may be wrong before the bug is repaired (Galera 2.x cannot be repaired). Reason:
The template execution is show STATUS, and the failed thread may see a different result. |
Percona-galera-monitoring-template Monitoring Template Description
