X-Git-Url: https://arthur.barton.de/gitweb/?a=blobdiff_plain;f=python.d%2FREADME.md;h=5a7dd89d492a02a87d762c9a0b2ac29ccaaafb3f;hb=5ee4245093f673985ef270974c08c5cf9b844dbc;hp=b4407977103da210cc6813b0fafda326d44c43a5;hpb=a95df97d5d8079af5851a8d842a6aca64655e4e4;p=netdata.git diff --git a/python.d/README.md b/python.d/README.md index b4407977..5a7dd89d 100644 --- a/python.d/README.md +++ b/python.d/README.md @@ -1,6 +1,87 @@ +Every plugin supports changing its data collection frequency by setting `update_every` variable in its configuration file. + The following python.d plugins are supported: -# None +# mysql + +The plugin will monitor one or more mysql servers + +It will produce the following charts (if data is available): + +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 provide, per server, the following: + +1. a name, anything you like, but keep it short +2. username which have access to database (deafults to 'root') +3. password (defaults to none) +4. mysql socket (optional) +5. mysql host (ip or hostname) +3. mysql port (defaults to 3306) + +Here is an example for 2 servers updating data every 10 seconds + +```js +update_every = 10 + +config=[ + { + 'name' : 'local', + 'user' : 'root', + 'password' : 'blablablabla', + 'socket' : '/var/run/mysqld/mysqld.sock' + },{ + 'name' : 'remote', + 'user' : 'admin', + 'password' : 'bla', + 'host' : 'example.org', + 'port' : '9000' + }] +``` + +If no configuration is given, the plugin will attempt to connect to mysql server via unix socket at `/var/run/mysqld/mysqld.sock` without password and username `root` -Currently we don't have any python plugins, but we are counting on you to add some new ones. +---