From 315e0143f65da3485dcbcd2f6a3172a351618aec Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Thu, 28 Nov 2019 05:53:08 +0100 Subject: Adding upstream version 1.19.0. Signed-off-by: Daniel Baumann --- collectors/python.d.plugin/mysql/README.md | 23 +++++++++++++++++++---- 1 file changed, 19 insertions(+), 4 deletions(-) (limited to 'collectors/python.d.plugin/mysql/README.md') diff --git a/collectors/python.d.plugin/mysql/README.md b/collectors/python.d.plugin/mysql/README.md index 037153220..7dca8f406 100644 --- a/collectors/python.d.plugin/mysql/README.md +++ b/collectors/python.d.plugin/mysql/README.md @@ -5,8 +5,19 @@ Module monitors one or more mysql servers **Requirements:** - python library [MySQLdb](https://github.com/PyMySQL/mysqlclient-python) (faster) or [PyMySQL](https://github.com/PyMySQL/PyMySQL) (slower) +- `netdata` local user to connect to the MySQL server. -It will produce following charts (if data is available): +To create the `netdata` user, execute the following in the MySQL shell: + +```sh +create user 'netdata'@'localhost'; +grant usage on *.* to 'netdata'@'localhost'; +flush privileges; +``` +The `netdata` user will have the ability to connect to the MySQL server on `localhost` without a password. +It will only be able to gather MySQL statistics without being able to alter or affect MySQL operations in any way. + +This module will produce following charts (if data is available): 1. **Bandwidth** in kilobits/s @@ -331,7 +342,8 @@ You can provide, per server, the following: - key: the path name of the client private key file. - cert: the path name of the client public key certificate file. - - ca: the path name of the Certificate Authority (CA) certificate file. This option, if used, must specify the same certificate used by the server. + - 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. @@ -358,9 +370,12 @@ remote: port : 9000 ``` -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` +If no configuration is given, the module will attempt to connect to MySQL server via a 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/) +`userstats` graph works only if you enable the plugin in MariaDB server and set proper MySQL privileges (SUPER or +PROCESS). For more details, please check the [MariaDB User Statistics +page](https://mariadb.com/kb/en/library/user-statistics/) --- -- cgit v1.2.3