X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=screen_samples.txt;h=da58b8f27509f0335fa948323306057c983d34e3;hb=28f3ee44f6591ee899de237d7de027ae664d3eea;hp=81fb7d387b89ff29d9d0ea18edc4df8d250a451b;hpb=bc0b803e1869e15d6ac1f63aa51c576c84567341;p=pstop.git diff --git a/screen_samples.txt b/screen_samples.txt index 81fb7d3..da58b8f 100644 --- a/screen_samples.txt +++ b/screen_samples.txt @@ -2,7 +2,7 @@ Just to give you an idea of the info you can see here are some examples from my home system. Oh and if you didn't know already I use wordpress. This system is _very_ lightly loaded. -pstop 0.0.10 - 21:40:51 xxxxxxxxxxxxx / 5.6.16-log, up 13m 7s [ABS] +pstop 0.0.10 - 21:40:51 xxxxxxxxxxxxx / 5.6.xx-log, up 13m 7s [ABS] Latency by Table Name (table_io_waits_summary_by_table) 10 rows Table Name Latency %| Fetch Insert Update Delete wordpress.wp_comments 1.34 s 75.0%| 99.6% 0.4% @@ -20,7 +20,7 @@ TOTALS 1.78 s 100.0%| 97.0% 2.9% 0.1% ----------------------------------------------------------------------------- -pstop 0.0.10 - 21:42:01 xxxxxxxxxxxxx / 5.6.16-log, up 14m 17s [ABS] +pstop 0.0.10 - 21:42:01 xxxxxxxxxxxxx / 5.6.xx-log, up 14m 17s [ABS] Operations by Table Name (table_io_waits_summary_by_table) 10 rows Table Name Ops %| Fetch Insert Update Delete wordpress.wp_comments 85.91 k 57.3%|100.0% 0.0% @@ -38,7 +38,7 @@ TOTALS 149.85 k 100.0%| 99.9% 0.1% 0.0% ----------------------------------------------------------------------------- -pstop 0.0.10 - 21:43:10 xxxxxxxxxxxxx / 5.6.16-log, up 15m 26s [ABS] +pstop 0.0.10 - 21:43:10 xxxxxxxxxxxxx / 5.6.xx-log, up 15m 26s [ABS] File I/O by filename (file_summary_by_instance) Table Name Latency %| Read Write Misc|Rd bytes Wr bytes| Ops R Ops W Ops M Ops 7.22 s 47.3%| 0.1% 99.9%| 68.00 k 82.50 k| 240 2.5% 47.5% 50.0% @@ -57,7 +57,7 @@ TOTALS 15.26 s 100.0%| 6.6% 0.3% 93.1%|125.37 M ----------------------------------------------------------------------------- -pstop 0.0.10 - 21:44:27 xxxxxxxxxxxxx / 5.6.16-log, up 16m 43s [ABS] +pstop 0.0.10 - 21:44:27 xxxxxxxxxxxxx / 5.6.xx-log, up 16m 43s [ABS] Locks by Table Name (table_lock_waits_summary_by_table) Table Name Latency %| Read Write|S.Lock High NoIns Normal Extrnl|AlloWr CncIns Low Normal Extrnl wordpress.wp_options 4.15 ms 50.4%| 97.2% 2.8%| 34.1% 63.1%| 0.8% 1.9% @@ -73,3 +73,23 @@ wordpress.wp_usermeta 106.90 us 1.3%| 98.0% 2.0%| wordpress.wp_links 42.85 us 0.5%|100.0% | 24.3% 75.7%| | | | TOTALS 8.24 ms 100.0%| 95.6% 4.4%| 30.8% 64.8%| 1.1% 2.9% + +----------------------------------------------------------------------------- + +pstop 0.1.4 - 0:37:29 xxxxxxxxxxxxxxx / 5.6.xx-log, up 170d 13h 19m 1s [REL] 26 seconds +Activity by Username (processlist) 11 rows +User |Run Time %| Sleep %|Conn Actv|Hosts DBs|Sel Ins Upd Del Oth| +aaaaaaaaa | |00:04:01 72.4%|1146 1| 573 1| 1 | +bbbbbbbbbbbb | |00:01:04 19.2%| 2 | 1 | | +ccccccccc | |00:00:26 7.8%| 5 1| 3 1| | +ddddddd | |00:00:02 0.6%| 9 | 4 1| | +eeeeeeeee | | | 62 7| 62 | | +fffffffff | | | 24 | 17 1| | +gggggggg | | | 2 | 2 1| | +hhhhh | | | 1 1| 1 1| 1 | +iiiiiiiiiiiiii| | | 1 1| 1 | | +jjjjjjjjjjjj | | | 1 1| 1 | | +kkkkkkkkkkkkkk| | | 1 1| 1 | | +... + | | | | | | +Totals | |00:05:33 100.0%|1254 13| | 2 |