The value of the mem column in the SQL query results displayed by CLUSTER_PROCESSLIST is too large. The value found is the maximum value of bigint

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 查询CLUSTER_PROCESSLIST表现出的 SQL 查询结果中的 mem列的值太大。查出来值为 biginit的最大值

| username: Curiouser

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed that led to the issue
【Encountered Issue: Problem Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots / Logs / Monitoring】

image
image1380×342 105 KB

2
| username: Billmay表妹 | Original post link

What is your question? What problem do you want to solve?

3
| username: Curiouser | Original post link

Is the value in MEM the memory currently used by SQL? If so, it completely exceeds the total memory size of the server. Then this value is inaccurate. I would like to understand more about it.

4
| username: Anna | Original post link
5
| username: Raymond | Original post link

This is an expected phenomenon; this value is inaccurate in many versions.

6
| username: onlyacat | Original post link

It is inaccurate, often collecting this.

7
| username: redgame | Original post link

This is just an expectation.