https://signoz.io
Join Slack
This message was deleted.
# support
s
This message was deleted.
s
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?
z
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?
s
z
yes, but my main question is that how to scrape the mysql job
how to modify make it support mysql metrics dashboard
s
I don’t understand your question. What are you trying to ask?
z
can you give me a case about scrape job for mysql?
s
Do you want help with adding another scrape job to the list?
z
yes
mysql metrics job
s
It will look like this
Copy code
- job_name: mysql
          scrape_interval: 60s
          static_configs:
            - targets:
              - <host_ip_where_mysql_exporter_available>:9104
z
ok, i have added the mysql job and restart metrics docker container, and how to verify that this configuration is effective?
like this?
could you give me a mysql dashboard json template?
s
You can try importing grafana json
z
i tried, but it‘s not well
just like above ,after i import my grafana json show that
my grafana show like below:
s
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/.
z
I have set variables correctly, but it still cannot show
s
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.
z
do you mean the $interval should be a variable?
s
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
z
i got it
excuse me, whether the mysql metrics can support another host mysql-exporter? not localhost
s
Yes, as long as the host is reachable for the scraper
z
but why it only show "No data"?
9 Views
Open in Slack
PreviousNext
Powered by

SigNoz Community

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

Powered by