Developer Forums | About Us | Site Map
Search  
HOME > TUTORIALS > SERVER SIDE CODING > ADMINISTRATION TUTORIALS > USING MYTOP: A MYSQL MONITOR


Sponsors





Useful Lists

Web Host
site hosted by netplex

Online Manuals

Using Mytop: A MySQL Monitor
By Matthew Drouin - 2003-11-29 Page:  1 2 3 4 5

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 help screen screen shot

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.



View Using Mytop: A MySQL Monitor Discussion

Page:  1 2 3 4 5 Next Page: Mytop Introduction

Copyright 2003-2004 Matthew Drouin. All rights reserved.


Copyright 2004-2017 GrindingGears.com. All rights reserved.
Article copyright and all rights retained by the author.