diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-08-26 08:15:20 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-08-26 08:15:20 +0000 |
commit | 87d772a7d708fec12f48cd8adc0dedff6e1025da (patch) | |
tree | 1fee344c64cc3f43074a01981e21126c8482a522 /src/go/collectors/go.d.plugin/modules/mysql/integrations/mysql.md | |
parent | Adding upstream version 1.46.3. (diff) | |
download | netdata-upstream.tar.xz netdata-upstream.zip |
Adding upstream version 1.47.0.upstream/1.47.0upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-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 |
1 files changed, 38 insertions, 7 deletions
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 +``` + |