SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

Are you sending any data already? Or are you interested in monitoring mysql without any data exporting currently? are you interested in MySQL server metrics or client metrics?

yes, i‘m interested in mysql monitoring, i want to show mysql server and client metrics data on dashboard, but i have no idea to implement it

now i have own mysql metrics, but i cannot make it successfully to show mysql related monitoring.

how to config it to support mysql metrics dashboard?

Add a scrape job here for mysql here <https://github.com/SigNoz/signoz/blob/6defa0ac8b5473278c231647c86cb32f10e4c89f/deploy/docker/clickhouse-setup/otel-collector-metrics-config.yaml#L6-L22>

yes, but my main question is that how to scrape the mysql job

how to modify make it support mysql metrics dashboard

I don’t understand your question. What are you trying to ask?

can you give me a case about scrape job for mysql?

Do you want help with adding another scrape job to the list?

It will look like this
```        - job_name: mysql
          scrape_interval: 60s
          static_configs:
            - targets:
              - &lt;host_ip_where_mysql_exporter_available&gt;:9104```

ok, i have added the mysql job and restart metrics docker container, and how to verify that this configuration is effective?

could you give me a mysql dashboard json template?

just like above ,after i import my grafana json show that

Your dashboard has a lot of variables. You should make sure they are defined correctly in SigNoz as well <https://signoz.io/docs/userguide/manage-variables/>.

I have set variables correctly, but it still cannot show

Can you share the query of one of the panels where data is not showing?

The $interval is not supported. It should be replaced with something likt `5m` or something  of your choice.

do you mean the $interval should be a variable?

Either you make it a variable in which case it will be {{.interval}} or replace it with a constant that makes sense for your usecase. It is usually `2m` or `5m`

excuse me, whether the mysql metrics can support another host mysql-exporter? not localhost

Yes, as long as the host is reachable for the scraper