如何获取Grafana的Mysql Exporter仪表板以获取数据？

huangapple
go评论80阅读模式
英文:

How to get Grafana's Mysql Exporter Dashboard to pull data?

问题

正在运行Ubuntu 23.04。它带有安装prometheus-mysqld-exporter apt软件包的功能。已经安装并启用了它。

在http://192.168.0.5:9104/metrics的网址响应如下：

（以下为一长串代码）

数据似乎已经存在。然而，当我安装Grafana Mysql仪表板和此页面上推荐的记录规则时：https://grafana.com/oss/prometheus/exporters/mysql-exporter/?tab=dashboards

此页面上的导出器是否与Ubuntu捆绑的导出器不同？我理解它们是相同的。

在这些仪表板中没有数据。有人遇到过这个问题吗？

如何获取Grafana的Mysql Exporter仪表板以获取数据？

谢谢

英文:

Running Ubuntu 23.04. It came with the ability to install the prometheus-mysqld-exporter apt package. Went ahead and installed it, enabled it and started it.

The url at http://192.168.0.5:9104/metrics responds with this:

  1. # HELP go_gc_duration_seconds A summary of the pause duration of garbage collection cycles.
  2. # TYPE go_gc_duration_seconds summary
  3. go_gc_duration_seconds{quantile="0"} 9.1359e-05
  4. go_gc_duration_seconds{quantile="0.25"} 0.000102738
  5. go_gc_duration_seconds{quantile="0.5"} 0.000134885
  6. go_gc_duration_seconds{quantile="0.75"} 0.000168224
  7. go_gc_duration_seconds{quantile="1"} 0.000181078
  8. go_gc_duration_seconds_sum 0.002018707
  9. go_gc_duration_seconds_count 15
  10. # HELP go_goroutines Number of goroutines that currently exist.
  11. # TYPE go_goroutines gauge
  12. go_goroutines 9
  13. # HELP go_info Information about the Go environment.
  14. # TYPE go_info gauge
  15. go_info{version="go1.19.4"} 1
  16. # HELP go_memstats_alloc_bytes Number of bytes allocated and still in use.
  17. # TYPE go_memstats_alloc_bytes gauge
  18. go_memstats_alloc_bytes 3.135808e+06
  19. # HELP go_memstats_alloc_bytes_total Total number of bytes allocated, even if freed.
  20. # TYPE go_memstats_alloc_bytes_total counter
  21. go_memstats_alloc_bytes_total 2.3260592e+07
  22. # HELP go_memstats_buck_hash_sys_bytes Number of bytes used by the profiling bucket hash table.
  23. # TYPE go_memstats_buck_hash_sys_bytes gauge
  24. go_memstats_buck_hash_sys_bytes 4617
  25. # HELP go_memstats_frees_total Total number of frees.
  26. # TYPE go_memstats_frees_total counter
  27. go_memstats_frees_total 35802
  28. # HELP go_memstats_gc_sys_bytes Number of bytes used for garbage collection system metadata.
  29. # TYPE go_memstats_gc_sys_bytes gauge
  30. go_memstats_gc_sys_bytes 8.930752e+06
  31. # HELP go_memstats_heap_alloc_bytes Number of heap bytes allocated and still in use.
  32. # TYPE go_memstats_heap_alloc_bytes gauge
  33. go_memstats_heap_alloc_bytes 3.135808e+06
  34. # HELP go_memstats_heap_idle_bytes Number of heap bytes waiting to be used.
  35. # TYPE go_memstats_heap_idle_bytes gauge
  36. go_memstats_heap_idle_bytes 3.260416e+06
  37. # HELP go_memstats_heap_inuse_bytes Number of heap bytes that are in use.
  38. # TYPE go_memstats_heap_inuse_bytes gauge
  39. go_memstats_heap_inuse_bytes 4.603904e+06
  40. # HELP go_memstats_heap_objects Number of allocated objects.
  41. # TYPE go_memstats_heap_objects gauge
  42. go_memstats_heap_objects 3257
  43. # HELP go_memstats_heap_released_bytes Number of heap bytes released to OS.
  44. # TYPE go_memstats_heap_released_bytes gauge
  45. go_memstats_heap_released_bytes 2.8672e+06
  46. # HELP go_memstats_heap_sys_bytes Number of heap bytes obtained from system.
  47. # TYPE go_memstats_heap_sys_bytes gauge
  48. go_memstats_heap_sys_bytes 7.86432e+06
  49. # HELP go_memstats_last_gc_time_seconds Number of seconds since 1970 of last garbage collection.
  50. # TYPE go_memstats_last_gc_time_seconds gauge
  51. go_memstats_last_gc_time_seconds 1.6834325351535332e+09
  52. # HELP go_memstats_lookups_total Total number of pointer lookups.
  53. # TYPE go_memstats_lookups_total counter
  54. go_memstats_lookups_total 0
  55. # HELP go_memstats_mallocs_total Total number of mallocs.
  56. # TYPE go_memstats_mallocs_total counter
  57. go_memstats_mallocs_total 39059
  58. # HELP go_memstats_mcache_inuse_bytes Number of bytes in use by mcache structures.
  59. # TYPE go_memstats_mcache_inuse_bytes gauge
  60. go_memstats_mcache_inuse_bytes 4800
  61. # HELP go_memstats_mcache_sys_bytes Number of bytes used for mcache structures obtained from system.
  62. # TYPE go_memstats_mcache_sys_bytes gauge
  63. go_memstats_mcache_sys_bytes 15600
  64. # HELP go_memstats_mspan_inuse_bytes Number of bytes in use by mspan structures.
  65. # TYPE go_memstats_mspan_inuse_bytes gauge
  66. go_memstats_mspan_inuse_bytes 76752
  67. # HELP go_memstats_mspan_sys_bytes Number of bytes used for mspan structures obtained from system.
  68. # TYPE go_memstats_mspan_sys_bytes gauge
  69. go_memstats_mspan_sys_bytes 81360
  70. # HELP go_memstats_next_gc_bytes Number of heap bytes when next garbage collection will take place.
  71. # TYPE go_memstats_next_gc_bytes gauge
  72. go_memstats_next_gc_bytes 4.903744e+06
  73. # HELP go_memstats_other_sys_bytes Number of bytes used for other system allocations.
  74. # TYPE go_memstats_other_sys_bytes gauge
  75. go_memstats_other_sys_bytes 911751
  76. # HELP go_memstats_stack_inuse_bytes Number of bytes in use by the stack allocator.
  77. # TYPE go_memstats_stack_inuse_bytes gauge
  78. go_memstats_stack_inuse_bytes 524288
  79. # HELP go_memstats_stack_sys_bytes Number of bytes obtained from system for stack allocator.
  80. # TYPE go_memstats_stack_sys_bytes gauge
  81. go_memstats_stack_sys_bytes 524288
  82. # HELP go_memstats_sys_bytes Number of bytes obtained from system.
  83. # TYPE go_memstats_sys_bytes gauge
  84. go_memstats_sys_bytes 1.8332688e+07
  85. # HELP go_threads Number of OS threads created.
  86. # TYPE go_threads gauge
  87. go_threads 8
  88. # HELP mysql_exporter_last_scrape_error Whether the last scrape of metrics from MySQL resulted in an error (1 for error, 0 for success).
  89. # TYPE mysql_exporter_last_scrape_error gauge
  90. mysql_exporter_last_scrape_error 1
  91. # HELP mysql_exporter_scrapes_total Total number of times MySQL was scraped for metrics.
  92. # TYPE mysql_exporter_scrapes_total counter
  93. mysql_exporter_scrapes_total 30
  94. # HELP mysql_up Whether the MySQL server is up.
  95. # TYPE mysql_up gauge
  96. mysql_up 0
  97. # HELP mysqld_exporter_build_info A metric with a constant '1' value labeled by version, revision, branch, goversion from which mysqld_exporter was built, and the goos and goarch for the build.
  98. # TYPE mysqld_exporter_build_info gauge
  99. mysqld_exporter_build_info{branch="debian/sid",goarch="amd64",goos="linux",goversion="go1.19.4",revision="0.14.0-3",version="0.14.0"} 1
  100. # HELP process_cpu_seconds_total Total user and system CPU time spent in seconds.
  101. # TYPE process_cpu_seconds_total counter
  102. process_cpu_seconds_total 0.45
  103. # HELP process_max_fds Maximum number of open file descriptors.
  104. # TYPE process_max_fds gauge
  105. process_max_fds 524288
  106. # HELP process_open_fds Number of open file descriptors.
  107. # TYPE process_open_fds gauge
  108. process_open_fds 10
  109. # HELP process_resident_memory_bytes Resident memory size in bytes.
  110. # TYPE process_resident_memory_bytes gauge
  111. process_resident_memory_bytes 1.773568e+07
  112. # HELP process_start_time_seconds Start time of the process since unix epoch in seconds.
  113. # TYPE process_start_time_seconds gauge
  114. process_start_time_seconds 1.6834321218e+09
  115. # HELP process_virtual_memory_bytes Virtual memory size in bytes.
  116. # TYPE process_virtual_memory_bytes gauge
  117. process_virtual_memory_bytes 1.194979328e+09
  118. # HELP process_virtual_memory_max_bytes Maximum amount of virtual memory available in bytes.
  119. # TYPE process_virtual_memory_max_bytes gauge
  120. process_virtual_memory_max_bytes 1.8446744073709552e+19
  121. # HELP promhttp_metric_handler_requests_in_flight Current number of scrapes being served.
  122. # TYPE promhttp_metric_handler_requests_in_flight gauge
  123. promhttp_metric_handler_requests_in_flight 1
  124. # HELP promhttp_metric_handler_requests_total Total number of scrapes by HTTP status code.
  125. # TYPE promhttp_metric_handler_requests_total counter
  126. promhttp_metric_handler_requests_total{code="200"} 29
  127. promhttp_metric_handler_requests_total{code="500"} 0
  128. promhttp_metric_handler_requests_total{code="503"} 0

The data seems to be there. However when I installed the Grafana Mysql Dashboard and it's recording rules recommended on this page: https://grafana.com/oss/prometheus/exporters/mysql-exporter/?tab=dashboards

Is the exporter on this page different than the one packaged with Ubuntu? My understanding is that they are the same.

There is no data present in those dashboards. Has anyone encountered this issue?

如何获取Grafana的Mysql Exporter仪表板以获取数据？

Thanks

答案1

得分: 0

我在这个帖子https://groups.google.com/g/prometheus-users/c/BGPGd9sV0fM 找到了答案。

mysql_exporter_last_scrape_error 1 语句和上述帖子让我重新检查了我的mysql凭据。原来是一个拼写错误。这解决了我的问题。

英文:

I found my answer on this thread https://groups.google.com/g/prometheus-users/c/BGPGd9sV0fM

The mysql_exporter_last_scrape_error 1 statement and the thread above made me recheck my mysql credentials. There was a typo. That fixed my issue.

huangapple
  • 本文由 发表于 2023年5月7日 12:20:12
  • 转载请务必保留本文链接：https://go.coder-hub.com/76192178.html
  • grafana-dashboard
  • prometheus
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定