How to monitor MySQL process.

rpaco@choi:~$ mytop -uroot -p<mypassword>

Output should be like this.

MySQL on localhost (5.0.45) up 0+05:34:18 [15:50:11]
Queries: 16.6M qps: 869 Slow: 0.0 Se/In/Up/De(%): 20/00/00/00
qps now: 682 Slow qps: 0.0 Threads: 9 ( 1/ 1) 22/00/00/00
Key Efficiency: 99.9% Bps in/out: 0.0/ 1.8 Now in/out: 8.4/ 1.4k

Id User Host/IP DB Time Cmd Query or State
— —- ——- — —- — ———-
5 webserverpage localhost:37034 webserverpage 0 Sleep
243 root localhost test 0 Query show full processlist
3 webserverpage localhost:58948 webserverpage 3 Sleep
8 webserverpage localhost:56914 webserverpage 5 Sleep
2 webserverpage localhost:49081 webserverpage 6 Sleep
6 webserverpage localhost:47071 webserverpage 6 Sleep
1 webserverpage localhost:50606 webserverpage 248 Sleep
7 webserverpage localhost:48746 webserverpage 254 Sleep
4 webserverpage localhost:52620 webserverpage 297 Sleep

Leave a Reply