# PXC - wsrep\_local\_recv\_queue\_avg

**URL:** <https://forums.percona.com/t/pxc-wsrep-local-recv-queue-avg/3184>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [January 6, 2014, 6:20am UTC](https://forums.percona.com/t/pxc-wsrep-local-recv-queue-avg/3184 "2014-01-06T06:20:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dannyg](https://avatars.discourse-cdn.com/v4/letter/d/9fc29f/32.png) [@dannyg](https://forums.percona.com/u/dannyg)\
**Post date:** [January 6, 2014, 6:20am UTC](https://forums.percona.com/t/pxc-wsrep-local-recv-queue-avg/3184/1 "2014-01-06T06:20:37Z")

</div>

Hi,

i’ve started playing around with PXC and I’m testing it in an environment very similar to my production environment, we have 3 nodes in cluster and I’m trying to closely monitor the cluster status so i can understand when things go wrong.

my issue is with :

wsrep\_local\_recv\_queue | 0  
wsrep\_local\_recv\_queue\_avg | 0.205483

wsrep\_local\_recv\_queue\_avg, this value ranges anywhere between 0.205483 - 0.506762 on my nodes, is this good ? is this bad ? i understand that this means that the avg queue is bigger then what the node could apply, but whats a good avg ? is 0.0 even realistic ? currently i have 2 replication threads configured and everything is within a local LAN, machines have 64GB of RAM and SSD drives.

not sure what more can i do to lower the average…

Thanks,  
Danny.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [January 6, 2014, 8:10am UTC](https://forums.percona.com/t/pxc-wsrep-local-recv-queue-avg/3184/2 "2014-01-06T08:10:10Z")

</div>

wsrep\_local\_send\_queue\_avg should be as close to zero. If the value of wsrep\_local\_recv\_queue\_avg is higher then it leads towards slow node in the network and the node is overloaded. I would suggest to check this for more info [url][http://www.codership.com/wiki/doku.php?id=monitoring&s[/url][]=wsrep&s[]=flow&s[]=control&s[]=sent](http://www.codership.com/wiki/doku.php?id=monitoring&s%5B/url%5D%5B%5D=wsrep&s%5B%5D=flow&s%5B%5D=control&s%5B%5D=sent) and [url][Percona XtraDB Cluster](http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-status-index.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![dannyg](https://avatars.discourse-cdn.com/v4/letter/d/9fc29f/32.png) [@dannyg](https://forums.percona.com/u/dannyg)\
**Post date:** [January 6, 2014, 9:06am UTC](https://forums.percona.com/t/pxc-wsrep-local-recv-queue-avg/3184/3 "2014-01-06T09:06:26Z")

</div>

Hi Mirfan,

I’m talking about local recv queue not send queue, what’s concerning here is that i constantly see 0 on the recv queue but the avg is always bigger then 0:

| wsrep\_local\_send\_queue | 0 |  
| wsrep\_local\_send\_queue\_avg | 0.002475 |  
| wsrep\_local\_recv\_queue | 0 |  
| wsrep\_local\_recv\_queue\_avg | 0.321252 |  
| wsrep\_local\_cached\_downto | 7788205 |  
| wsrep\_flow\_control\_paused\_ns | 22231467821 |  
| wsrep\_flow\_control\_paused | 0.010708 |  
| wsrep\_flow\_control\_sent | 31 |  
| wsrep\_flow\_control\_recv | 37

this is of course causing flow control but i’m never able to see my wsrep\_local\_recv\_queue go above 0, so how the the avg be bigger ?

–Danny.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [January 8, 2014, 3:18am UTC](https://forums.percona.com/t/pxc-wsrep-local-recv-queue-avg/3184/4 "2014-01-08T03:18:51Z")

</div>

sorry, it was typo i mean wsrep\_local\_recv\_queue\_avg instead wsrep\_local\_send\_queue\_avg  
when looking into wsrep\_local\_recv\_queue\_avg is non-zero means that there a queue often, may be not large one and wsrep\_local\_recv\_queue is absolute value during show global status while \_avg is the average queue in between show global status runs.
