#support
Title
# support
z
zane.chen
03/05/2023, 3:04 AMand how to support mysql metrics in "Dashboard" module?
s
Srikanth Chekuri
03/06/2023, 2:57 AMAre 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 AMyes, 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?
s
Srikanth Chekuri
03/06/2023, 6:12 AMz
zane.chen
03/06/2023, 6:19 AMyes, 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 AMI don’t understand your question. What are you trying to ask?
z
zane.chen
03/06/2023, 6:45 AMcan you give me a case about scrape job for mysql?
s
Srikanth Chekuri
03/06/2023, 6:50 AMDo you want help with adding another scrape job to the list?
z
zane.chen
03/06/2023, 7:03 AMyes
mysql metrics job
s
Srikanth Chekuri
03/06/2023, 7:13 AMIt will look like this
Copy code
- job_name: mysql
scrape_interval: 60s
static_configs:
- targets:
- <host_ip_where_mysql_exporter_available>:9104z
zane.chen
03/06/2023, 7:33 AMok, 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 AMYou can try importing grafana json
z
zane.chen
03/06/2023, 8:23 AMi 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 AMYour 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 AMI have set variables correctly, but it still cannot show
image.png
image.png
s
Srikanth Chekuri
03/06/2023, 10:20 AMCan you share the query of one of the panels where data is not showing?
z
zane.chen
03/06/2023, 11:02 AMimage.png
s
Srikanth Chekuri
03/06/2023, 11:06 AMThe $interval is not supported. It should be replaced with something likt
5mz
zane.chen
03/06/2023, 11:09 AMdo you mean the $interval should be a variable?
s
Srikanth Chekuri
03/06/2023, 11:10 AMEither 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
2m5mz
zane.chen
03/06/2023, 11:12 AMi got it
excuse me, whether the mysql metrics can support another host mysql-exporter? not localhost
s
Srikanth Chekuri
03/06/2023, 11:15 AMYes, as long as the host is reachable for the scraper
z
zane.chen
03/06/2023, 11:30 AMbut why it only show "No data"?
image.png
image.png
image.png
5 Views