diff options
author | Costa Tsaousis (ktsaou) <costa@tsaousis.gr> | 2015-11-19 01:23:42 +0200 |
---|---|---|
committer | Costa Tsaousis (ktsaou) <costa@tsaousis.gr> | 2015-11-19 01:23:42 +0200 |
commit | d919264e33308b44b18f04a46568c5cb801b5255 (patch) | |
tree | b2a944d19854c517c77a8303d6c3406a1dae8477 /charts.d/README.md | |
parent | 6ca901daefa6c7d63fe1a60f88d3db46cf14e117 (diff) |
minor fixes; mysql now accepts multiple servers
Diffstat (limited to 'charts.d/README.md')
-rw-r--r-- | charts.d/README.md | 78 |
1 files changed, 78 insertions, 0 deletions
diff --git a/charts.d/README.md b/charts.d/README.md index 170f587f43..fd66c0d6a1 100644 --- a/charts.d/README.md +++ b/charts.d/README.md @@ -1,5 +1,83 @@ The following charts.d plugins are supported: +# mysql + +The plugin will monitor one or more mysql servers + +It will produce the following charts: + +1. **Bandwidth** in kbps + * in + * out + +2. **Queries** in queries/sec + * queries + * questions + * slow queries + +3. **Operations** in operations/sec + * opened tables + * flush + * commit + * delete + * prepare + * read first + * read key + * read next + * read prev + * read random + * read random next + * rollback + * save point + * update + * write + +4. **Table Locks** in locks/sec + * immediate + * waited + +5. **Select Issues** in issues/sec + * full join + * full range join + * range + * range check + * scan + +6. **Sort Issues** in issues/sec + * merge passes + * range + * scan + +### configuration + +You can configure many database servers, like this: + +You can provide, per server, the following: + +1. a name, anything you like, but keep it short +2. the mysql command to connect to the server +3. the mysql command line options to be used for connecting to the server + +Here is an example for 2 servers: + +```sh +mysql_opts[server1]="-h server1.example.com" +mysql_opts[server2]="-h server2.example.com --connect_timeout 2" +``` + +The above will use the `mysql` command found in the system path. +You can also provide a custom mysql command per server, like this: + +```sh +mysql_cmds[server2]="/opt/mysql/bin/mysql" +``` + +The above sets the mysql command only for server2. server1 will use the system default. + +If no configuration is given, the plugin will attempt to connect to mysql server at localhost. + +--- + # squid The plugin will monitor a squid server. |