mysqladmin pr |grep -v Sleep To show only sleep processes
mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY TIME DESC; To show processes in ascending order.
=============================
mysqladmin flush-hosts Flush all cached hosts
mysqladmin status Gives a short status message from the server
mysqladmin processlist Show list of active threads in server
No comments:
Post a Comment