https://signoz.io logo
#support
Title
# support
z

zane.chen

03/05/2023, 3:04 AM
and how to support mysql metrics in "Dashboard" module?
s

Srikanth Chekuri

03/06/2023, 2:57 AM
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

zane.chen

03/06/2023, 4:10 AM
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
image.png
now i have own mysql metrics, but i cannot make it successfully to show mysql related monitoring.
image.png
how to config it to support mysql metrics dashboard?
z

zane.chen

03/06/2023, 6:19 AM
yes, but my main question is that how to scrape the mysql job
how to modify make it support mysql metrics dashboard
s

Srikanth Chekuri

03/06/2023, 6:43 AM
I don’t understand your question. What are you trying to ask?
z

zane.chen

03/06/2023, 6:45 AM
can you give me a case about scrape job for mysql?
s

Srikanth Chekuri

03/06/2023, 6:50 AM
Do you want help with adding another scrape job to the list?
z

zane.chen

03/06/2023, 7:03 AM
yes
mysql metrics job
s

Srikanth Chekuri

03/06/2023, 7:13 AM
It will look like this
Copy code
- job_name: mysql
          scrape_interval: 60s
          static_configs:
            - targets:
              - <host_ip_where_mysql_exporter_available>:9104
z

zane.chen

03/06/2023, 7:33 AM
ok, i have added the mysql job and restart metrics docker container, and how to verify that this configuration is effective?
image.png
like this?
could you give me a mysql dashboard json template?
image.png
s

Srikanth Chekuri

03/06/2023, 8:06 AM
You can try importing grafana json
z

zane.chen

03/06/2023, 8:23 AM
i tried, but it‘s not well
image.png
just like above ,after i import my grafana json show that
my grafana show like below:
image.png
s

Srikanth Chekuri

03/06/2023, 8:25 AM
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

zane.chen

03/06/2023, 8:31 AM
I have set variables correctly, but it still cannot show
image.png
image.png
s

Srikanth Chekuri

03/06/2023, 10:20 AM
Can you share the query of one of the panels where data is not showing?
z

zane.chen

03/06/2023, 11:02 AM
image.png
s

Srikanth Chekuri

03/06/2023, 11:06 AM
The $interval is not supported. It should be replaced with something likt
5m
or something of your choice.
z

zane.chen

03/06/2023, 11:09 AM
do you mean the $interval should be a variable?
s

Srikanth Chekuri

03/06/2023, 11:10 AM
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

zane.chen

03/06/2023, 11:12 AM
i got it
excuse me, whether the mysql metrics can support another host mysql-exporter? not localhost
s

Srikanth Chekuri

03/06/2023, 11:15 AM
Yes, as long as the host is reachable for the scraper
z

zane.chen

03/06/2023, 11:30 AM
but why it only show "No data"?
image.png
image.png
image.png
5 Views