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…