Menu Close

Month: March 2015

View Live current mysql queries

For see from command line current execution of queries you can use:

$ mysqladmin -u bob -p -i 1 processlist

This will print the current queries on your screen every second.

  • -u The mysql user you want to execute the command as
  • -p Prompt for your password (so you don’t have to save it in a file or have the command appear in your command history)
  • i The interval in seconds.

If you want to see output like “SHOW FULL PROCESSLIST” you can attach “–verbose” to the command.