all-IT

It's amazing that in such useful tools as mytop getting late attention, even more so. It is that mysql monitoring tool mytop a true gem for all of us who can not be put off by a command line.

Mytop shows all the data on the performance, and the threads currently executing SQL queries, the MySQL database server. The data are processed and almost as a command line tool top (for processes).

Mytop is available for Windows, Mac and Linux. On Ubuntu, install it using apt easiest.

  sudo apt-get install mytop 

After installation you can start mytop either via the command line

  -p < passwort > mytop-u <username>-p <password> 

or the user name, password and other parameters in the configuration file ~/.mytop deposit.

  A
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11

  benuztername > user = 'user name here>
   passwort > pass = <password>
   host = localhost
   db = test
   delay = 5
   port = 3306
   socket =
   batch-mode = 0
   header = 1
   color = 1
   idle = 1 

  > Mytop 

Finally, a few shortcuts, it is the full list here :

k

Terminates a thread

p

stops updating the display

q

End of mytop

It is amazing that you will later draw attention to such useful tools as mytop, even more so. It is that mysql monitoring tool mytop a true gem for all of us who can not be put off by a command line. Mytop shows all the data on the performance, and the threads currently executing SQL queries, the MySQL database server. The data are processed and almost as a command line tool top (for processes). Mytop is available for Windows, Mac and Linux. On Ubuntu, install it using apt easiest. sudo apt-get install mytop After installation you can start mytop either via the command line mytop-u-p or the user name, password and further define the parameters in the configuration file ~ /. mytop. user = password = host = localhost db = test delay = 5 port = 3306 socket = batch mode = 0 header = 1 color = 1 idle = 1> mytop Finally, a few shortcuts, is the complete list is available here: k Terminates a thread p to update the display stops at q quit mytop

gklinkmann written by \ \ tags: linux , macos , tools , windows