X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=README.md;h=44105b262e7ae14a1391c34d38b5cad61f570b4e;hb=f742608f4ad8442336a9ca3b1cbedfe8df183a27;hp=d1a22f2a6c67fc552c5ea91d1793cf7a4766367e;hpb=724089cf7925d3e7f54f4b9cf7be341d6fdbe8bf;p=pstop.git diff --git a/README.md b/README.md index d1a22f2..44105b2 100644 --- a/README.md +++ b/README.md @@ -17,8 +17,8 @@ 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 @@ -32,7 +32,12 @@ pstop has 5 different screens which get updated by default every second. * 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). @@ -74,7 +79,11 @@ BSD 2-Clause License ### Feedback -Feedback and patches welcome. +Feedback and patches welcome. I am especially interested in hearing +from you if you are using pstop, or if you have ideas of how I can +better use other information from the performance_schema tables to +provide a more complete vision of what MySQL is doing or where it's +busy. Simon J Mudd