mysql查询当前线程对应的sql语句

#首先查看对应的线程
show processlist;
#记住对应的id
select * from `performance_schema`.events_statements_current where THREAD_ID=刚才的id
#也可以范围查找
select * from `performance_schema`.events_statements_current where THREAD_ID>=刚才的id
#查出来后,字段SQL_TEXT就是该线程对应的sql语句
posted @ 2021-01-07 16:32  zhooke  阅读(37)  评论(0)    收藏  举报