Donnerstag, 10. Mai 2012

Ever thought about mytop ?

Work related i do a lot of things with MySQL/MariaDB. If you ever wanted to real-time monitor your system i guess you want to use mytop as well
S | Name  | Summary               | Type
--+-------+-----------------------+--------
| mytop | A top Clone for MySQL | package

you can easily install it with
zypper in mytop

Now you can start it with
mytop -p <passord> -s 1

The option

  • -p tell it to use the password during connection

  • -s <seconds> tells the update intervall


Now you should see something like
MySQL on localhost (5.5.23-MariaDB-mariadb1~squeeze-log)   up 24+03:17:13 [11:27:05]
Queries: 271.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 121540/00/00/00
qps now: 2 Slow qps: 0.0 Threads: 2 ( 1/ 17) 00/00/00/00
Key Efficiency: 98.8% Bps in/out: 0.0/ 0.8 Now in/out: 41.4/11.3k

Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- --------------
47030 root localhost 0 Query show full processlist
47033 froxlor localhost:47453 froxlor 57 Sleep