Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 慢sql（根据主键更新）
|
username: Hacker_QfCMflZ4
【TiDB Usage Environment】Production Environment
【TiDB Version】7.0.0
【Reproduction Path】Observed an update taking 2.7s in slow SQL monitoring, updating based on the primary key
【Encountered Problem: Phenomenon and Impact】
UPDATE
`wfc_batch_operate_log`
SET
`update_time` = '2023-06-25 15:09:50'
WHERE
`id` = 878221950497316865;
It’s a very simple SQL to update the time based on the primary key.
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: