From b26be28df9fd4db2106cc2a557966c9d2a7345d9 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 16 Mar 2019 08:50:20 +0100 Subject: Adding upstream version 1.13.0. Signed-off-by: Daniel Baumann --- collectors/python.d.plugin/mysql/README.md | 197 ++++++++++++++++++++++++++-- collectors/python.d.plugin/mysql/mysql.conf | 8 ++ 2 files changed, 194 insertions(+), 11 deletions(-) (limited to 'collectors/python.d.plugin/mysql') diff --git a/collectors/python.d.plugin/mysql/README.md b/collectors/python.d.plugin/mysql/README.md index 498493a3f..eba9d7a2e 100644 --- a/collectors/python.d.plugin/mysql/README.md +++ b/collectors/python.d.plugin/mysql/README.md @@ -7,7 +7,7 @@ Module monitors one or more mysql servers It will produce following charts (if data is available): -1. **Bandwidth** in kbps +1. **Bandwidth** in kilobits/s * in * out @@ -16,9 +16,15 @@ It will produce following charts (if data is available): * questions * slow queries -3. **Operations** in operations/sec - * opened tables - * flush +3. **Queries By Type** in queries/s + * select + * delete + * update + * insert + * cache hits + * replace + +4. **Handlerse** in handlers/s * commit * delete * prepare @@ -26,29 +32,192 @@ It will produce following charts (if data is available): * read key * read next * read prev - * read random - * read random next + * read rnd + * read rnd next * rollback - * save point + * savepoint + * savepoint rollback * update * write -4. **Table Locks** in locks/sec +4. **Table Locks** in locks/s * immediate * waited -5. **Select Issues** in issues/sec +5. **Table Select Join Issuess** in joins/s * full join * full range join * range * range check * scan -6. **Sort Issues** in issues/sec +6. **Table Sort Issuess** in joins/s * merge passes * range * scan +7. **Tmp Operations** in created/s + * disk tables + * files + * tables + +8. **Connections** in connections/s + * all + * aborted + +9. **Connections Active** in connections/s + * active + * limit + * max active + +10. **Binlog Cache** in threads + * disk + * all + +11. **Threads** in transactions/s + * connected + * cached + * running + +12. **Threads Creation Rate** in threads/s + * created + +13. **Threads Cache Misses** in misses + * misses + +14. **InnoDB I/O Bandwidth** in KiB/s + * read + * write + +15. **InnoDB I/O Operations** in operations/s + * reads + * writes + * fsyncs + +16. **InnoDB Pending I/O Operations** in operations/s + * reads + * writes + * fsyncs + +17. **InnoDB Log Operations** in operations/s + * waits + * write requests + * writes + +18. **InnoDB OS Log Pending Operations** in operations + * fsyncs + * writes + +19. **InnoDB OS Log Operations** in operations/s + * fsyncs + +20. **InnoDB OS Log Bandwidth** in KiB/s + * write + +21. **InnoDB Current Row Locks** in operations + * current waits + +22. **InnoDB Row Operations** in operations/s + * inserted + * read + * updated + * deleted + +23. **InnoDB Buffer Pool Pagess** in pages + * data + * dirty + * free + * misc + * total + +24. **InnoDB Buffer Pool Flush Pages Requests** in requests/s + * flush pages + +25. **InnoDB Buffer Pool Bytes** in MiB + * data + * dirty + +26. **InnoDB Buffer Pool Operations** in operations/s + * disk reads + * wait free + +27. **QCache Operations** in queries/s + * hits + * lowmem prunes + * inserts + * no caches + +28. **QCache Queries in Cache** in queries + * queries + +29. **QCache Free Memory** in MiB + * free + +30. **QCache Memory Blocks** in blocks + * free + * total + +31. **MyISAM Key Cache Blocks** in blocks + * unused + * used + * not flushed + +32. **MyISAM Key Cache Requests** in requests/s + * reads + * writes + +33. **MyISAM Key Cache Requests** in requests/s + * reads + * writes + +34. **MyISAM Key Cache Disk Operations** in operations/s + * reads + * writes + +35. **Open Files** in files + * files + +36. **Opened Files Rate** in files/s + * files + +37. **Binlog Statement Cache** in statements/s + * disk + * all + +38. **Connection Errors** in errors/s + * accept + * internal + * max + * peer addr + * select + * tcpwrap + +39. **Slave Behind Seconds** in seconds + * time + +40. **I/O / SQL Thread Running State** in bool + * sql + * io + +41. **Replicated Writesets** in writesets/s + * rx + * tx + +42. **Replicated Bytes** in KiB/s + * rx + * tx + +43. **Galera Queue** in writesets + * rx + * tx + +44. **Replication Conflicts** in transactions + * bf aborts + * cert fails + +45. **Flow Control** in ms + * paused + ### configuration You can provide, per server, the following: @@ -59,7 +228,13 @@ You can provide, per server, the following: 4. mysql socket (optional) 5. mysql host (ip or hostname) 6. mysql port (defaults to 3306) - +7. ssl connection parameters + - 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. + - 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 diff --git a/collectors/python.d.plugin/mysql/mysql.conf b/collectors/python.d.plugin/mysql/mysql.conf index ac9b505bc..31bfe9c02 100644 --- a/collectors/python.d.plugin/mysql/mysql.conf +++ b/collectors/python.d.plugin/mysql/mysql.conf @@ -73,6 +73,14 @@ # user: 'username' # the mysql username to use # pass: 'password' # the mysql password to use # +# ssl connection parameters +# +# ssl: +# key: 'key' # the path name of the client private key file. +# cert: 'cert' # the path name of the client public key certificate file. +# ca: '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: 'capath' # the path name of the directory that contains trusted SSL CA certificate files. +# cipher: [ciphers] # the list of permitted ciphers for SSL encryption. # ---------------------------------------------------------------------- # mySQL CONFIGURATION -- cgit v1.2.3