查询processlist快照数据
更新时间:2022-11-17
接口说明
查询processlist快照数据
请求URI
GET /v{version}/instance/{instanceId}/performance/processlist
请求体参数
无
响应体参数
无
请求示例
无
响应示例
HTTP/1.1 200 OK
<公共响应头>
{
"datetime": "2021-08-23 17:54:49",
"processList": [
{
"sql": "select * from test", //原INFO字段
"db": "test",
"state": "Waiting on empty queue",
"host": "localhost",
"command": "Daemon",
"user": "event_scheduler",
"time": 3635,
"id": 1,
"lockHold": { // 锁持有
"12757825:43:10:2": [ // 持有锁的ID,也就是trx 里面的request lock ID
20151179 // 锁住的process list 里面的ID 也就是MySQL thread ID
]
},
"lockWait": [
{
"lockId": "12757825:43:10:2",
"id": 20151178
}
]
}
]
}
错误码
请参考通用错误码