添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

However, it can’t be filtered. If you’d like to retrieve processes like usual SQL syntax, it can be replaced with:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

Now, you can filter process with WHERE clause.

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE
    DB = 'your_database_name' AND
    USER = 'username_runnning_query';

Order by Time

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE
    DB = 'development' AND
    USER = 'myuser'
ORDER BY TIME DESC;

See also

  • how to customize show processlist in mysql? - Stack Overflow
  • MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.29 SHOW PROCESSLIST Statement
  •