Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1920

Standard Exporter Metrics - Add to MySQLD Exporter

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.0
    • Component/s: MySQLd_Exporter
    • Labels:
      None

      Description

      Hi,

      It looks like for some reason standard metrics which Exporters reports were
      removed from our MySQLD Exporter, perhaps by mistake

      These metrics should be added back (high resolution as they are cheap) so
      exporter uptime and resource usage can be easily monitored

      Example of standard metrics all other exporters seems to have

      1. HELP go_gc_duration_seconds A summary of the GC invocation durations.
      2. TYPE go_gc_duration_seconds summary
        go_gc_duration_seconds {quantile="0"}

        8.5217e-05
        go_gc_duration_seconds

        {quantile="0.25"}

        0.000109447
        go_gc_duration_seconds

        {quantile="0.5"}

        0.000123282
        go_gc_duration_seconds

        {quantile="0.75"}

        0.000141258
        go_gc_duration_seconds

        {quantile="1"}

        0.001591264
        go_gc_duration_seconds_sum 757.190061783
        go_gc_duration_seconds_count 5.014198e+06

      3. HELP go_goroutines Number of goroutines that currently exist.
      4. TYPE go_goroutines gauge
        go_goroutines 9
      5. HELP go_memstats_alloc_bytes Number of bytes allocated and still in use.
      6. TYPE go_memstats_alloc_bytes gauge
        go_memstats_alloc_bytes 2.278488e+06
      7. HELP go_memstats_alloc_bytes_total Total number of bytes allocated, even
        if freed.
      8. TYPE go_memstats_alloc_bytes_total counter
        go_memstats_alloc_bytes_total 1.5163463717344e+13
      9. HELP go_memstats_buck_hash_sys_bytes Number of bytes used by the
        profiling bucket hash table.
      10. TYPE go_memstats_buck_hash_sys_bytes gauge
        go_memstats_buck_hash_sys_bytes 1.808833e+06
      11. HELP go_memstats_frees_total Total number of frees.
      12. TYPE go_memstats_frees_total counter
        go_memstats_frees_total 8.5277857938e+10
      13. HELP go_memstats_gc_cpu_fraction The fraction of this program's available
        CPU time used by the GC since the program started.
      14. TYPE go_memstats_gc_cpu_fraction gauge
        go_memstats_gc_cpu_fraction 0.0009537916684127164
      15. HELP go_memstats_gc_sys_bytes Number of bytes used for garbage collection
        system metadata.
      16. TYPE go_memstats_gc_sys_bytes gauge
        go_memstats_gc_sys_bytes 544768
      17. HELP go_memstats_heap_alloc_bytes Number of heap bytes allocated and
        still in use.
      18. TYPE go_memstats_heap_alloc_bytes gauge
        go_memstats_heap_alloc_bytes 2.278488e+06
      19. HELP go_memstats_heap_idle_bytes Number of heap bytes waiting to be used.
      20. TYPE go_memstats_heap_idle_bytes gauge
        go_memstats_heap_idle_bytes 5.849088e+06
      21. HELP go_memstats_heap_inuse_bytes Number of heap bytes that are in use.
      22. TYPE go_memstats_heap_inuse_bytes gauge
        go_memstats_heap_inuse_bytes 3.325952e+06
      23. HELP go_memstats_heap_objects Number of allocated objects.
      24. TYPE go_memstats_heap_objects gauge
        go_memstats_heap_objects 14524
      25. HELP go_memstats_heap_released_bytes Number of heap bytes released to OS.
      26. TYPE go_memstats_heap_released_bytes gauge
        go_memstats_heap_released_bytes 0
      27. HELP go_memstats_heap_sys_bytes Number of heap bytes obtained from system.
      28. TYPE go_memstats_heap_sys_bytes gauge
        go_memstats_heap_sys_bytes 9.17504e+06
      29. HELP go_memstats_last_gc_time_seconds Number of seconds since 1970 of
        last garbage collection.
      30. TYPE go_memstats_last_gc_time_seconds gauge
        go_memstats_last_gc_time_seconds 1.5152852475721684e+09
      31. HELP go_memstats_lookups_total Total number of pointer lookups.
      32. TYPE go_memstats_lookups_total counter
        go_memstats_lookups_total 2.8302867e+07
      33. HELP go_memstats_mallocs_total Total number of mallocs.
      34. TYPE go_memstats_mallocs_total counter
        go_memstats_mallocs_total 8.5277872462e+10
      35. HELP go_memstats_mcache_inuse_bytes Number of bytes in use by mcache
        structures.
      36. TYPE go_memstats_mcache_inuse_bytes gauge
        go_memstats_mcache_inuse_bytes 13888
      37. HELP go_memstats_mcache_sys_bytes Number of bytes used for mcache
        structures obtained from system.
      38. TYPE go_memstats_mcache_sys_bytes gauge
        go_memstats_mcache_sys_bytes 16384
      39. HELP go_memstats_mspan_inuse_bytes Number of bytes in use by mspan
        structures.
      40. TYPE go_memstats_mspan_inuse_bytes gauge
        go_memstats_mspan_inuse_bytes 63992
      41. HELP go_memstats_mspan_sys_bytes Number of bytes used for mspan
        structures obtained from system.
      42. TYPE go_memstats_mspan_sys_bytes gauge
        go_memstats_mspan_sys_bytes 163840
      43. HELP go_memstats_next_gc_bytes Number of heap bytes when next garbage
        collection will take place.
      44. TYPE go_memstats_next_gc_bytes gauge
        go_memstats_next_gc_bytes 4.194304e+06
      45. HELP go_memstats_other_sys_bytes Number of bytes used for other system
        allocations.
      46. TYPE go_memstats_other_sys_bytes gauge
        go_memstats_other_sys_bytes 2.129719e+06
      47. HELP go_memstats_stack_inuse_bytes Number of bytes in use by the stack
        allocator.
      48. TYPE go_memstats_stack_inuse_bytes gauge
        go_memstats_stack_inuse_bytes 1.31072e+06
      49. HELP go_memstats_stack_sys_bytes Number of bytes obtained from system for
        stack allocator.
      50. TYPE go_memstats_stack_sys_bytes gauge
        go_memstats_stack_sys_bytes 1.31072e+06
      51. HELP go_memstats_sys_bytes Number of bytes obtained from system.
      52. TYPE go_memstats_sys_bytes gauge
        go_memstats_sys_bytes 1.5149304e+07
      53. HELP go_threads Number of OS threads created
      54. TYPE go_threads gauge
        go_threads 19
      55. HELP process_cpu_seconds_total Total user and system CPU time spent in
        seconds.
      56. TYPE process_cpu_seconds_total counter
        process_cpu_seconds_total 148305.11
      57. HELP process_max_fds Maximum number of open file descriptors.
      58. TYPE process_max_fds gauge
        process_max_fds 1024
      59. HELP process_open_fds Number of open file descriptors.
      60. TYPE process_open_fds gauge
        process_open_fds 9
      61. HELP process_resident_memory_bytes Resident memory size in bytes.
      62. TYPE process_resident_memory_bytes gauge
        process_resident_memory_bytes 1.6441344e+07
      63. HELP process_start_time_seconds Start time of the process since unix
        epoch in seconds.
      64. TYPE process_start_time_seconds gauge
        process_start_time_seconds 1.51362494858e+09
      65. HELP process_virtual_memory_bytes Virtual memory size in bytes.
      66. TYPE process_virtual_memory_bytes gauge
        process_virtual_memory_bytes 2.3031808e+07


      Peter Zaitsev, CEO, Percona
      Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  pz Peter Zaitsev
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: