diff options
Diffstat (limited to '')
-rw-r--r-- | src/go/plugin/go.d/modules/mysql/integrations/mariadb.md (renamed from src/go/collectors/go.d.plugin/modules/mysql/integrations/mariadb.md) | 45 | ||||
-rw-r--r-- | src/go/plugin/go.d/modules/mysql/integrations/mysql.md (renamed from src/go/collectors/go.d.plugin/modules/mysql/integrations/mysql.md) | 45 | ||||
-rw-r--r-- | src/go/plugin/go.d/modules/mysql/integrations/percona_mysql.md (renamed from src/go/collectors/go.d.plugin/modules/mysql/integrations/percona_mysql.md) | 45 |
3 files changed, 114 insertions, 21 deletions
diff --git a/src/go/collectors/go.d.plugin/modules/mysql/integrations/mariadb.md b/src/go/plugin/go.d/modules/mysql/integrations/mariadb.md index 8bd6b151c..b10e84b2a 100644 --- a/src/go/collectors/go.d.plugin/modules/mysql/integrations/mariadb.md +++ b/src/go/plugin/go.d/modules/mysql/integrations/mariadb.md @@ -1,6 +1,6 @@ <!--startmeta -custom_edit_url: "https://github.com/netdata/netdata/edit/master/src/go/collectors/go.d.plugin/modules/mysql/integrations/mariadb.md" -meta_yaml: "https://github.com/netdata/netdata/edit/master/src/go/collectors/go.d.plugin/modules/mysql/metadata.yaml" +custom_edit_url: "https://github.com/netdata/netdata/edit/master/src/go/plugin/go.d/modules/mysql/integrations/mariadb.md" +meta_yaml: "https://github.com/netdata/netdata/edit/master/src/go/plugin/go.d/modules/mysql/metadata.yaml" sidebar_label: "MariaDB" learn_status: "Published" learn_rel_path: "Collecting Metrics/Databases" @@ -45,12 +45,8 @@ This collector supports collecting metrics from multiple instances of this integ #### Auto-Detection -By default, it detects instances running on localhost by trying to connect as root and netdata using known MySQL TCP and UNIX sockets: +By default, it detects instances running on localhost by trying to connect as root and netdata using known MySQL TCP sockets: -- /var/run/mysqld/mysqld.sock -- /var/run/mysqld/mysql.sock -- /var/lib/mysql/mysql.sock -- /tmp/mysql.sock - 127.0.0.1:3306 - "[::1]:3306" @@ -345,6 +341,8 @@ jobs: ### Debug Mode +**Important**: Debug mode is not supported for data collection jobs created via the UI using the Dyncfg feature. + To troubleshoot issues with the `mysql` collector, run the `go.d.plugin` with the debug option enabled. The output should give you clues as to why the collector isn't working. @@ -367,4 +365,37 @@ should give you clues as to why the collector isn't working. ./go.d.plugin -d -m mysql ``` +### Getting Logs + +If you're encountering problems with the `mysql` collector, follow these steps to retrieve logs and identify potential issues: + +- **Run the command** specific to your system (systemd, non-systemd, or Docker container). +- **Examine the output** for any warnings or error messages that might indicate issues. These messages should provide clues about the root cause of the problem. + +#### System with systemd + +Use the following command to view logs generated since the last Netdata service restart: + +```bash +journalctl _SYSTEMD_INVOCATION_ID="$(systemctl show --value --property=InvocationID netdata)" --namespace=netdata --grep mysql +``` + +#### System without systemd + +Locate the collector log file, typically at `/var/log/netdata/collector.log`, and use `grep` to filter for collector's name: + +```bash +grep mysql /var/log/netdata/collector.log +``` + +**Note**: This method shows logs from all restarts. Focus on the **latest entries** for troubleshooting current issues. + +#### Docker Container + +If your Netdata runs in a Docker container named "netdata" (replace if different), use this command: + +```bash +docker logs netdata 2>&1 | grep mysql +``` + diff --git a/src/go/collectors/go.d.plugin/modules/mysql/integrations/mysql.md b/src/go/plugin/go.d/modules/mysql/integrations/mysql.md index 0acf6f881..f4f8a423a 100644 --- a/src/go/collectors/go.d.plugin/modules/mysql/integrations/mysql.md +++ b/src/go/plugin/go.d/modules/mysql/integrations/mysql.md @@ -1,6 +1,6 @@ <!--startmeta -custom_edit_url: "https://github.com/netdata/netdata/edit/master/src/go/collectors/go.d.plugin/modules/mysql/integrations/mysql.md" -meta_yaml: "https://github.com/netdata/netdata/edit/master/src/go/collectors/go.d.plugin/modules/mysql/metadata.yaml" +custom_edit_url: "https://github.com/netdata/netdata/edit/master/src/go/plugin/go.d/modules/mysql/integrations/mysql.md" +meta_yaml: "https://github.com/netdata/netdata/edit/master/src/go/plugin/go.d/modules/mysql/metadata.yaml" sidebar_label: "MySQL" learn_status: "Published" learn_rel_path: "Collecting Metrics/Databases" @@ -45,12 +45,8 @@ This collector supports collecting metrics from multiple instances of this integ #### Auto-Detection -By default, it detects instances running on localhost by trying to connect as root and netdata using known MySQL TCP and UNIX sockets: +By default, it detects instances running on localhost by trying to connect as root and netdata using known MySQL TCP sockets: -- /var/run/mysqld/mysqld.sock -- /var/run/mysqld/mysql.sock -- /var/lib/mysql/mysql.sock -- /tmp/mysql.sock - 127.0.0.1:3306 - "[::1]:3306" @@ -345,6 +341,8 @@ jobs: ### Debug Mode +**Important**: Debug mode is not supported for data collection jobs created via the UI using the Dyncfg feature. + To troubleshoot issues with the `mysql` collector, run the `go.d.plugin` with the debug option enabled. The output should give you clues as to why the collector isn't working. @@ -367,4 +365,37 @@ should give you clues as to why the collector isn't working. ./go.d.plugin -d -m mysql ``` +### Getting Logs + +If you're encountering problems with the `mysql` collector, follow these steps to retrieve logs and identify potential issues: + +- **Run the command** specific to your system (systemd, non-systemd, or Docker container). +- **Examine the output** for any warnings or error messages that might indicate issues. These messages should provide clues about the root cause of the problem. + +#### System with systemd + +Use the following command to view logs generated since the last Netdata service restart: + +```bash +journalctl _SYSTEMD_INVOCATION_ID="$(systemctl show --value --property=InvocationID netdata)" --namespace=netdata --grep mysql +``` + +#### System without systemd + +Locate the collector log file, typically at `/var/log/netdata/collector.log`, and use `grep` to filter for collector's name: + +```bash +grep mysql /var/log/netdata/collector.log +``` + +**Note**: This method shows logs from all restarts. Focus on the **latest entries** for troubleshooting current issues. + +#### Docker Container + +If your Netdata runs in a Docker container named "netdata" (replace if different), use this command: + +```bash +docker logs netdata 2>&1 | grep mysql +``` + diff --git a/src/go/collectors/go.d.plugin/modules/mysql/integrations/percona_mysql.md b/src/go/plugin/go.d/modules/mysql/integrations/percona_mysql.md index 1ea2ab21f..2c967e229 100644 --- a/src/go/collectors/go.d.plugin/modules/mysql/integrations/percona_mysql.md +++ b/src/go/plugin/go.d/modules/mysql/integrations/percona_mysql.md @@ -1,6 +1,6 @@ <!--startmeta -custom_edit_url: "https://github.com/netdata/netdata/edit/master/src/go/collectors/go.d.plugin/modules/mysql/integrations/percona_mysql.md" -meta_yaml: "https://github.com/netdata/netdata/edit/master/src/go/collectors/go.d.plugin/modules/mysql/metadata.yaml" +custom_edit_url: "https://github.com/netdata/netdata/edit/master/src/go/plugin/go.d/modules/mysql/integrations/percona_mysql.md" +meta_yaml: "https://github.com/netdata/netdata/edit/master/src/go/plugin/go.d/modules/mysql/metadata.yaml" sidebar_label: "Percona MySQL" learn_status: "Published" learn_rel_path: "Collecting Metrics/Databases" @@ -45,12 +45,8 @@ This collector supports collecting metrics from multiple instances of this integ #### Auto-Detection -By default, it detects instances running on localhost by trying to connect as root and netdata using known MySQL TCP and UNIX sockets: +By default, it detects instances running on localhost by trying to connect as root and netdata using known MySQL TCP sockets: -- /var/run/mysqld/mysqld.sock -- /var/run/mysqld/mysql.sock -- /var/lib/mysql/mysql.sock -- /tmp/mysql.sock - 127.0.0.1:3306 - "[::1]:3306" @@ -345,6 +341,8 @@ jobs: ### Debug Mode +**Important**: Debug mode is not supported for data collection jobs created via the UI using the Dyncfg feature. + To troubleshoot issues with the `mysql` collector, run the `go.d.plugin` with the debug option enabled. The output should give you clues as to why the collector isn't working. @@ -367,4 +365,37 @@ should give you clues as to why the collector isn't working. ./go.d.plugin -d -m mysql ``` +### Getting Logs + +If you're encountering problems with the `mysql` collector, follow these steps to retrieve logs and identify potential issues: + +- **Run the command** specific to your system (systemd, non-systemd, or Docker container). +- **Examine the output** for any warnings or error messages that might indicate issues. These messages should provide clues about the root cause of the problem. + +#### System with systemd + +Use the following command to view logs generated since the last Netdata service restart: + +```bash +journalctl _SYSTEMD_INVOCATION_ID="$(systemctl show --value --property=InvocationID netdata)" --namespace=netdata --grep mysql +``` + +#### System without systemd + +Locate the collector log file, typically at `/var/log/netdata/collector.log`, and use `grep` to filter for collector's name: + +```bash +grep mysql /var/log/netdata/collector.log +``` + +**Note**: This method shows logs from all restarts. Focus on the **latest entries** for troubleshooting current issues. + +#### Docker Container + +If your Netdata runs in a Docker container named "netdata" (replace if different), use this command: + +```bash +docker logs netdata 2>&1 | grep mysql +``` + |