DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Watch Processlist

10.22.2011
| 2440 views |
  • submit to reddit
        // If you want to keep an eye on the queries, you can "watch" them in a separate tab.

watch mysqladmin processlist

or

watch -n 10 -d "mysqladmin proc -uroot -pPassWd | grep -v Sleep"

or

watch --interval=1 --differences 'mysql -uroot -pPassWd -e "show slave status\G"'