Hi all,
I would like to discuss the impact of high mysql connection counts (threadsConnected) on Percona XtraDB Cluster (PXC) 8.0 health and performance. Let’s assume 5 node cluster (PXC 8.0) including one garbd deamon with 2 load balancers (with single-writer setup)
In general, is my assumption correct that even if threadsConnected is relatively high (cca 110 connections), the cluster’s replication health remains unaffected as long as Flow Control is not triggered?
In other words, is connection count a secondary metric compared to wsrep_flow_control_paused, or can a high number of open connections (even if many are in a Sleep state) negatively impact the cluster’s health and performance?
Your input will be much appreciated!