- 현재 사용중인 mytop 화면 (단점, 1대의 서버만 관리가
가능하다.)
MySQL on localhost (4.1.7-log) up
41+22:34:02 [12:44:18]
Queries: 127.6M qps: 37 Slow: 11.0k Se/In/Up/De(%):
41/02/02/00
qps now: 16 Slow qps: 0.0 Threads: 62 ( 2/ 5)
19/00/00/00
Cache Hits: 21.6M Hits/s: 6.3 Hits now: 1.0 Ratio: 41.6% Ratio
now: 33.3%
Key Efficiency: 100.0% Bps in/out: 549.7/305.6 Now in/out:
1.7k/15.0k
Id User Host/IP DB Time Cmd
Query or State
-- ---- ------- -- ---- ---
----------
16375021 abcdef 192.16.1.1 jerry01 0 Sleep
16642479 root localhost mysql 0 Query show
full processl
16257319 abcdef 192.16.1.2 jerry01 2 Sleep
16373235 abcdef 192.16.1.1 jerry01 2 Sleep
16584263 abcdef 192.16.1.1 jerry01 2 Sleep
16590792 abcdef 192.16.1.1 jerry01 2 Sleep
16591919 abcdef 192.16.1.1 jerry01 2 Sleep
16586439 abcdef 192.16.1.2 jerry01 5
Sleep
- 현재 구상중인 mytop 화면 (장점, 프로그램 하나로 수십대의 DB를
모니터링 한다.
단점, 완성될지가 의문이다. 만약 완성된다면 버그수도
의심스럽다)
[11:51:44]
Id User Host/IP Client/IP DB Time
Query or State
---- ---------- --------------- --------------- -------- ----
-----------------
1234 1234567890 000.000.000.000 000.000.000.000 12345678 1234
12345678901234567
1234 1234567890 000.000.000.000 000.000.000.000 12345678 1234
12345678901234567
1234 1234567890 000.000.000.000 000.000.000.000 12345678 1234
12345678901234567
1234 1234567890 000.000.000.000 000.000.000.000 12345678 1234
12345678901234567
1234 1234567890 000.000.000.000 000.000.000.000 12345678 1234
12345678901234567
1234 1234567890 000.000.000.000 000.000.000.000 12345678 1234
12345678901234567
|