X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=README.md;h=aa431a86117dbd562b9807a22c45f805b1fc0434;hb=19895ca8d31deea9680395e11e889d4b32a58bd4;hp=b05a69c38bb7034851b1666a6de04394906253de;hpb=65c9ae05af2882d60512d5beefa99dae232d9f16;p=pstop.git diff --git a/README.md b/README.md index b05a69c..aa431a8 100644 --- a/README.md +++ b/README.md @@ -14,11 +14,24 @@ the actiity of those users. Install and update this go package with `go get -u github.com/sjmudd/pstop` +### Dependencies + +The following Non-core Go dependencies are: +* github.com/sjmudd/mysql_defaults_file for connecting to MySQL via +a defaults file. +* github.com/nsf/termbox-go a library for creating cross-platform +text-based interfaces. + ### Configuration -Access to MySQL is currently via a defaults-file which is assumed -to be `~/.my.cnf`. Alternatively you can now provide --defaults-file=/path/to/.my.cnf if needed. +Access to MySQL can be made by one of the following methods: +* Default: use a defaults-file named `~/.my.cnf`. +* use an explicit defaults-file with `--defaults-file=/path/to/.my.cnf`. +* connect to a host with `--host=somehost --port=999 --user=someuser --password=somepass`, or +* connect via a socket with `--socket=/path/to/mysql.sock --user=someuser --password=somepass` + +The user if not specified will default to the contents of `$USER`. +The port if not specified will default to 3306. ### Grants @@ -37,7 +50,9 @@ 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. +in seconds makes the output far less interesting. Total idle time is also +shown as this gives an indication of perhaps overly long idle queries, +and the sum of the values here if there's a pile up may be interesting. You can change the polling interval and switch between modes (see below). @@ -79,7 +94,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