Hi, here is what I get
# HELP go_gc_duration_seconds A summary of the pause duration of garbage
collection cycles.
# TYPE go_gc_duration_seconds summary
go_gc_duration_seconds{quantile="0"} 3.9799e-05
go_gc_duration_seconds{quantile="0.25"} 0.000104399
go_gc_duration_seconds{quantile="0.5"} 0.000155999
go_gc_duration_seconds{quantile="0.75"} 0.000194999
go_gc_duration_seconds{quantile="1"} 0.39236267
go_gc_duration_seconds_sum 0.435731728
go_gc_duration_seconds_count 213
# HELP go_goroutines Number of goroutines that currently exist.
# TYPE go_goroutines gauge
go_goroutines 9
# HELP go_info Information about the Go environment.
# TYPE go_info gauge
go_info{version="go1.16.4"} 1
# HELP go_memstats_alloc_bytes Number of bytes allocated and still in use.
# TYPE go_memstats_alloc_bytes gauge
go_memstats_alloc_bytes 2.477192e+06
# HELP go_memstats_alloc_bytes_total Total number of bytes allocated, even
if freed.
# TYPE go_memstats_alloc_bytes_total counter
go_memstats_alloc_bytes_total 3.92554464e+08
# HELP go_memstats_buck_hash_sys_bytes Number of bytes used by the
profiling bucket hash table.
# TYPE go_memstats_buck_hash_sys_bytes gauge
go_memstats_buck_hash_sys_bytes 1.478224e+06
# HELP go_memstats_frees_total Total number of frees.
# TYPE go_memstats_frees_total counter
go_memstats_frees_total 1.887392e+06
# HELP go_memstats_gc_cpu_fraction The fraction of this program's available
CPU time used by the GC since the program started.
# TYPE go_memstats_gc_cpu_fraction gauge
go_memstats_gc_cpu_fraction 2.0797628174909467e-05
# HELP go_memstats_gc_sys_bytes Number of bytes used for garbage collection
system metadata.
# TYPE go_memstats_gc_sys_bytes gauge
go_memstats_gc_sys_bytes 5.082024e+06
# HELP go_memstats_heap_alloc_bytes Number of heap bytes allocated and
still in use.
# TYPE go_memstats_heap_alloc_bytes gauge
go_memstats_heap_alloc_bytes 2.477192e+06
# HELP go_memstats_heap_idle_bytes Number of heap bytes waiting to be used.
# TYPE go_memstats_heap_idle_bytes gauge
go_memstats_heap_idle_bytes 6.28736e+07
# HELP go_memstats_heap_inuse_bytes Number of heap bytes that are in use.
# TYPE go_memstats_heap_inuse_bytes gauge
go_memstats_heap_inuse_bytes 3.743744e+06
# HELP go_memstats_heap_objects Number of allocated objects.
# TYPE go_memstats_heap_objects gauge
go_memstats_heap_objects 4029
# HELP go_memstats_heap_released_bytes Number of heap bytes released to OS.
# TYPE go_memstats_heap_released_bytes gauge
go_memstats_heap_released_bytes 6.2078976e+07
# HELP go_memstats_heap_sys_bytes Number of heap bytes obtained from system.
# TYPE go_memstats_heap_sys_bytes gauge
go_memstats_heap_sys_bytes 6.6617344e+07
# HELP go_memstats_last_gc_time_seconds Number of seconds since 1970 of
last garbage collection.
# TYPE go_memstats_last_gc_time_seconds gauge
go_memstats_last_gc_time_seconds 1.6427552726178036e+09
# HELP go_memstats_lookups_total Total number of pointer lookups.
# TYPE go_memstats_lookups_total counter
go_memstats_lookups_total 0
# HELP go_memstats_mallocs_total Total number of mallocs.
# TYPE go_memstats_mallocs_total counter
go_memstats_mallocs_total 1.891421e+06
# HELP go_memstats_mcache_inuse_bytes Number of bytes in use by mcache
structures.
# TYPE go_memstats_mcache_inuse_bytes gauge
go_memstats_mcache_inuse_bytes 2400
# HELP go_memstats_mcache_sys_bytes Number of bytes used for mcache
structures obtained from system.
# TYPE go_memstats_mcache_sys_bytes gauge
go_memstats_mcache_sys_bytes 16384
# HELP go_memstats_mspan_inuse_bytes Number of bytes in use by mspan
structures.
# TYPE go_memstats_mspan_inuse_bytes gauge
go_memstats_mspan_inuse_bytes 52224
# HELP go_memstats_mspan_sys_bytes Number of bytes used for mspan
structures obtained from system.
# TYPE go_memstats_mspan_sys_bytes gauge
go_memstats_mspan_sys_bytes 65536
# HELP go_memstats_next_gc_bytes Number of heap bytes when next garbage
collection will take place.
# TYPE go_memstats_next_gc_bytes gauge
go_memstats_next_gc_bytes 4.574928e+06
# HELP go_memstats_other_sys_bytes Number of bytes used for other system
allocations.
# TYPE go_memstats_other_sys_bytes gauge
go_memstats_other_sys_bytes 518672
# HELP go_memstats_stack_inuse_bytes Number of bytes in use by the stack
allocator.
# TYPE go_memstats_stack_inuse_bytes gauge
go_memstats_stack_inuse_bytes 491520
# HELP go_memstats_stack_sys_bytes Number of bytes obtained from system for
stack allocator.
# TYPE go_memstats_stack_sys_bytes gauge
go_memstats_stack_sys_bytes 491520
# HELP go_memstats_sys_bytes Number of bytes obtained from system.
# TYPE go_memstats_sys_bytes gauge
go_memstats_sys_bytes 7.4269704e+07
# HELP go_threads Number of OS threads created.
# TYPE go_threads gauge
go_threads 6
# HELP mysql_exporter_last_scrape_error Whether the last scrape of metrics
from MySQL resulted in an error (1 for error, 0 for success).
# TYPE mysql_exporter_last_scrape_error gauge
mysql_exporter_last_scrape_error 1
# HELP mysql_exporter_scrapes_total Total number of times MySQL was scraped
for metrics.
# TYPE mysql_exporter_scrapes_total counter
mysql_exporter_scrapes_total 1766
# HELP mysql_up Whether the MySQL server is up.
# TYPE mysql_up gauge
mysql_up 0
# HELP mysqld_exporter_build_info A metric with a constant '1' value
labeled by version, revision, branch, and goversion from which
mysqld_exporter was built.
# TYPE mysqld_exporter_build_info gauge
mysqld_exporter_build_info{branch="HEAD",goversion="go1.16.4",revision="ad2847c7fa67b9debafccd5a08bacb12fc9031f1",version="0.13.0"}
1
# HELP process_cpu_seconds_total Total user and system CPU time spent in
seconds.
# TYPE process_cpu_seconds_total counter
process_cpu_seconds_total 7.76
# HELP process_max_fds Maximum number of open file descriptors.
# TYPE process_max_fds gauge
process_max_fds 1024
# HELP process_open_fds Number of open file descriptors.
# TYPE process_open_fds gauge
process_open_fds 10
# HELP process_resident_memory_bytes Resident memory size in bytes.
# TYPE process_resident_memory_bytes gauge
process_resident_memory_bytes 1.4118912e+07
# HELP process_start_time_seconds Start time of the process since unix
epoch in seconds.
# TYPE process_start_time_seconds gauge
process_start_time_seconds 1.64272887993e+09
# HELP process_virtual_memory_bytes Virtual memory size in bytes.
# TYPE process_virtual_memory_bytes gauge
process_virtual_memory_bytes 7.3238528e+08
# HELP process_virtual_memory_max_bytes Maximum amount of virtual memory
available in bytes.
# TYPE process_virtual_memory_max_bytes gauge
process_virtual_memory_max_bytes 1.8446744073709552e+19
# HELP promhttp_metric_handler_requests_in_flight Current number of scrapes
being served.
# TYPE promhttp_metric_handler_requests_in_flight gauge
promhttp_metric_handler_requests_in_flight 1
# HELP promhttp_metric_handler_requests_total Total number of scrapes by
HTTP status code.
# TYPE promhttp_metric_handler_requests_total counter
promhttp_metric_handler_requests_total{code="200"} 1765
promhttp_metric_handler_requests_total{code="500"} 0
promhttp_metric_handler_requests_total{code="503"} 0
On Friday, January 21, 2022 at 9:04:36 AM UTC+1 Brian Candler wrote:
> What do you get from:
>
> curl -sS 192.168.1.48:9104/metrics
>
> ?
>
> On Thursday, 20 January 2022 at 23:44:06 UTC [email protected] wrote:
>
>> I have just successful setup and run mysql exporter, when I switch to
>> Prometheus
>> UI, try to search for sql metrics, I see only 4 items
>>
>> mysql_exporter_last_scrape_error
>> mysql_exporter_scrapes_total
>> mysql_up
>> mysqld_exporter_build_info
>>
>> in spite of the fact that I created a service file on Fedora 35 with all
>> following flags
>> ********************************************
>> [client]
>> user=mysqld_exporter
>> password=myuser
>>
>> [Unit]
>> Description=Prometheus MySQL Exporter
>> After=network.target
>> User=prometheus
>> Group=prometheus
>>
>> [Service]
>> Type=simple
>> Restart=always
>> ExecStart=/usr/local/bin/mysqld_exporter \
>> --config.my-cnf /etc/.mysqld_exporter.cnf \
>> --collect.global_status \
>> --collect.info_schema.innodb_metrics \
>> --collect.auto_increment.columns \
>> --collect.info_schema.processlist \
>> --collect.binlog_size \
>> --collect.info_schema.tables.databases \
>> --collect.info_schema.tablestats \
>> --collect.global_variables \
>> --collect.info_schema.query_response_time \
>> --collect.info_schema.userstats \
>> --collect.info_schema.tables \
>> --collect.perf_schema.tablelocks \
>> --collect.perf_schema.file_events \
>> --collect.perf_schema.eventswaits \
>> --collect.perf_schema.indexiowaits \
>> --collect.perf_schema.tableiowaits \
>> --collect.perf_schema.memory_events \
>> --collect.slave_status \
>> --web.listen-address=192.168.1.48:9104
>>
>> [Install]
>> WantedBy=multi-user.target
>>
>> ***********************************************
>>
>> It starts succesfuly by running the service status in green and no
>> errors. Thanks for your help
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/b2eb6e6b-6341-47ea-abf5-95c2a0e6588dn%40googlegroups.com.
