Get processlist of MySQL

For non-sleep processlist:

$ mysql --login-path=root -e "SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST pl where pl.command not in ('Sleep')\G "  | less

For all processlist:


SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST

SHOW FULL PROCESSLIST

Comments

Popular posts from this blog

Check MySQL query history from command line