From 529c4f067beebdfb751c4f8e8555435f8708ecbc Mon Sep 17 00:00:00 2001 From: Simon J Mudd Date: Fri, 14 Nov 2014 21:50:35 +0100 Subject: [PATCH] Add a couple of extra files to give more help --- README.md | 3 +- keys.txt | 20 +++++++++++++ screen_samples.txt | 75 ++++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 97 insertions(+), 1 deletion(-) create mode 100644 keys.txt create mode 100644 screen_samples.txt diff --git a/README.md b/README.md index 76d8d0d..3c89531 100644 --- a/README.md +++ b/README.md @@ -18,7 +18,8 @@ Access to MySQL is currently via a defaults-file which is assumed to be ~/.my.cnf. I should probably make this more configurable. See also BUGS and NEW_FEATURES which describe things that probably need -looking at. +looking at, keys.txt which describes the keys used inside pstop, and +screen_samples.txt which provides some sample output from my own system. Feedback and patches welcome. diff --git a/keys.txt b/keys.txt new file mode 100644 index 0000000..b88753a --- /dev/null +++ b/keys.txt @@ -0,0 +1,20 @@ + +pstop uses several keys. Help is available by pressing 'h'. This is what +it tells you. + + -------- + +pstop version 0.0.10 (C) 2014 Simon J Mudd + +Program to show the top I/O information by accessing information from the +performance_schema schema. Ideas based on mysql-sys. + +Keys: +- - reduce the poll interval by 1 second (minimum 1 second) ++ - increase the poll interval by 1 second +h - this help screen +q - quit +t - toggle between showing time since resetting statistics or since P_S data was collected +z - reset statistics + - change display modes between: latency, ops, file I/O and lock modes + diff --git a/screen_samples.txt b/screen_samples.txt new file mode 100644 index 0000000..9a8e5c6 --- /dev/null +++ b/screen_samples.txt @@ -0,0 +1,75 @@ +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] +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% +wordpress.wp_options 192.48 ms 10.8%| 99.1% 0.9% +wordpress.wp_posts 109.03 ms 6.1%|100.0% +wordpress.wp_commentmeta 54.86 ms 3.1%| 18.2% 81.8% +wordpress.wp_term_relationshi 27.85 ms 1.6%|100.0% +wordpress.wp_usermeta 18.35 ms 1.0%|100.0% +wordpress.wp_postmeta 16.90 ms 0.9%|100.0% +wordpress.wp_term_taxonomy 15.60 ms 0.9%|100.0% +wordpress.wp_terms 8.06 ms 0.5%|100.0% +wordpress.wp_users 2.06 ms 0.1%|100.0% + | +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] +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% +wordpress.wp_options 25.79 k 17.2%| 99.8% 0.2% +wordpress.wp_term_relationshi 19.07 k 12.7%|100.0% +wordpress.wp_posts 8.37 k 5.6%|100.0% +wordpress.wp_postmeta 2.89 k 1.9%|100.0% +wordpress.wp_term_taxonomy 2.59 k 1.7%|100.0% +wordpress.wp_terms 2.42 k 1.6%|100.0% +wordpress.wp_usermeta 2.10 k 1.4%|100.0% +wordpress.wp_commentmeta 666 0.4%| 88.1% 11.9% +wordpress.wp_users 58 0.0%|100.0% + | +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] +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% + 6.76 s 44.3%| 0.4% 0.4% 99.2%| 8.53 M 8.05 M| 763 55.0% 36.4% 8.5% +wordpress.wp_comments 1.09 s 7.2%| 83.8% 0.2% 16.0%|104.81 M 28.83 k|393.50 k 66.6% 0.0% 33.3% +wordpress.wp_options 71.20 ms 0.5%| 3.0% 2.4% 94.6%|608.92 k 352.00 k| 100 45.0% 22.0% 33.0% +wordpress.wp_posts 66.68 ms 0.4%| 82.9% 17.1%| 9.52 M | 21.47 k 65.6% 34.4% +wordpress.wp_commentmeta 12.38 ms 0.1%| 58.6% 24.0% 17.4%|207.73 k 57.48 k| 3.82 k 57.8% 8.8% 33.4% +wordpress.wp_usermeta 8.21 ms 0.1%| 14.3% 1.0% 84.7%|369.44 k 16.00 k| 43 69.8% 2.3% 27.9% + 5.56 ms 0.0%| 0.9% 76.2% 22.9%| 24.12 k 121.44 k| 178 2.8% 85.4% 11.8% +wordpress.wp_term_relationshi 715.04 us | 72.8% 27.2%|144.64 k | 27 59.3% 40.7% +wordpress.wp_users 621.54 us | 76.0% 24.0%|130.99 k | 26 57.7% 42.3% +... + +TOTALS 15.26 s 100.0%| 6.6% 0.3% 93.1%|125.37 M 8.69 M|421.77 k 66.3% 0.2% 33.5% + +----------------------------------------------------------------------------- + +pstop 0.0.10 - 21:44:27 xxxxxxxxxxxxx / 5.6.16-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% +wordpress.wp_posts 1.28 ms 15.6%|100.0% | 22.8% 77.2%| +wordpress.wp_comments 1.02 ms 12.4%| 91.1% 8.9%| 26.5% 64.6%| 3.0% 5.9% +wordpress.wp_postmeta 528.15 us 6.4%|100.0% | 36.0% 64.0%| +wordpress.wp_commentmeta 431.00 us 5.2%| 63.3% 36.7%| 16.3% 47.0%| 13.6% 23.0% +wordpress.wp_terms 305.62 us 3.7%|100.0% | 32.7% 67.3%| +wordpress.wp_term_relationshi 134.24 us 1.6%|100.0% | 33.2% 66.8%| +wordpress.wp_term_taxonomy 123.36 us 1.5%|100.0% | 45.7% 54.3%| +wordpress.wp_users 108.27 us 1.3%|100.0% | 37.2% 62.8%| +wordpress.wp_usermeta 106.90 us 1.3%| 98.0% 2.0%| 37.4% 60.6%| 0.6% 1.3% +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% -- 2.20.1