diff options
author | Oleksii Kravchenko <kamikaze.ua@gmail.com> | 2019-06-27 11:33:14 +0300 |
---|---|---|
committer | Ilya Mashchenko <ilya@netdata.cloud> | 2019-06-27 11:33:14 +0300 |
commit | 6fc971fe4d070d7c3e666ee24fb0c43d43084c85 (patch) | |
tree | 01301eeaff62b2a1c79542fa6f09cab8d915cfb7 /collectors/python.d.plugin/mysql/README.md | |
parent | dd1ddace10d790bc3a164fcda63fa245c82b84f7 (diff) |
add userstats charts for mysql (#6118)
* add userstats charts for mysql
Diffstat (limited to 'collectors/python.d.plugin/mysql/README.md')
-rw-r--r-- | collectors/python.d.plugin/mysql/README.md | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/collectors/python.d.plugin/mysql/README.md b/collectors/python.d.plugin/mysql/README.md index eba9d7a2e5..f7028ab686 100644 --- a/collectors/python.d.plugin/mysql/README.md +++ b/collectors/python.d.plugin/mysql/README.md @@ -218,6 +218,24 @@ It will produce following charts (if data is available): 45. **Flow Control** in ms * paused +46. **Users CPU time** in percentage + * users + +**Per user statistics:** + +1. **Rows Operations** in operations/s + * read + * send + * updated + * inserted + * deleted + +2. **Commands** in commands/s + * select + * update + * other + + ### configuration You can provide, per server, the following: @@ -234,7 +252,7 @@ You can provide, per server, the following: - ca: the path name of the Certificate Authority (CA) certificate file. This option, if used, must specify the same certificate used by the server. - capath: the path name of the directory that contains trusted SSL CA certificate files. - cipher: the list of permitted ciphers for SSL encryption. - + Here is an example for 3 servers: ```yaml @@ -260,6 +278,8 @@ remote: If no configuration is given, module will attempt to connect to mysql server via unix socket at `/var/run/mysqld/mysqld.sock` without password and with username `root` +`userstats` graph works only if you enable such plugin in MariaDB server and set proper mysql priviliges (SUPER or PROCESS). For more detail please check [MariaDB User Statistics page](https://mariadb.com/kb/en/library/user-statistics/) + --- [![analytics](https://www.google-analytics.com/collect?v=1&aip=1&t=pageview&_s=1&ds=github&dr=https%3A%2F%2Fgithub.com%2Fnetdata%2Fnetdata&dl=https%3A%2F%2Fmy-netdata.io%2Fgithub%2Fcollectors%2Fpython.d.plugin%2Fmysql%2FREADME&_u=MAC~&cid=5792dfd7-8dc4-476b-af31-da2fdb9f93d2&tid=UA-64295674-3)]() |