The connection thread status of TiDB has issues

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

Original topic: l连接tidb线程状态有问题

| username: TiDBer_zWsmzAL8

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed that led to the issue
【Encountered Issue: Problem Symptoms and Impact】

【Attachments: Screenshots/Logs/Monitoring】

| username: xfworld | Original post link

What is this? :face_with_spiral_eyes:

| username: 啦啦啦啦啦 | Original post link

Do you mean the result of “show processlist”?

| username: 我是咖啡哥 | Original post link

Large transaction, right? In transaction…

| username: Anna | Original post link

What? There’s no description.

| username: Edwin | Original post link

This image information is not enough.
Could it be a row lock? Low SQL efficiency causing slow transactions? Is it due to such high business traffic?

| username: TiDBer_zWsmzAL8 | Original post link

The cause of this issue has been identified; it was a design problem in development. It’s resolved now, thanks a lot.

| username: ShawnYan | Original post link

It’s good that it’s resolved. Next time, remember to provide more details so that everyone knows where to start to help you analyze the problem.

| username: redgame | Original post link

Looks very technical.

| username: TiDBer_zWsmzAL8 | Original post link

Okay, got it.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.