Mytop Short Cut Keys

To display the help screen which lists all the short cut keys use the "?" key.

  # - toggle short/long numbers (not yet implemented)
  c - command summary view (based on Com_* counters)
  d - show only a specific database
  e - explain the query that a thread is running
  f - show full query info for a given thread
  F - unFilter the display
  h - show only a specifc host's connections
  H - toggle the mytop header
  i - toggle the display of idle (sleeping) threads
  I - show innodb status
  k - kill a thread
  p - pause the display
  m - switch [mode] to qps (queries/sec) scrolling view
  o - reverse the sort order (toggle)
  q - quit
  r - reset the status counters (via FLUSH STATUS on your server)
  s - change the delay between screen updates
  t - switch to thread view (default)
  u - show only a specific user
  : - enter a command (not yet implemented)

Mytop is amazing software which can be found at http://jeremy.zawodny.com/mysql/mytop/ for download and additional documentation. This software should be used not only to monitor your MySQL server but to find ways of optimizing your MySQL server and the SQL statements that are being run.

Hopefully this brief overview gives you a starting point to get started with mytop and an idea of the things that can be done with it.