X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=README.md;h=b05a69c38bb7034851b1666a6de04394906253de;hb=65c9ae05af2882d60512d5beefa99dae232d9f16;hp=b2f03c228dbaf283b87b3f55cb013f353a1e2c92;hpb=193ae41f5473832680f1969a1e0bc19bc27909b8;p=pstop.git diff --git a/README.md b/README.md index b2f03c2..b05a69c 100644 --- a/README.md +++ b/README.md @@ -10,34 +10,36 @@ update or delete activity. User activity is now shown showing the number of different hosts that connect with the same username and the actiity of those users. -This program was started as a simple project to allow me to learn -go, which I'd been following for a while, but hadn't used in earnest. -This probably shows in the code so suggestions on improvement are -most welcome. - ### Installation -Install and update this go package with `go get -u github.com/sjmudd/pstop +Install and update this go package with `go get -u github.com/sjmudd/pstop` ### Configuration Access to MySQL is currently via a defaults-file which is assumed -to be ~/.my.cnf. This should probably be made more configurable. -If you see a need for this please let me know. +to be `~/.my.cnf`. Alternatively you can now provide +-defaults-file=/path/to/.my.cnf if needed. ### Grants -Do not forget to ensure that the MySQL user you configure has access -to the performance_schema tables. +`pstop` needs `SELECT` access to `performance_schema` tables. It +will not run if access to the required tables is not available. ### Screens -pstop has 5 different screens: +pstop has 5 different screens which get updated by default every second. * Latency mode: order table activity by the time waiting to perform operations on them. * Ops (operations) mode: order table activity by the number of operations MySQL performs on them. * I/O mode: show where MySQL is spending it's time in file I/O. * Locks mode: show order based on table locks -* User mode: show ordering based on how long users are running queries, or the number of connections they have to MySQL. +* User mode: show ordering based on how long users are running +queries, or the number of connections they have to MySQL. This is +really missing a feature in MySQL (see: http://bugs.mysql.com/75156) +to provide higher resolution query times than seconds. It gives +some info but if the queries are very short then the integer runtime +in seconds makes the output far less interesting. + +You can change the polling interval and switch between modes (see below). ### Keys @@ -55,9 +57,25 @@ The following keys allow you to navigate around the different pstop displays or ### See also -See also BUGS and NEW_FEATURES which describe things that probably -need looking at and screen_samples.txt which provides some sample -output from my own system. +See also: +* [BUGS](https://github.com/sjmudd/pstop/blob/master/BUGS) currently known issues +* [NEW_FEATURES](https://github.com/sjmudd/pstop/blob/master/NEW_FEATURES) which describe things that probably need looking at +* [screen_samples.txt](https://github.com/sjmudd/pstop/blob/master/screen_samples.txt) provides some sample output from my own system. + +### Contributing + +This program was started as a simple project to allow me (Simon) to learn +go, which I'd been following for a while, but hadn't used in earnest. +This probably shows in the code so suggestions on improvement are +most welcome. + +You may find "Contributing to Open Source Git Repositories in Go" +by Katrina Owen to be useful: +https://blog.splice.com/contributing-open-source-git-repositories-go/ + +### Licensing + +BSD 2-Clause License ### Feedback