ProxySQL Client Connections

Issue

When I Query ProxySQL Client Connections :

select * from stats.stats_mysql_global where variable_name like ‘Client_connection%’;

+-------------------------------------+----------------+
| Variable_Name                       | Variable_Value |
+-------------------------------------+----------------+
| Client_Connections_aborted          | 0              |
| Client_Connections_connected        | 495            |
| Client_Connections_created          | 43785          |
| Client_Connections_non_idle         | 495            |
| Client_Connections_hostgroup_locked | 0              |
+-------------------------------------+----------------+

Connections non idle is always same with connections non idle;

But when I query on Process List :

show processlist;

in the command fields, all status is Sleep.

The Client_Connections_non_idle must be zero, but not in my case.

What is wrong with my thought ?

Thanks for any explanation of my problems.

I am using ProxySql v2.4.2

Solution

I already find the solution of my problem. Before i set wait_timeout too big, after I set wait_timeout into 30000 (30 second) it is normal.

Answered By – Primadi

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published