Closed BohuTANG closed 2 weeks ago
Seems http handler not store host.
MySQL [(none)]> show processlist;
+------------------------+--------------------------------------+-------+-----------------+------+---------+----------+-------------------+--------------+-----------------+------------------+-------------------------+--------------------------+---------------------+------+--------------------+
| node | id | type | host | user | command | database | extra_info | memory_usage | data_read_bytes | data_write_bytes | scan_progress_read_rows | scan_progress_read_bytes | mysql_connection_id | time | status |
+------------------------+--------------------------------------+-------+-----------------+------+---------+----------+-------------------+--------------+-----------------+------------------+-------------------------+--------------------------+---------------------+------+--------------------+
| VGg035BPa9QqAocYk7rLx7 | 797ecdbe-8228-486b-aff2-d4a7f23f9183 | MySQL | 127.0.0.1:58216 | root | Query | default | SHOW PROCESSLIST | 0 | 0 | 0 | 0 | 0 | 18 | 0 | executing pipeline |
+------------------------+--------------------------------------+-------+-----------------+------+---------+----------+-------------------+--------------+-----------------+------------------+-------------------------+--------------------------+---------------------+------+--------------------+
1 row in set (0.025 sec)
:) show processlist;
SHOW PROCESSLIST
┌─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ node │ id │ type │ host │ user │ command │ database │ extra_info │ memory_usage │ data_read_bytes │ data_write_bytes │ scan_progress_read_rows │ scan_progress_read_bytes │ mysql_connection_id │ time │ status │
│ String │ String │ String │ Nullable(String) │ String │ String │ String │ String │ Int64 │ UInt64 │ UInt64 │ UInt64 │ UInt64 │ Nullable(UInt32) │ UInt64 │ String │
├────────────────────────┼──────────────────────────────────────┼───────────┼──────────────────┼────────┼─────────┼──────────┼───────────────────┼──────────────┼─────────────────┼──────────────────┼─────────────────────────┼──────────────────────────┼─────────────────────┼────────┼────────────────────┤
│ VGg035BPa9QqAocYk7rLx7 │ c8b2764a-6c55-40fb-8d33-328b01287006 │ HTTPQuery │ NULL │ root │ Query │ default │ SHOW PROCESSLIST │ 0 │ 0 │ 0 │ 0 │ 0 │ NULL │ 0 │ executing pipeline │
└─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
Summary
The client host is NULL in show processlist: