Hi mosi0815 , my apologies for the delay on this topic. Our Developers want to confirm that you are collecting data at the same point in time, that there isn’t any potential for drift between what ProxySQL vs proxysql_exporter reports. Can you please run the commands below, and replace IP with the address of the instance where proxysql_exporter is running:
date
curl -s --insecure https://IP:42004/metrics | grep proxysql_connection_pool_status
date
mysql -uadmin -padmin -S/tmp/proxysql_admin.sock -e "select * from stats_mysql_connection_pool ORDER BY hostgroup, srv_host, srv_port;"
date
mysql -uadmin -padmin -S/tmp/proxysql_admin.sock -e "select * from runtime_mysql_servers"
Thanks mosi0815 ,