# Percona XtraDB Cluster

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster/5706>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [June 29, 2017, 3:19am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706 "2017-06-29T03:19:10Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Garcia](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Garcia](https://forums.percona.com/u/Garcia)\
**Post date:** [June 29, 2017, 3:19am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/1 "2017-06-29T03:19:10Z")

</div>

Hello, sorry for my English, there is such a problem, I configured Percona XtraDB Cluster on 3 servers, everything is working fine now, but how do I look at the time delay of the slave from the master? If I’m watching now

```auto
mysql -e "show slave status\G"

```

then I get nothing from this documentation [URL=“[http://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/](http://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/)”][https://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/[/URL]](https://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/%5B/URL%5D) swears at

```auto
Detected value is empty; something failed? Trigger exit status: 0

```

Seconds\_Behind\_Master parameter is not defined.  
How can I see the delay?

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [June 29, 2017, 4:44am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/2 "2017-06-29T04:44:43Z")

</div>

Hello,

PXC uses completely different replication technology then normal MySQL, hence “show slave status\G” is not supposed to give any output here.  
If you want to check the replication status, take a look at

```auto
show status like 'ws%';

```

Check our documentation for more details: [url][Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/index.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![Garcia](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Garcia](https://forums.percona.com/u/Garcia)\
**Post date:** [June 29, 2017, 4:50am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/3 "2017-06-29T04:50:20Z")

</div>

Thanks for the answer, I understand it, but what parameter is responsible for the delay between the slave of the master? wsrep\_flow\_control\_paused\_ns or wsrep\_flow\_control\_paused ? Or in general another parameter?

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [June 29, 2017, 4:57am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/4 "2017-06-29T04:57:46Z")

</div>

The wsrep\_flow\_control\_paused\_ns is rather to monitor total time when cluster is paused due to Flow Control. To find out which node is “lagging” you should check it’s wsrep\_local\_recv\_queue and wsrep\_flow\_control\_sent.  
Replicaiton delay in Galera is not really measured in seconds but in number of transactions waiting to be applied.

More information on that topic:  
[url][https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/[/url]](https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![Garcia](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Garcia](https://forums.percona.com/u/Garcia)\
**Post date:** [June 29, 2017, 5:18am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/5 "2017-06-29T05:18:00Z")

</div>

Thanks again for the answer, now I have such parameters  
server 1

```auto
wsrep_local_recv_queue 0
wsrep_flow_control_sent 0

```

server 2

```auto
wsrep_local_recv_queue 0
wsrep_flow_control_sent 2743050

```

server 3

```auto
wsrep_local_recv_queue 0
wsrep_flow_control_sent 22794

```

Whether it is possible somehow to monitor these parameters wsrep\_local\_recv\_queue and wsrep\_flow\_control\_sent through a zabbix, I adjusted monitoring under this documentation [URL][Percona Monitoring Plugins](https://www.percona.com/doc/percona-monitoring-plugins/LATEST/zabbix/index.html%5B/URL%5D)

But to which value should these parameters be wsrep\_local\_recv\_queue and wsrep\_flow\_control\_sent?

---

<div class="post-metadata">

**Author:** ![Garcia](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Garcia](https://forums.percona.com/u/Garcia)\
**Post date:** [June 29, 2017, 11:30am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/6 "2017-06-29T11:30:58Z")

</div>

Prompt if under this documentation [URL][Percona Monitoring Plugins](https://www.percona.com/doc/percona-monitoring-plugins/LATEST/zabbix/index.html%5B/URL%5D) there is an item MySQL.slave-lag this that that is necessary for me? Or you still have to watch wsrep\_local\_recv\_queue and wsrep\_flow\_control\_sent?

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [July 3, 2017, 11:39pm UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/7 "2017-07-03T23:39:20Z")

</div>

Since the templates in Zabbix are copied from Cacti ones there should be one for PXC- Galera Replication Queues  
[url][Percona Monitoring Plugins](https://www.percona.com/doc/percona-monitoring-plugins/1.1/cacti/galera-templates.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![Garcia](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Garcia](https://forums.percona.com/u/Garcia)\
**Post date:** [July 4, 2017, 4:20am UTC](https://forums.percona.com/t/percona-xtradb-cluster/5706/8 "2017-07-04T04:20:03Z")

</div>

Parameters and graphs in zabbix I can configure myself, but I need to understand what to set up? If Percona XtraDB Cluster does not have the Seconds\_Behind\_Master parameter, then I need to take the parameters wsrep\_local\_recv\_queue and wsrep\_flow\_control\_sent, but how can you tell by these parameters that there is a delay?
