ROOT用户登陆:
SELECT
t1.PROCESSLIST_user 登陆用户,
t2.HOST AS 登录HOST,
t1.PROCESSLIST_DB AS 操作数据库,
t1.PROCESSLIST_TIME AS 执行时长,
t1.THREAD_OS_ID AS 系统进程ID,
t2.id AS 数据库进程ID,
t2.INFO AS 相关SQL
FROM
`performance_schema`.threads t1,
information_schema.`PROCESSLIST` t2
WHERE
t1.PROCESSLIST_ID = t2.id
ORDER BY
PROCESSLIST_TIME DESC