0

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

Primadi
  • 1
  • 4

2 Answers2

0

According to the ProxySQL documentation

Client_Connections_non_idle : number of client connections that are currently handled by the main worker threads. If ProxySQL isn’t running with “–idle-threads”, Client_Connections_non_idle is always equal to “Client_Connections_connected”

So unless you run ProxySQL with --idle-threads this is expected behaviour and nothing to worry about. You can read more about idle threads in the documentation

izzy
  • 358
  • 4
  • 7
  • But I already run ProxySQL with --idle-threads. This is my command to start proxySQL: proxysql --idle-threads -c /var/lib/proxysql/proxy01/proxysql01.cnf – Primadi Jul 25 '22 at 05:22
0

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.

T.S.
  • 18,195
  • 11
  • 58
  • 78
Primadi
  • 1
  • 4