prometheus监控插件mysqld_exporter

1,首先需要增加授权

mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost' IDENTIFIED BY 'exporter123' WITH MAX_USER_CONNECTIONS 3;
mysql> flush privileges;

2, 安装mysqld_exporter

cd /usr/local/prometheus/
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz
tar xzvf  mysqld_exporter-0.12.1.linux-amd64.tar.gz
mv mysqld_exporter-0.12.1.linux-amd64.tar.gz  mysqld_exporter
chown -R root:root /usr/local/prometheus/mysqld_exporter/mysqld_exporter
chmod 755 /usr/local/prometheus/mysqld_exporter/mysqld_exporter

3,修改启动参数,启动参数参考 https://github.com/prometheus/mysqld_exporter

# vim /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter
After=network.target
[Service]
Type=simple
User=mysql
Environment=DATA_SOURCE_NAME=exporter:exporter123@(localhost:3306)/
ExecStart=/usr/local/prometheus/mysqld_exporter/mysqld_exporter --web.listen-address=0.0.0.0:9104 
  --config.my-cnf /etc/my.cnf \
  --collect.slave_status \
  --collect.slave_hosts \
  --log.level=error \
  --collect.info_schema.processlist \
  --collect.info_schema.innodb_metrics \
  --collect.info_schema.innodb_tablespaces \
  --collect.info_schema.innodb_cmp \
  --collect.info_schema.innodb_cmpmem 
Restart=on-failure
[Install]
WantedBy=multi-user.targe

4,启动exporter

chown -R root:root /usr/lib/systemd/system/mysqld_exporter.service
chmod 644 /usr/lib/systemd/system/mysqld_exporter.service
systemctl daemon-reload
systemctl enable mysqld_exporter.service
systemctl start mysqld_exporter.service

5,访问localhost:9104/metrics可以看到mysql的指标

# HELP go_gc_duration_seconds A summary of the GC invocation durations.
# TYPE go_gc_duration_seconds summary
go_gc_duration_seconds{quantile="0"} 1.0977e-05
go_gc_duration_seconds{quantile="0.25"} 1.1386e-05
go_gc_duration_seconds{quantile="0.5"} 1.1929e-05
go_gc_duration_seconds{quantile="0.75"} 1.665e-05
go_gc_duration_seconds{quantile="1"} 3.3897e-05
go_gc_duration_seconds_sum 0.000189596
go_gc_duration_seconds_count 12
# HELP go_goroutines Number of goroutines that currently exist.
# TYPE go_goroutines gauge
go_goroutines 8
# HELP go_info Information about the Go environment.
# TYPE go_info gauge
go_info{version="go1.12.7"} 1
# HELP go_memstats_alloc_bytes Number of bytes allocated and still in use.
# TYPE go_memstats_alloc_bytes gauge
go_memstats_alloc_bytes 3.629432e+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 4.2394304e+07
# 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.453065e+06
# HELP go_memstats_frees_total Total number of frees.
# TYPE go_memstats_frees_total counter
go_memstats_frees_total 465183
# 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 7.302882812032124e-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 2.377728e+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 3.629432e+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.2521344e+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 4.325376e+06
# HELP go_memstats_heap_objects Number of allocated objects.
# TYPE go_memstats_heap_objects gauge
go_memstats_heap_objects 36639
# 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 0
# 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.684672e+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.5674982620900977e+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 501822
# 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 1736
# 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 52992
# 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 81920
# 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.194304e+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 462063
# 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 262144
# 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 262144
# HELP go_memstats_sys_bytes Number of bytes obtained from system.
# TYPE go_memstats_sys_bytes gauge
go_memstats_sys_bytes 7.1500024e+07
# HELP go_threads Number of OS threads created.
# TYPE go_threads gauge
go_threads 4
# HELP mysql_engine_innodb_queries_in_queue Queries in queue.
# TYPE mysql_engine_innodb_queries_in_queue gauge
mysql_engine_innodb_queries_in_queue 0
# HELP mysql_engine_innodb_queries_inside_innodb Queries inside InnoDB.
# TYPE mysql_engine_innodb_queries_inside_innodb gauge
mysql_engine_innodb_queries_inside_innodb 0
# HELP mysql_engine_innodb_read_views_open_inside_innodb Read views open inside InnoDB.
# TYPE mysql_engine_innodb_read_views_open_inside_innodb gauge
mysql_engine_innodb_read_views_open_inside_innodb 1
# HELP mysql_exporter_collector_duration_seconds Collector time duration.
# TYPE mysql_exporter_collector_duration_seconds gauge
mysql_exporter_collector_duration_seconds{collector="collect.auto_increment.columns"} 0.03696908
mysql_exporter_collector_duration_seconds{collector="collect.binlog_size"} 0.03718016
mysql_exporter_collector_duration_seconds{collector="collect.engine_innodb_status"} 0.038377616
mysql_exporter_collector_duration_seconds{collector="collect.global_status"} 0.004310551
mysql_exporter_collector_duration_seconds{collector="collect.global_variables"} 0.008751877
mysql_exporter_collector_duration_seconds{collector="collect.info_schema.innodb_cmp"} 0.037486441
mysql_exporter_collector_duration_seconds{collector="collect.info_schema.innodb_cmpmem"} 0.01038609
mysql_exporter_collector_duration_seconds{collector="collect.info_schema.processlist"} 0.010129898
mysql_exporter_collector_duration_seconds{collector="collect.info_schema.query_response_time"} 0.000175056
mysql_exporter_collector_duration_seconds{collector="collect.slave_hosts"} 0.00018049
mysql_exporter_collector_duration_seconds{collector="collect.slave_status"} 0.038715673
mysql_exporter_collector_duration_seconds{collector="connection"} 0.000719595
# 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 0
# HELP mysql_exporter_scrapes_total Total number of times MySQL was scraped for metrics.
# TYPE mysql_exporter_scrapes_total counter
mysql_exporter_scrapes_total 15
# HELP mysql_global_status_aborted_clients Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aborted_clients untyped
mysql_global_status_aborted_clients 1
# HELP mysql_global_status_aborted_connects Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aborted_connects untyped
mysql_global_status_aborted_connects 116
# HELP mysql_global_status_access_denied_errors Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_access_denied_errors untyped
mysql_global_status_access_denied_errors 116
# HELP mysql_global_status_aria_pagecache_blocks_not_flushed Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_blocks_not_flushed untyped
mysql_global_status_aria_pagecache_blocks_not_flushed 0
# HELP mysql_global_status_aria_pagecache_blocks_unused Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_blocks_unused untyped
mysql_global_status_aria_pagecache_blocks_unused 15737
# HELP mysql_global_status_aria_pagecache_blocks_used Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_blocks_used untyped
mysql_global_status_aria_pagecache_blocks_used 35
# HELP mysql_global_status_aria_pagecache_read_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_read_requests untyped
mysql_global_status_aria_pagecache_read_requests 145109
# HELP mysql_global_status_aria_pagecache_reads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_reads untyped
mysql_global_status_aria_pagecache_reads 138
# HELP mysql_global_status_aria_pagecache_write_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_write_requests untyped
mysql_global_status_aria_pagecache_write_requests 2553
# HELP mysql_global_status_aria_pagecache_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_pagecache_writes untyped
mysql_global_status_aria_pagecache_writes 0
# HELP mysql_global_status_aria_transaction_log_syncs Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_aria_transaction_log_syncs untyped
mysql_global_status_aria_transaction_log_syncs 0
# HELP mysql_global_status_binlog_bytes_written Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_bytes_written untyped
mysql_global_status_binlog_bytes_written 0
# HELP mysql_global_status_binlog_cache_disk_use Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_cache_disk_use untyped
mysql_global_status_binlog_cache_disk_use 0
# HELP mysql_global_status_binlog_cache_use Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_cache_use untyped
mysql_global_status_binlog_cache_use 0
# HELP mysql_global_status_binlog_commits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_commits untyped
mysql_global_status_binlog_commits 0
# HELP mysql_global_status_binlog_group_commits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_group_commits untyped
mysql_global_status_binlog_group_commits 0
# HELP mysql_global_status_binlog_snapshot_position Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_snapshot_position untyped
mysql_global_status_binlog_snapshot_position 0
# HELP mysql_global_status_binlog_stmt_cache_disk_use Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_stmt_cache_disk_use untyped
mysql_global_status_binlog_stmt_cache_disk_use 0
# HELP mysql_global_status_binlog_stmt_cache_use Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_binlog_stmt_cache_use untyped
mysql_global_status_binlog_stmt_cache_use 0
# HELP mysql_global_status_buffer_pool_dirty_pages Innodb buffer pool dirty pages.
# TYPE mysql_global_status_buffer_pool_dirty_pages gauge
mysql_global_status_buffer_pool_dirty_pages 0
# HELP mysql_global_status_buffer_pool_page_changes_total Innodb buffer pool page state changes.
# TYPE mysql_global_status_buffer_pool_page_changes_total counter
mysql_global_status_buffer_pool_page_changes_total{operation="flushed"} 0
mysql_global_status_buffer_pool_page_changes_total{operation="lru_flushed"} 0
mysql_global_status_buffer_pool_page_changes_total{operation="made_not_young"} 0
mysql_global_status_buffer_pool_page_changes_total{operation="made_young"} 0
# HELP mysql_global_status_buffer_pool_pages Innodb buffer pool pages by state.
# TYPE mysql_global_status_buffer_pool_pages gauge
mysql_global_status_buffer_pool_pages{state="data"} 2823
mysql_global_status_buffer_pool_pages{state="free"} 5365
mysql_global_status_buffer_pool_pages{state="misc"} 3
mysql_global_status_buffer_pool_pages{state="old"} 1062
# HELP mysql_global_status_busy_time Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_busy_time untyped
mysql_global_status_busy_time 0
# HELP mysql_global_status_bytes_received Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_bytes_received untyped
mysql_global_status_bytes_received 125943
# HELP mysql_global_status_bytes_sent Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_bytes_sent untyped
mysql_global_status_bytes_sent 2.41986e+06
# HELP mysql_global_status_commands_total Total number of executed MySQL commands.
# TYPE mysql_global_status_commands_total counter
mysql_global_status_commands_total{command="admin_commands"} 71
mysql_global_status_commands_total{command="alter_db"} 0
mysql_global_status_commands_total{command="alter_db_upgrade"} 0
mysql_global_status_commands_total{command="alter_event"} 0
mysql_global_status_commands_total{command="alter_function"} 0
mysql_global_status_commands_total{command="alter_procedure"} 0
mysql_global_status_commands_total{command="alter_server"} 0
mysql_global_status_commands_total{command="alter_table"} 0
mysql_global_status_commands_total{command="alter_tablespace"} 0
mysql_global_status_commands_total{command="analyze"} 0
mysql_global_status_commands_total{command="assign_to_keycache"} 0
mysql_global_status_commands_total{command="begin"} 0
mysql_global_status_commands_total{command="binlog"} 0
mysql_global_status_commands_total{command="call_procedure"} 0
mysql_global_status_commands_total{command="change_db"} 0
mysql_global_status_commands_total{command="change_master"} 0
mysql_global_status_commands_total{command="check"} 0
mysql_global_status_commands_total{command="checksum"} 0
mysql_global_status_commands_total{command="commit"} 0
mysql_global_status_commands_total{command="create_db"} 0
mysql_global_status_commands_total{command="create_event"} 0
mysql_global_status_commands_total{command="create_function"} 0
mysql_global_status_commands_total{command="create_index"} 0
mysql_global_status_commands_total{command="create_procedure"} 0
mysql_global_status_commands_total{command="create_server"} 0
mysql_global_status_commands_total{command="create_table"} 0
mysql_global_status_commands_total{command="create_trigger"} 0
mysql_global_status_commands_total{command="create_udf"} 0
mysql_global_status_commands_total{command="create_user"} 0
mysql_global_status_commands_total{command="create_view"} 0
mysql_global_status_commands_total{command="dealloc_sql"} 0
mysql_global_status_commands_total{command="delete"} 0
mysql_global_status_commands_total{command="delete_multi"} 0
mysql_global_status_commands_total{command="do"} 0
mysql_global_status_commands_total{command="drop_db"} 0
mysql_global_status_commands_total{command="drop_event"} 0
mysql_global_status_commands_total{command="drop_function"} 0
mysql_global_status_commands_total{command="drop_index"} 0
mysql_global_status_commands_total{command="drop_procedure"} 0
mysql_global_status_commands_total{command="drop_server"} 0
mysql_global_status_commands_total{command="drop_table"} 0
mysql_global_status_commands_total{command="drop_trigger"} 0
mysql_global_status_commands_total{command="drop_user"} 0
mysql_global_status_commands_total{command="drop_view"} 0
mysql_global_status_commands_total{command="empty_query"} 0
mysql_global_status_commands_total{command="execute_sql"} 0
mysql_global_status_commands_total{command="flush"} 0
mysql_global_status_commands_total{command="grant"} 0
mysql_global_status_commands_total{command="ha_close"} 0
mysql_global_status_commands_total{command="ha_open"} 0
mysql_global_status_commands_total{command="ha_read"} 0
mysql_global_status_commands_total{command="help"} 0
mysql_global_status_commands_total{command="insert"} 0
mysql_global_status_commands_total{command="insert_select"} 0
mysql_global_status_commands_total{command="install_plugin"} 0
mysql_global_status_commands_total{command="kill"} 0
mysql_global_status_commands_total{command="load"} 0
mysql_global_status_commands_total{command="lock_tables"} 0
mysql_global_status_commands_total{command="optimize"} 0
mysql_global_status_commands_total{command="preload_keys"} 0
mysql_global_status_commands_total{command="prepare_sql"} 0
mysql_global_status_commands_total{command="purge"} 0
mysql_global_status_commands_total{command="purge_before_date"} 0
mysql_global_status_commands_total{command="release_savepoint"} 0
mysql_global_status_commands_total{command="rename_table"} 0
mysql_global_status_commands_total{command="rename_user"} 0
mysql_global_status_commands_total{command="repair"} 0
mysql_global_status_commands_total{command="replace"} 0
mysql_global_status_commands_total{command="replace_select"} 0
mysql_global_status_commands_total{command="reset"} 0
mysql_global_status_commands_total{command="resignal"} 0
mysql_global_status_commands_total{command="revoke"} 0
mysql_global_status_commands_total{command="revoke_all"} 0
mysql_global_status_commands_total{command="rollback"} 0
mysql_global_status_commands_total{command="rollback_to_savepoint"} 0
mysql_global_status_commands_total{command="savepoint"} 0
mysql_global_status_commands_total{command="select"} 416
mysql_global_status_commands_total{command="set_option"} 142
mysql_global_status_commands_total{command="show_authors"} 0
mysql_global_status_commands_total{command="show_binlog_events"} 0
mysql_global_status_commands_total{command="show_binlogs"} 0
mysql_global_status_commands_total{command="show_charsets"} 0
mysql_global_status_commands_total{command="show_client_statistics"} 0
mysql_global_status_commands_total{command="show_collations"} 0
mysql_global_status_commands_total{command="show_contributors"} 0
mysql_global_status_commands_total{command="show_create_db"} 0
mysql_global_status_commands_total{command="show_create_event"} 0
mysql_global_status_commands_total{command="show_create_func"} 0
mysql_global_status_commands_total{command="show_create_proc"} 0
mysql_global_status_commands_total{command="show_create_table"} 0
mysql_global_status_commands_total{command="show_create_trigger"} 0
mysql_global_status_commands_total{command="show_databases"} 1
mysql_global_status_commands_total{command="show_engine_logs"} 0
mysql_global_status_commands_total{command="show_engine_mutex"} 0
mysql_global_status_commands_total{command="show_engine_status"} 68
mysql_global_status_commands_total{command="show_errors"} 0
mysql_global_status_commands_total{command="show_events"} 0
mysql_global_status_commands_total{command="show_fields"} 0
mysql_global_status_commands_total{command="show_function_status"} 0
mysql_global_status_commands_total{command="show_grants"} 0
mysql_global_status_commands_total{command="show_index_statistics"} 0
mysql_global_status_commands_total{command="show_keys"} 0
mysql_global_status_commands_total{command="show_master_status"} 0
mysql_global_status_commands_total{command="show_open_tables"} 0
mysql_global_status_commands_total{command="show_plugins"} 0
mysql_global_status_commands_total{command="show_privileges"} 0
mysql_global_status_commands_total{command="show_procedure_status"} 0
mysql_global_status_commands_total{command="show_processlist"} 0
mysql_global_status_commands_total{command="show_profile"} 0
mysql_global_status_commands_total{command="show_profiles"} 0
mysql_global_status_commands_total{command="show_relaylog_events"} 0
mysql_global_status_commands_total{command="show_slave_hosts"} 70
mysql_global_status_commands_total{command="show_slave_status"} 68
mysql_global_status_commands_total{command="show_status"} 70
mysql_global_status_commands_total{command="show_storage_engines"} 0
mysql_global_status_commands_total{command="show_table_statistics"} 0
mysql_global_status_commands_total{command="show_table_status"} 0
mysql_global_status_commands_total{command="show_tables"} 0
mysql_global_status_commands_total{command="show_triggers"} 0
mysql_global_status_commands_total{command="show_user_statistics"} 0
mysql_global_status_commands_total{command="show_variables"} 69
mysql_global_status_commands_total{command="show_warnings"} 0
mysql_global_status_commands_total{command="signal"} 0
mysql_global_status_commands_total{command="slave_start"} 0
mysql_global_status_commands_total{command="slave_stop"} 0
mysql_global_status_commands_total{command="stmt_close"} 0
mysql_global_status_commands_total{command="stmt_execute"} 0
mysql_global_status_commands_total{command="stmt_fetch"} 0
mysql_global_status_commands_total{command="stmt_prepare"} 0
mysql_global_status_commands_total{command="stmt_reprepare"} 0
mysql_global_status_commands_total{command="stmt_reset"} 0
mysql_global_status_commands_total{command="stmt_send_long_data"} 0
mysql_global_status_commands_total{command="truncate"} 0
mysql_global_status_commands_total{command="uninstall_plugin"} 0
mysql_global_status_commands_total{command="unlock_tables"} 0
mysql_global_status_commands_total{command="update"} 0
mysql_global_status_commands_total{command="update_multi"} 0
mysql_global_status_commands_total{command="xa_commit"} 0
mysql_global_status_commands_total{command="xa_end"} 0
mysql_global_status_commands_total{command="xa_prepare"} 0
mysql_global_status_commands_total{command="xa_recover"} 0
mysql_global_status_commands_total{command="xa_rollback"} 0
mysql_global_status_commands_total{command="xa_start"} 0
# HELP mysql_global_status_compression Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_compression untyped
mysql_global_status_compression 0
# HELP mysql_global_status_connections Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_connections untyped
mysql_global_status_connections 189
# HELP mysql_global_status_cpu_time Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_cpu_time untyped
mysql_global_status_cpu_time 0
# HELP mysql_global_status_created_tmp_disk_tables Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_created_tmp_disk_tables untyped
mysql_global_status_created_tmp_disk_tables 1380
# HELP mysql_global_status_created_tmp_files Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_created_tmp_files untyped
mysql_global_status_created_tmp_files 6
# HELP mysql_global_status_created_tmp_tables Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_created_tmp_tables untyped
mysql_global_status_created_tmp_tables 9110
# HELP mysql_global_status_delayed_errors Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_delayed_errors untyped
mysql_global_status_delayed_errors 0
# HELP mysql_global_status_delayed_insert_threads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_delayed_insert_threads untyped
mysql_global_status_delayed_insert_threads 0
# HELP mysql_global_status_delayed_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_delayed_writes untyped
mysql_global_status_delayed_writes 0
# HELP mysql_global_status_empty_queries Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_empty_queries untyped
mysql_global_status_empty_queries 67
# HELP mysql_global_status_executed_events Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_executed_events untyped
mysql_global_status_executed_events 0
# HELP mysql_global_status_executed_triggers Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_executed_triggers untyped
mysql_global_status_executed_triggers 0
# HELP mysql_global_status_feature_dynamic_columns Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_dynamic_columns untyped
mysql_global_status_feature_dynamic_columns 0
# HELP mysql_global_status_feature_fulltext Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_fulltext untyped
mysql_global_status_feature_fulltext 0
# HELP mysql_global_status_feature_gis Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_gis untyped
mysql_global_status_feature_gis 0
# HELP mysql_global_status_feature_locale Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_locale untyped
mysql_global_status_feature_locale 0
# HELP mysql_global_status_feature_subquery Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_subquery untyped
mysql_global_status_feature_subquery 0
# HELP mysql_global_status_feature_timezone Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_timezone untyped
mysql_global_status_feature_timezone 0
# HELP mysql_global_status_feature_trigger Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_trigger untyped
mysql_global_status_feature_trigger 0
# HELP mysql_global_status_feature_xml Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_feature_xml untyped
mysql_global_status_feature_xml 0
# HELP mysql_global_status_flush_commands Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_flush_commands untyped
mysql_global_status_flush_commands 2
# HELP mysql_global_status_handlers_total Total number of executed MySQL handlers.
# TYPE mysql_global_status_handlers_total counter
mysql_global_status_handlers_total{handler="commit"} 0
mysql_global_status_handlers_total{handler="delete"} 0
mysql_global_status_handlers_total{handler="discover"} 0
mysql_global_status_handlers_total{handler="icp_attempts"} 0
mysql_global_status_handlers_total{handler="icp_match"} 0
mysql_global_status_handlers_total{handler="mrr_init"} 0
mysql_global_status_handlers_total{handler="mrr_key_refills"} 0
mysql_global_status_handlers_total{handler="mrr_rowid_refills"} 0
mysql_global_status_handlers_total{handler="prepare"} 0
mysql_global_status_handlers_total{handler="read_first"} 0
mysql_global_status_handlers_total{handler="read_key"} 2
mysql_global_status_handlers_total{handler="read_last"} 0
mysql_global_status_handlers_total{handler="read_next"} 0
mysql_global_status_handlers_total{handler="read_prev"} 0
mysql_global_status_handlers_total{handler="read_rnd"} 0
mysql_global_status_handlers_total{handler="read_rnd_deleted"} 0
mysql_global_status_handlers_total{handler="read_rnd_next"} 221018
mysql_global_status_handlers_total{handler="rollback"} 0
mysql_global_status_handlers_total{handler="savepoint"} 0
mysql_global_status_handlers_total{handler="savepoint_rollback"} 0
mysql_global_status_handlers_total{handler="tmp_update"} 0
mysql_global_status_handlers_total{handler="tmp_write"} 220465
mysql_global_status_handlers_total{handler="update"} 0
mysql_global_status_handlers_total{handler="write"} 0
# HELP mysql_global_status_innodb_adaptive_hash_cells Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_adaptive_hash_cells untyped
mysql_global_status_innodb_adaptive_hash_cells 276671
# HELP mysql_global_status_innodb_adaptive_hash_hash_searches Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_adaptive_hash_hash_searches untyped
mysql_global_status_innodb_adaptive_hash_hash_searches 738
# HELP mysql_global_status_innodb_adaptive_hash_heap_buffers Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_adaptive_hash_heap_buffers untyped
mysql_global_status_innodb_adaptive_hash_heap_buffers 2
# HELP mysql_global_status_innodb_adaptive_hash_non_hash_searches Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_adaptive_hash_non_hash_searches untyped
mysql_global_status_innodb_adaptive_hash_non_hash_searches 2189
# HELP mysql_global_status_innodb_background_log_sync Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_background_log_sync untyped
mysql_global_status_innodb_background_log_sync 126
# HELP mysql_global_status_innodb_buffer_pool_bytes_data Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_bytes_data untyped
mysql_global_status_innodb_buffer_pool_bytes_data 4.6252032e+07
# HELP mysql_global_status_innodb_buffer_pool_bytes_dirty Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_bytes_dirty untyped
mysql_global_status_innodb_buffer_pool_bytes_dirty 0
# HELP mysql_global_status_innodb_buffer_pool_read_ahead Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_read_ahead untyped
mysql_global_status_innodb_buffer_pool_read_ahead 0
# HELP mysql_global_status_innodb_buffer_pool_read_ahead_evicted Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_read_ahead_evicted untyped
mysql_global_status_innodb_buffer_pool_read_ahead_evicted 0
# HELP mysql_global_status_innodb_buffer_pool_read_ahead_rnd Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_read_ahead_rnd untyped
mysql_global_status_innodb_buffer_pool_read_ahead_rnd 0
# HELP mysql_global_status_innodb_buffer_pool_read_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_read_requests untyped
mysql_global_status_innodb_buffer_pool_read_requests 308014
# HELP mysql_global_status_innodb_buffer_pool_reads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_reads untyped
mysql_global_status_innodb_buffer_pool_reads 2824
# HELP mysql_global_status_innodb_buffer_pool_wait_free Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_wait_free untyped
mysql_global_status_innodb_buffer_pool_wait_free 0
# HELP mysql_global_status_innodb_buffer_pool_write_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_buffer_pool_write_requests untyped
mysql_global_status_innodb_buffer_pool_write_requests 0
# HELP mysql_global_status_innodb_checkpoint_age Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_checkpoint_age untyped
mysql_global_status_innodb_checkpoint_age 0
# HELP mysql_global_status_innodb_checkpoint_max_age Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_checkpoint_max_age untyped
mysql_global_status_innodb_checkpoint_max_age 7.78236e+06
# HELP mysql_global_status_innodb_checkpoint_target_age Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_checkpoint_target_age untyped
mysql_global_status_innodb_checkpoint_target_age 7.539162e+06
# HELP mysql_global_status_innodb_current_row_locks Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_current_row_locks untyped
mysql_global_status_innodb_current_row_locks 0
# HELP mysql_global_status_innodb_data_fsyncs Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_fsyncs untyped
mysql_global_status_innodb_data_fsyncs 3
# HELP mysql_global_status_innodb_data_pending_fsyncs Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_pending_fsyncs untyped
mysql_global_status_innodb_data_pending_fsyncs 0
# HELP mysql_global_status_innodb_data_pending_reads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_pending_reads untyped
mysql_global_status_innodb_data_pending_reads 0
# HELP mysql_global_status_innodb_data_pending_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_pending_writes untyped
mysql_global_status_innodb_data_pending_writes 0
# HELP mysql_global_status_innodb_data_read Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_read untyped
mysql_global_status_innodb_data_read 4.8452096e+07
# HELP mysql_global_status_innodb_data_reads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_reads untyped
mysql_global_status_innodb_data_reads 2835
# HELP mysql_global_status_innodb_data_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_writes untyped
mysql_global_status_innodb_data_writes 3
# HELP mysql_global_status_innodb_data_written Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_data_written untyped
mysql_global_status_innodb_data_written 1536
# HELP mysql_global_status_innodb_dblwr_pages_written Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_dblwr_pages_written untyped
mysql_global_status_innodb_dblwr_pages_written 0
# HELP mysql_global_status_innodb_dblwr_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_dblwr_writes untyped
mysql_global_status_innodb_dblwr_writes 0
# HELP mysql_global_status_innodb_deadlocks Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_deadlocks untyped
mysql_global_status_innodb_deadlocks 0
# HELP mysql_global_status_innodb_descriptors_memory Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_descriptors_memory untyped
mysql_global_status_innodb_descriptors_memory 8000
# HELP mysql_global_status_innodb_dict_tables Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_dict_tables untyped
mysql_global_status_innodb_dict_tables 159
# HELP mysql_global_status_innodb_have_atomic_builtins Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_have_atomic_builtins untyped
mysql_global_status_innodb_have_atomic_builtins 1
# HELP mysql_global_status_innodb_history_list_length Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_history_list_length untyped
mysql_global_status_innodb_history_list_length 698
# HELP mysql_global_status_innodb_ibuf_discarded_delete_marks Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_discarded_delete_marks untyped
mysql_global_status_innodb_ibuf_discarded_delete_marks 0
# HELP mysql_global_status_innodb_ibuf_discarded_deletes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_discarded_deletes untyped
mysql_global_status_innodb_ibuf_discarded_deletes 0
# HELP mysql_global_status_innodb_ibuf_discarded_inserts Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_discarded_inserts untyped
mysql_global_status_innodb_ibuf_discarded_inserts 0
# HELP mysql_global_status_innodb_ibuf_free_list Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_free_list untyped
mysql_global_status_innodb_ibuf_free_list 0
# HELP mysql_global_status_innodb_ibuf_merged_delete_marks Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_merged_delete_marks untyped
mysql_global_status_innodb_ibuf_merged_delete_marks 0
# HELP mysql_global_status_innodb_ibuf_merged_deletes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_merged_deletes untyped
mysql_global_status_innodb_ibuf_merged_deletes 0
# HELP mysql_global_status_innodb_ibuf_merged_inserts Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_merged_inserts untyped
mysql_global_status_innodb_ibuf_merged_inserts 0
# HELP mysql_global_status_innodb_ibuf_merges Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_merges untyped
mysql_global_status_innodb_ibuf_merges 0
# HELP mysql_global_status_innodb_ibuf_segment_size Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_segment_size untyped
mysql_global_status_innodb_ibuf_segment_size 2
# HELP mysql_global_status_innodb_ibuf_size Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_ibuf_size untyped
mysql_global_status_innodb_ibuf_size 1
# HELP mysql_global_status_innodb_log_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_log_waits untyped
mysql_global_status_innodb_log_waits 0
# HELP mysql_global_status_innodb_log_write_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_log_write_requests untyped
mysql_global_status_innodb_log_write_requests 0
# HELP mysql_global_status_innodb_log_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_log_writes untyped
mysql_global_status_innodb_log_writes 1
# HELP mysql_global_status_innodb_lsn_current Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_lsn_current untyped
mysql_global_status_innodb_lsn_current 3.029829014e+09
# HELP mysql_global_status_innodb_lsn_flushed Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_lsn_flushed untyped
mysql_global_status_innodb_lsn_flushed 3.029829014e+09
# HELP mysql_global_status_innodb_lsn_last_checkpoint Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_lsn_last_checkpoint untyped
mysql_global_status_innodb_lsn_last_checkpoint 3.029829014e+09
# HELP mysql_global_status_innodb_master_thread_10_second_loops Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_master_thread_10_second_loops untyped
mysql_global_status_innodb_master_thread_10_second_loops 0
# HELP mysql_global_status_innodb_master_thread_1_second_loops Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_master_thread_1_second_loops untyped
mysql_global_status_innodb_master_thread_1_second_loops 1
# HELP mysql_global_status_innodb_master_thread_background_loops Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_master_thread_background_loops untyped
mysql_global_status_innodb_master_thread_background_loops 1
# HELP mysql_global_status_innodb_master_thread_main_flush_loops Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_master_thread_main_flush_loops untyped
mysql_global_status_innodb_master_thread_main_flush_loops 1
# HELP mysql_global_status_innodb_master_thread_sleeps Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_master_thread_sleeps untyped
mysql_global_status_innodb_master_thread_sleeps 1
# HELP mysql_global_status_innodb_max_trx_id Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_max_trx_id untyped
mysql_global_status_innodb_max_trx_id 3.464064e+07
# HELP mysql_global_status_innodb_mem_adaptive_hash Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_mem_adaptive_hash untyped
mysql_global_status_innodb_mem_adaptive_hash 2.266736e+06
# HELP mysql_global_status_innodb_mem_dictionary Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_mem_dictionary untyped
mysql_global_status_innodb_mem_dictionary 1.713874e+06
# HELP mysql_global_status_innodb_mem_total Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_mem_total untyped
mysql_global_status_innodb_mem_total 1.37756672e+08
# HELP mysql_global_status_innodb_mutex_os_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_mutex_os_waits untyped
mysql_global_status_innodb_mutex_os_waits 0
# HELP mysql_global_status_innodb_mutex_spin_rounds Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_mutex_spin_rounds untyped
mysql_global_status_innodb_mutex_spin_rounds 0
# HELP mysql_global_status_innodb_mutex_spin_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_mutex_spin_waits untyped
mysql_global_status_innodb_mutex_spin_waits 0
# HELP mysql_global_status_innodb_oldest_view_low_limit_trx_id Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_oldest_view_low_limit_trx_id untyped
mysql_global_status_innodb_oldest_view_low_limit_trx_id 3.464064e+07
# HELP mysql_global_status_innodb_os_log_fsyncs Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_os_log_fsyncs untyped
mysql_global_status_innodb_os_log_fsyncs 3
# HELP mysql_global_status_innodb_os_log_pending_fsyncs Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_os_log_pending_fsyncs untyped
mysql_global_status_innodb_os_log_pending_fsyncs 0
# HELP mysql_global_status_innodb_os_log_pending_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_os_log_pending_writes untyped
mysql_global_status_innodb_os_log_pending_writes 0
# HELP mysql_global_status_innodb_os_log_written Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_os_log_written untyped
mysql_global_status_innodb_os_log_written 512
# HELP mysql_global_status_innodb_page_size Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_page_size untyped
mysql_global_status_innodb_page_size 16384
# HELP mysql_global_status_innodb_pages_created Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_pages_created untyped
mysql_global_status_innodb_pages_created 0
# HELP mysql_global_status_innodb_pages_read Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_pages_read untyped
mysql_global_status_innodb_pages_read 2823
# HELP mysql_global_status_innodb_pages_written Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_pages_written untyped
mysql_global_status_innodb_pages_written 0
# HELP mysql_global_status_innodb_purge_trx_id Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_purge_trx_id untyped
mysql_global_status_innodb_purge_trx_id 3.4639695e+07
# HELP mysql_global_status_innodb_purge_undo_no Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_purge_undo_no untyped
mysql_global_status_innodb_purge_undo_no 0
# HELP mysql_global_status_innodb_read_views_memory Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_read_views_memory untyped
mysql_global_status_innodb_read_views_memory 88
# HELP mysql_global_status_innodb_row_lock_current_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_row_lock_current_waits untyped
mysql_global_status_innodb_row_lock_current_waits 0
# HELP mysql_global_status_innodb_row_lock_time Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_row_lock_time untyped
mysql_global_status_innodb_row_lock_time 0
# HELP mysql_global_status_innodb_row_lock_time_avg Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_row_lock_time_avg untyped
mysql_global_status_innodb_row_lock_time_avg 0
# HELP mysql_global_status_innodb_row_lock_time_max Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_row_lock_time_max untyped
mysql_global_status_innodb_row_lock_time_max 0
# HELP mysql_global_status_innodb_row_lock_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_row_lock_waits untyped
mysql_global_status_innodb_row_lock_waits 0
# HELP mysql_global_status_innodb_row_ops_total Total number of MySQL InnoDB row operations.
# TYPE mysql_global_status_innodb_row_ops_total counter
mysql_global_status_innodb_row_ops_total{operation="deleted"} 0
mysql_global_status_innodb_row_ops_total{operation="inserted"} 0
mysql_global_status_innodb_row_ops_total{operation="read"} 0
mysql_global_status_innodb_row_ops_total{operation="updated"} 0
# HELP mysql_global_status_innodb_s_lock_os_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_s_lock_os_waits untyped
mysql_global_status_innodb_s_lock_os_waits 2
# HELP mysql_global_status_innodb_s_lock_spin_rounds Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_s_lock_spin_rounds untyped
mysql_global_status_innodb_s_lock_spin_rounds 60
# HELP mysql_global_status_innodb_s_lock_spin_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_s_lock_spin_waits untyped
mysql_global_status_innodb_s_lock_spin_waits 2
# HELP mysql_global_status_innodb_truncated_status_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_truncated_status_writes untyped
mysql_global_status_innodb_truncated_status_writes 0
# HELP mysql_global_status_innodb_x_lock_os_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_x_lock_os_waits untyped
mysql_global_status_innodb_x_lock_os_waits 8
# HELP mysql_global_status_innodb_x_lock_spin_rounds Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_x_lock_spin_rounds untyped
mysql_global_status_innodb_x_lock_spin_rounds 240
# HELP mysql_global_status_innodb_x_lock_spin_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_innodb_x_lock_spin_waits untyped
mysql_global_status_innodb_x_lock_spin_waits 5
# HELP mysql_global_status_key_blocks_not_flushed Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_blocks_not_flushed untyped
mysql_global_status_key_blocks_not_flushed 0
# HELP mysql_global_status_key_blocks_unused Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_blocks_unused untyped
mysql_global_status_key_blocks_unused 107171
# HELP mysql_global_status_key_blocks_used Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_blocks_used untyped
mysql_global_status_key_blocks_used 0
# HELP mysql_global_status_key_blocks_warm Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_blocks_warm untyped
mysql_global_status_key_blocks_warm 0
# HELP mysql_global_status_key_read_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_read_requests untyped
mysql_global_status_key_read_requests 0
# HELP mysql_global_status_key_reads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_reads untyped
mysql_global_status_key_reads 0
# HELP mysql_global_status_key_write_requests Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_write_requests untyped
mysql_global_status_key_write_requests 0
# HELP mysql_global_status_key_writes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_key_writes untyped
mysql_global_status_key_writes 0
# HELP mysql_global_status_last_query_cost Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_last_query_cost untyped
mysql_global_status_last_query_cost 0
# HELP mysql_global_status_max_used_connections Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_max_used_connections untyped
mysql_global_status_max_used_connections 2
# HELP mysql_global_status_not_flushed_delayed_rows Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_not_flushed_delayed_rows untyped
mysql_global_status_not_flushed_delayed_rows 0
# HELP mysql_global_status_open_files Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_open_files untyped
mysql_global_status_open_files 51
# HELP mysql_global_status_open_streams Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_open_streams untyped
mysql_global_status_open_streams 0
# HELP mysql_global_status_open_table_definitions Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_open_table_definitions untyped
mysql_global_status_open_table_definitions 192
# HELP mysql_global_status_open_tables Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_open_tables untyped
mysql_global_status_open_tables 193
# HELP mysql_global_status_opened_files Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_opened_files untyped
mysql_global_status_opened_files 5796
# HELP mysql_global_status_opened_table_definitions Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_opened_table_definitions untyped
mysql_global_status_opened_table_definitions 159
# HELP mysql_global_status_opened_tables Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_opened_tables untyped
mysql_global_status_opened_tables 167
# HELP mysql_global_status_opened_views Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_opened_views untyped
mysql_global_status_opened_views 0
# HELP mysql_global_status_performance_schema_lost_total Total number of MySQL instrumentations that could not be loaded or created due to memory constraints.
# TYPE mysql_global_status_performance_schema_lost_total counter
mysql_global_status_performance_schema_lost_total{instrumentation="cond_classes_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="cond_instances_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="file_classes_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="file_handles_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="file_instances_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="locker_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="mutex_classes_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="mutex_instances_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="rwlock_classes_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="rwlock_instances_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="table_handles_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="table_instances_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="thread_classes_lost"} 0
mysql_global_status_performance_schema_lost_total{instrumentation="thread_instances_lost"} 0
# HELP mysql_global_status_prepared_stmt_count Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_prepared_stmt_count untyped
mysql_global_status_prepared_stmt_count 0
# HELP mysql_global_status_qcache_free_blocks Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_free_blocks untyped
mysql_global_status_qcache_free_blocks 0
# HELP mysql_global_status_qcache_free_memory Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_free_memory untyped
mysql_global_status_qcache_free_memory 0
# HELP mysql_global_status_qcache_hits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_hits untyped
mysql_global_status_qcache_hits 0
# HELP mysql_global_status_qcache_inserts Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_inserts untyped
mysql_global_status_qcache_inserts 0
# HELP mysql_global_status_qcache_lowmem_prunes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_lowmem_prunes untyped
mysql_global_status_qcache_lowmem_prunes 0
# HELP mysql_global_status_qcache_not_cached Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_not_cached untyped
mysql_global_status_qcache_not_cached 0
# HELP mysql_global_status_qcache_queries_in_cache Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_queries_in_cache untyped
mysql_global_status_qcache_queries_in_cache 0
# HELP mysql_global_status_qcache_total_blocks Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_qcache_total_blocks untyped
mysql_global_status_qcache_total_blocks 0
# HELP mysql_global_status_queries Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_queries untyped
mysql_global_status_queries 1317
# HELP mysql_global_status_questions Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_questions untyped
mysql_global_status_questions 1316
# HELP mysql_global_status_rows_read Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_rows_read untyped
mysql_global_status_rows_read 0
# HELP mysql_global_status_rows_sent Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_rows_sent untyped
mysql_global_status_rows_sent 59143
# HELP mysql_global_status_rows_tmp_read Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_rows_tmp_read untyped
mysql_global_status_rows_tmp_read 220465
# HELP mysql_global_status_select_full_join Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_select_full_join untyped
mysql_global_status_select_full_join 69
# HELP mysql_global_status_select_full_range_join Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_select_full_range_join untyped
mysql_global_status_select_full_range_join 0
# HELP mysql_global_status_select_range Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_select_range untyped
mysql_global_status_select_range 0
# HELP mysql_global_status_select_range_check Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_select_range_check untyped
mysql_global_status_select_range_check 0
# HELP mysql_global_status_select_scan Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_select_scan untyped
mysql_global_status_select_scan 416
# HELP mysql_global_status_slave_heartbeat_period Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slave_heartbeat_period untyped
mysql_global_status_slave_heartbeat_period 0
# HELP mysql_global_status_slave_open_temp_tables Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slave_open_temp_tables untyped
mysql_global_status_slave_open_temp_tables 0
# HELP mysql_global_status_slave_received_heartbeats Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slave_received_heartbeats untyped
mysql_global_status_slave_received_heartbeats 0
# HELP mysql_global_status_slave_retried_transactions Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slave_retried_transactions untyped
mysql_global_status_slave_retried_transactions 0
# HELP mysql_global_status_slave_running Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slave_running untyped
mysql_global_status_slave_running 0
# HELP mysql_global_status_slow_launch_threads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slow_launch_threads untyped
mysql_global_status_slow_launch_threads 0
# HELP mysql_global_status_slow_queries Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_slow_queries untyped
mysql_global_status_slow_queries 2
# HELP mysql_global_status_sort_merge_passes Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_sort_merge_passes untyped
mysql_global_status_sort_merge_passes 0
# HELP mysql_global_status_sort_range Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_sort_range untyped
mysql_global_status_sort_range 0
# HELP mysql_global_status_sort_rows Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_sort_rows untyped
mysql_global_status_sort_rows 0
# HELP mysql_global_status_sort_scan Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_sort_scan untyped
mysql_global_status_sort_scan 0
# HELP mysql_global_status_ssl_accept_renegotiates Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_accept_renegotiates untyped
mysql_global_status_ssl_accept_renegotiates 0
# HELP mysql_global_status_ssl_accepts Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_accepts untyped
mysql_global_status_ssl_accepts 0
# HELP mysql_global_status_ssl_callback_cache_hits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_callback_cache_hits untyped
mysql_global_status_ssl_callback_cache_hits 0
# HELP mysql_global_status_ssl_client_connects Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_client_connects untyped
mysql_global_status_ssl_client_connects 0
# HELP mysql_global_status_ssl_connect_renegotiates Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_connect_renegotiates untyped
mysql_global_status_ssl_connect_renegotiates 0
# HELP mysql_global_status_ssl_ctx_verify_depth Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_ctx_verify_depth untyped
mysql_global_status_ssl_ctx_verify_depth 0
# HELP mysql_global_status_ssl_ctx_verify_mode Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_ctx_verify_mode untyped
mysql_global_status_ssl_ctx_verify_mode 0
# HELP mysql_global_status_ssl_default_timeout Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_default_timeout untyped
mysql_global_status_ssl_default_timeout 0
# HELP mysql_global_status_ssl_finished_accepts Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_finished_accepts untyped
mysql_global_status_ssl_finished_accepts 0
# HELP mysql_global_status_ssl_finished_connects Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_finished_connects untyped
mysql_global_status_ssl_finished_connects 0
# HELP mysql_global_status_ssl_session_cache_hits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_session_cache_hits untyped
mysql_global_status_ssl_session_cache_hits 0
# HELP mysql_global_status_ssl_session_cache_misses Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_session_cache_misses untyped
mysql_global_status_ssl_session_cache_misses 0
# HELP mysql_global_status_ssl_session_cache_overflows Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_session_cache_overflows untyped
mysql_global_status_ssl_session_cache_overflows 0
# HELP mysql_global_status_ssl_session_cache_size Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_session_cache_size untyped
mysql_global_status_ssl_session_cache_size 0
# HELP mysql_global_status_ssl_session_cache_timeouts Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_session_cache_timeouts untyped
mysql_global_status_ssl_session_cache_timeouts 0
# HELP mysql_global_status_ssl_sessions_reused Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_sessions_reused untyped
mysql_global_status_ssl_sessions_reused 0
# HELP mysql_global_status_ssl_used_session_cache_entries Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_used_session_cache_entries untyped
mysql_global_status_ssl_used_session_cache_entries 0
# HELP mysql_global_status_ssl_verify_depth Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_verify_depth untyped
mysql_global_status_ssl_verify_depth 0
# HELP mysql_global_status_ssl_verify_mode Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_ssl_verify_mode untyped
mysql_global_status_ssl_verify_mode 0
# HELP mysql_global_status_subquery_cache_hit Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_subquery_cache_hit untyped
mysql_global_status_subquery_cache_hit 0
# HELP mysql_global_status_subquery_cache_miss Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_subquery_cache_miss untyped
mysql_global_status_subquery_cache_miss 0
# HELP mysql_global_status_syncs Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_syncs untyped
mysql_global_status_syncs 2
# HELP mysql_global_status_table_locks_immediate Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_table_locks_immediate untyped
mysql_global_status_table_locks_immediate 36
# HELP mysql_global_status_table_locks_waited Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_table_locks_waited untyped
mysql_global_status_table_locks_waited 0
# HELP mysql_global_status_tc_log_max_pages_used Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_tc_log_max_pages_used untyped
mysql_global_status_tc_log_max_pages_used 0
# HELP mysql_global_status_tc_log_page_size Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_tc_log_page_size untyped
mysql_global_status_tc_log_page_size 0
# HELP mysql_global_status_tc_log_page_waits Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_tc_log_page_waits untyped
mysql_global_status_tc_log_page_waits 0
# HELP mysql_global_status_threadpool_idle_threads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_threadpool_idle_threads untyped
mysql_global_status_threadpool_idle_threads 0
# HELP mysql_global_status_threadpool_threads Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_threadpool_threads untyped
mysql_global_status_threadpool_threads 0
# HELP mysql_global_status_threads_cached Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_threads_cached untyped
mysql_global_status_threads_cached 0
# HELP mysql_global_status_threads_connected Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_threads_connected untyped
mysql_global_status_threads_connected 1
# HELP mysql_global_status_threads_created Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_threads_created untyped
mysql_global_status_threads_created 188
# HELP mysql_global_status_threads_running Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_threads_running untyped
mysql_global_status_threads_running 1
# HELP mysql_global_status_uptime Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_uptime untyped
mysql_global_status_uptime 2408
# HELP mysql_global_status_uptime_since_flush_status Generic metric from SHOW GLOBAL STATUS.
# TYPE mysql_global_status_uptime_since_flush_status untyped
mysql_global_status_uptime_since_flush_status 2408
# HELP mysql_global_variables_aria_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_block_size gauge
mysql_global_variables_aria_block_size 8192
# HELP mysql_global_variables_aria_checkpoint_interval Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_checkpoint_interval gauge
mysql_global_variables_aria_checkpoint_interval 30
# HELP mysql_global_variables_aria_checkpoint_log_activity Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_checkpoint_log_activity gauge
mysql_global_variables_aria_checkpoint_log_activity 1.048576e+06
# HELP mysql_global_variables_aria_force_start_after_recovery_failures Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_force_start_after_recovery_failures gauge
mysql_global_variables_aria_force_start_after_recovery_failures 0
# HELP mysql_global_variables_aria_group_commit_interval Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_group_commit_interval gauge
mysql_global_variables_aria_group_commit_interval 0
# HELP mysql_global_variables_aria_log_file_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_log_file_size gauge
mysql_global_variables_aria_log_file_size 1.073741824e+09
# HELP mysql_global_variables_aria_max_sort_file_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_max_sort_file_size gauge
mysql_global_variables_aria_max_sort_file_size 9.223372036853727e+18
# HELP mysql_global_variables_aria_page_checksum Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_page_checksum gauge
mysql_global_variables_aria_page_checksum 1
# HELP mysql_global_variables_aria_pagecache_age_threshold Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_pagecache_age_threshold gauge
mysql_global_variables_aria_pagecache_age_threshold 300
# HELP mysql_global_variables_aria_pagecache_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_pagecache_buffer_size gauge
mysql_global_variables_aria_pagecache_buffer_size 1.34217728e+08
# HELP mysql_global_variables_aria_pagecache_division_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_pagecache_division_limit gauge
mysql_global_variables_aria_pagecache_division_limit 100
# HELP mysql_global_variables_aria_repair_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_repair_threads gauge
mysql_global_variables_aria_repair_threads 1
# HELP mysql_global_variables_aria_sort_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_sort_buffer_size gauge
mysql_global_variables_aria_sort_buffer_size 1.34217728e+08
# HELP mysql_global_variables_aria_used_for_temp_tables Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_aria_used_for_temp_tables gauge
mysql_global_variables_aria_used_for_temp_tables 1
# HELP mysql_global_variables_auto_increment_increment Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_auto_increment_increment gauge
mysql_global_variables_auto_increment_increment 1
# HELP mysql_global_variables_auto_increment_offset Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_auto_increment_offset gauge
mysql_global_variables_auto_increment_offset 1
# HELP mysql_global_variables_autocommit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_autocommit gauge
mysql_global_variables_autocommit 1
# HELP mysql_global_variables_automatic_sp_privileges Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_automatic_sp_privileges gauge
mysql_global_variables_automatic_sp_privileges 1
# HELP mysql_global_variables_back_log Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_back_log gauge
mysql_global_variables_back_log 50
# HELP mysql_global_variables_big_tables Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_big_tables gauge
mysql_global_variables_big_tables 0
# HELP mysql_global_variables_binlog_annotate_row_events Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_binlog_annotate_row_events gauge
mysql_global_variables_binlog_annotate_row_events 0
# HELP mysql_global_variables_binlog_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_binlog_cache_size gauge
mysql_global_variables_binlog_cache_size 32768
# HELP mysql_global_variables_binlog_direct_non_transactional_updates Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_binlog_direct_non_transactional_updates gauge
mysql_global_variables_binlog_direct_non_transactional_updates 0
# HELP mysql_global_variables_binlog_optimize_thread_scheduling Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_binlog_optimize_thread_scheduling gauge
mysql_global_variables_binlog_optimize_thread_scheduling 1
# HELP mysql_global_variables_binlog_stmt_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_binlog_stmt_cache_size gauge
mysql_global_variables_binlog_stmt_cache_size 32768
# HELP mysql_global_variables_bulk_insert_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_bulk_insert_buffer_size gauge
mysql_global_variables_bulk_insert_buffer_size 8.388608e+06
# HELP mysql_global_variables_connect_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_connect_timeout gauge
mysql_global_variables_connect_timeout 10
# HELP mysql_global_variables_deadlock_search_depth_long Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_deadlock_search_depth_long gauge
mysql_global_variables_deadlock_search_depth_long 15
# HELP mysql_global_variables_deadlock_search_depth_short Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_deadlock_search_depth_short gauge
mysql_global_variables_deadlock_search_depth_short 4
# HELP mysql_global_variables_deadlock_timeout_long Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_deadlock_timeout_long gauge
mysql_global_variables_deadlock_timeout_long 5e+07
# HELP mysql_global_variables_deadlock_timeout_short Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_deadlock_timeout_short gauge
mysql_global_variables_deadlock_timeout_short 10000
# HELP mysql_global_variables_debug_no_thread_alarm Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_debug_no_thread_alarm gauge
mysql_global_variables_debug_no_thread_alarm 0
# HELP mysql_global_variables_default_week_format Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_default_week_format gauge
mysql_global_variables_default_week_format 0
# HELP mysql_global_variables_delay_key_write Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_delay_key_write gauge
mysql_global_variables_delay_key_write 1
# HELP mysql_global_variables_delayed_insert_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_delayed_insert_limit gauge
mysql_global_variables_delayed_insert_limit 100
# HELP mysql_global_variables_delayed_insert_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_delayed_insert_timeout gauge
mysql_global_variables_delayed_insert_timeout 300
# HELP mysql_global_variables_delayed_queue_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_delayed_queue_size gauge
mysql_global_variables_delayed_queue_size 1000
# HELP mysql_global_variables_div_precision_increment Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_div_precision_increment gauge
mysql_global_variables_div_precision_increment 4
# HELP mysql_global_variables_engine_condition_pushdown Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_engine_condition_pushdown gauge
mysql_global_variables_engine_condition_pushdown 0
# HELP mysql_global_variables_event_scheduler Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_event_scheduler gauge
mysql_global_variables_event_scheduler 0
# HELP mysql_global_variables_expensive_subquery_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_expensive_subquery_limit gauge
mysql_global_variables_expensive_subquery_limit 100
# HELP mysql_global_variables_expire_logs_days Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_expire_logs_days gauge
mysql_global_variables_expire_logs_days 0
# HELP mysql_global_variables_extra_max_connections Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_extra_max_connections gauge
mysql_global_variables_extra_max_connections 1
# HELP mysql_global_variables_extra_port Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_extra_port gauge
mysql_global_variables_extra_port 0
# HELP mysql_global_variables_flush Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_flush gauge
mysql_global_variables_flush 0
# HELP mysql_global_variables_flush_time Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_flush_time gauge
mysql_global_variables_flush_time 0
# HELP mysql_global_variables_foreign_key_checks Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_foreign_key_checks gauge
mysql_global_variables_foreign_key_checks 1
# HELP mysql_global_variables_ft_max_word_len Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_ft_max_word_len gauge
mysql_global_variables_ft_max_word_len 84
# HELP mysql_global_variables_ft_min_word_len Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_ft_min_word_len gauge
mysql_global_variables_ft_min_word_len 4
# HELP mysql_global_variables_ft_query_expansion_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_ft_query_expansion_limit gauge
mysql_global_variables_ft_query_expansion_limit 20
# HELP mysql_global_variables_general_log Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_general_log gauge
mysql_global_variables_general_log 0
# HELP mysql_global_variables_group_concat_max_len Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_group_concat_max_len gauge
mysql_global_variables_group_concat_max_len 1024
# HELP mysql_global_variables_ignore_builtin_innodb Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_ignore_builtin_innodb gauge
mysql_global_variables_ignore_builtin_innodb 0
# HELP mysql_global_variables_innodb_adaptive_flushing Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_adaptive_flushing gauge
mysql_global_variables_innodb_adaptive_flushing 1
# HELP mysql_global_variables_innodb_adaptive_hash_index Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_adaptive_hash_index gauge
mysql_global_variables_innodb_adaptive_hash_index 1
# HELP mysql_global_variables_innodb_adaptive_hash_index_partitions Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_adaptive_hash_index_partitions gauge
mysql_global_variables_innodb_adaptive_hash_index_partitions 1
# HELP mysql_global_variables_innodb_additional_mem_pool_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_additional_mem_pool_size gauge
mysql_global_variables_innodb_additional_mem_pool_size 8.388608e+06
# HELP mysql_global_variables_innodb_autoextend_increment Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_autoextend_increment gauge
mysql_global_variables_innodb_autoextend_increment 8
# HELP mysql_global_variables_innodb_autoinc_lock_mode Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_autoinc_lock_mode gauge
mysql_global_variables_innodb_autoinc_lock_mode 1
# HELP mysql_global_variables_innodb_blocking_buffer_pool_restore Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_blocking_buffer_pool_restore gauge
mysql_global_variables_innodb_blocking_buffer_pool_restore 0
# HELP mysql_global_variables_innodb_buffer_pool_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_buffer_pool_instances gauge
mysql_global_variables_innodb_buffer_pool_instances 1
# HELP mysql_global_variables_innodb_buffer_pool_populate Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_buffer_pool_populate gauge
mysql_global_variables_innodb_buffer_pool_populate 0
# HELP mysql_global_variables_innodb_buffer_pool_restore_at_startup Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_buffer_pool_restore_at_startup gauge
mysql_global_variables_innodb_buffer_pool_restore_at_startup 0
# HELP mysql_global_variables_innodb_buffer_pool_shm_checksum Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_buffer_pool_shm_checksum gauge
mysql_global_variables_innodb_buffer_pool_shm_checksum 1
# HELP mysql_global_variables_innodb_buffer_pool_shm_key Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_buffer_pool_shm_key gauge
mysql_global_variables_innodb_buffer_pool_shm_key 0
# HELP mysql_global_variables_innodb_buffer_pool_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_buffer_pool_size gauge
mysql_global_variables_innodb_buffer_pool_size 1.34217728e+08
# HELP mysql_global_variables_innodb_checkpoint_age_target Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_checkpoint_age_target gauge
mysql_global_variables_innodb_checkpoint_age_target 0
# HELP mysql_global_variables_innodb_checksums Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_checksums gauge
mysql_global_variables_innodb_checksums 1
# HELP mysql_global_variables_innodb_commit_concurrency Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_commit_concurrency gauge
mysql_global_variables_innodb_commit_concurrency 0
# HELP mysql_global_variables_innodb_concurrency_tickets Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_concurrency_tickets gauge
mysql_global_variables_innodb_concurrency_tickets 500
# HELP mysql_global_variables_innodb_dict_size_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_dict_size_limit gauge
mysql_global_variables_innodb_dict_size_limit 0
# HELP mysql_global_variables_innodb_doublewrite Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_doublewrite gauge
mysql_global_variables_innodb_doublewrite 1
# HELP mysql_global_variables_innodb_fake_changes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_fake_changes gauge
mysql_global_variables_innodb_fake_changes 0
# HELP mysql_global_variables_innodb_fast_checksum Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_fast_checksum gauge
mysql_global_variables_innodb_fast_checksum 0
# HELP mysql_global_variables_innodb_fast_shutdown Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_fast_shutdown gauge
mysql_global_variables_innodb_fast_shutdown 1
# HELP mysql_global_variables_innodb_file_format_check Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_file_format_check gauge
mysql_global_variables_innodb_file_format_check 1
# HELP mysql_global_variables_innodb_file_per_table Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_file_per_table gauge
mysql_global_variables_innodb_file_per_table 0
# HELP mysql_global_variables_innodb_flush_log_at_trx_commit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_flush_log_at_trx_commit gauge
mysql_global_variables_innodb_flush_log_at_trx_commit 1
# HELP mysql_global_variables_innodb_force_load_corrupted Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_force_load_corrupted gauge
mysql_global_variables_innodb_force_load_corrupted 0
# HELP mysql_global_variables_innodb_force_recovery Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_force_recovery gauge
mysql_global_variables_innodb_force_recovery 0
# HELP mysql_global_variables_innodb_ibuf_accel_rate Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_ibuf_accel_rate gauge
mysql_global_variables_innodb_ibuf_accel_rate 100
# HELP mysql_global_variables_innodb_ibuf_active_contract Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_ibuf_active_contract gauge
mysql_global_variables_innodb_ibuf_active_contract 1
# HELP mysql_global_variables_innodb_ibuf_max_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_ibuf_max_size gauge
mysql_global_variables_innodb_ibuf_max_size 6.709248e+07
# HELP mysql_global_variables_innodb_import_table_from_xtrabackup Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_import_table_from_xtrabackup gauge
mysql_global_variables_innodb_import_table_from_xtrabackup 0
# HELP mysql_global_variables_innodb_io_capacity Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_io_capacity gauge
mysql_global_variables_innodb_io_capacity 200
# HELP mysql_global_variables_innodb_kill_idle_transaction Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_kill_idle_transaction gauge
mysql_global_variables_innodb_kill_idle_transaction 0
# HELP mysql_global_variables_innodb_large_prefix Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_large_prefix gauge
mysql_global_variables_innodb_large_prefix 0
# HELP mysql_global_variables_innodb_lazy_drop_table Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_lazy_drop_table gauge
mysql_global_variables_innodb_lazy_drop_table 0
# HELP mysql_global_variables_innodb_lock_wait_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_lock_wait_timeout gauge
mysql_global_variables_innodb_lock_wait_timeout 50
# HELP mysql_global_variables_innodb_locking_fake_changes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_locking_fake_changes gauge
mysql_global_variables_innodb_locking_fake_changes 1
# HELP mysql_global_variables_innodb_locks_unsafe_for_binlog Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_locks_unsafe_for_binlog gauge
mysql_global_variables_innodb_locks_unsafe_for_binlog 0
# HELP mysql_global_variables_innodb_log_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_log_block_size gauge
mysql_global_variables_innodb_log_block_size 512
# HELP mysql_global_variables_innodb_log_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_log_buffer_size gauge
mysql_global_variables_innodb_log_buffer_size 8.388608e+06
# HELP mysql_global_variables_innodb_log_file_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_log_file_size gauge
mysql_global_variables_innodb_log_file_size 5.24288e+06
# HELP mysql_global_variables_innodb_log_files_in_group Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_log_files_in_group gauge
mysql_global_variables_innodb_log_files_in_group 2
# HELP mysql_global_variables_innodb_max_bitmap_file_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_max_bitmap_file_size gauge
mysql_global_variables_innodb_max_bitmap_file_size 1.048576e+08
# HELP mysql_global_variables_innodb_max_changed_pages Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_max_changed_pages gauge
mysql_global_variables_innodb_max_changed_pages 1e+06
# HELP mysql_global_variables_innodb_max_dirty_pages_pct Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_max_dirty_pages_pct gauge
mysql_global_variables_innodb_max_dirty_pages_pct 75
# HELP mysql_global_variables_innodb_max_purge_lag Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_max_purge_lag gauge
mysql_global_variables_innodb_max_purge_lag 0
# HELP mysql_global_variables_innodb_merge_sort_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_merge_sort_block_size gauge
mysql_global_variables_innodb_merge_sort_block_size 1.048576e+06
# HELP mysql_global_variables_innodb_mirrored_log_groups Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_mirrored_log_groups gauge
mysql_global_variables_innodb_mirrored_log_groups 1
# HELP mysql_global_variables_innodb_old_blocks_pct Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_old_blocks_pct gauge
mysql_global_variables_innodb_old_blocks_pct 37
# HELP mysql_global_variables_innodb_old_blocks_time Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_old_blocks_time gauge
mysql_global_variables_innodb_old_blocks_time 0
# HELP mysql_global_variables_innodb_open_files Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_open_files gauge
mysql_global_variables_innodb_open_files 300
# HELP mysql_global_variables_innodb_page_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_page_size gauge
mysql_global_variables_innodb_page_size 16384
# HELP mysql_global_variables_innodb_print_all_deadlocks Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_print_all_deadlocks gauge
mysql_global_variables_innodb_print_all_deadlocks 0
# HELP mysql_global_variables_innodb_purge_batch_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_purge_batch_size gauge
mysql_global_variables_innodb_purge_batch_size 20
# HELP mysql_global_variables_innodb_purge_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_purge_threads gauge
mysql_global_variables_innodb_purge_threads 1
# HELP mysql_global_variables_innodb_random_read_ahead Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_random_read_ahead gauge
mysql_global_variables_innodb_random_read_ahead 0
# HELP mysql_global_variables_innodb_read_ahead_threshold Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_read_ahead_threshold gauge
mysql_global_variables_innodb_read_ahead_threshold 56
# HELP mysql_global_variables_innodb_read_io_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_read_io_threads gauge
mysql_global_variables_innodb_read_io_threads 4
# HELP mysql_global_variables_innodb_recovery_stats Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_recovery_stats gauge
mysql_global_variables_innodb_recovery_stats 0
# HELP mysql_global_variables_innodb_recovery_update_relay_log Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_recovery_update_relay_log gauge
mysql_global_variables_innodb_recovery_update_relay_log 0
# HELP mysql_global_variables_innodb_replication_delay Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_replication_delay gauge
mysql_global_variables_innodb_replication_delay 0
# HELP mysql_global_variables_innodb_rollback_on_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_rollback_on_timeout gauge
mysql_global_variables_innodb_rollback_on_timeout 0
# HELP mysql_global_variables_innodb_rollback_segments Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_rollback_segments gauge
mysql_global_variables_innodb_rollback_segments 128
# HELP mysql_global_variables_innodb_show_locks_held Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_show_locks_held gauge
mysql_global_variables_innodb_show_locks_held 10
# HELP mysql_global_variables_innodb_show_verbose_locks Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_show_verbose_locks gauge
mysql_global_variables_innodb_show_verbose_locks 0
# HELP mysql_global_variables_innodb_simulate_comp_failures Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_simulate_comp_failures gauge
mysql_global_variables_innodb_simulate_comp_failures 0
# HELP mysql_global_variables_innodb_spin_wait_delay Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_spin_wait_delay gauge
mysql_global_variables_innodb_spin_wait_delay 6
# HELP mysql_global_variables_innodb_stats_auto_update Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_stats_auto_update gauge
mysql_global_variables_innodb_stats_auto_update 1
# HELP mysql_global_variables_innodb_stats_modified_counter Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_stats_modified_counter gauge
mysql_global_variables_innodb_stats_modified_counter 0
# HELP mysql_global_variables_innodb_stats_on_metadata Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_stats_on_metadata gauge
mysql_global_variables_innodb_stats_on_metadata 1
# HELP mysql_global_variables_innodb_stats_sample_pages Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_stats_sample_pages gauge
mysql_global_variables_innodb_stats_sample_pages 8
# HELP mysql_global_variables_innodb_stats_traditional Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_stats_traditional gauge
mysql_global_variables_innodb_stats_traditional 1
# HELP mysql_global_variables_innodb_stats_update_need_lock Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_stats_update_need_lock gauge
mysql_global_variables_innodb_stats_update_need_lock 1
# HELP mysql_global_variables_innodb_strict_mode Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_strict_mode gauge
mysql_global_variables_innodb_strict_mode 0
# HELP mysql_global_variables_innodb_support_xa Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_support_xa gauge
mysql_global_variables_innodb_support_xa 1
# HELP mysql_global_variables_innodb_sync_spin_loops Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_sync_spin_loops gauge
mysql_global_variables_innodb_sync_spin_loops 30
# HELP mysql_global_variables_innodb_table_locks Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_table_locks gauge
mysql_global_variables_innodb_table_locks 1
# HELP mysql_global_variables_innodb_thread_concurrency Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_thread_concurrency gauge
mysql_global_variables_innodb_thread_concurrency 0
# HELP mysql_global_variables_innodb_thread_concurrency_timer_based Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_thread_concurrency_timer_based gauge
mysql_global_variables_innodb_thread_concurrency_timer_based 0
# HELP mysql_global_variables_innodb_thread_sleep_delay Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_thread_sleep_delay gauge
mysql_global_variables_innodb_thread_sleep_delay 10000
# HELP mysql_global_variables_innodb_track_changed_pages Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_track_changed_pages gauge
mysql_global_variables_innodb_track_changed_pages 0
# HELP mysql_global_variables_innodb_use_atomic_writes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_atomic_writes gauge
mysql_global_variables_innodb_use_atomic_writes 0
# HELP mysql_global_variables_innodb_use_fallocate Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_fallocate gauge
mysql_global_variables_innodb_use_fallocate 0
# HELP mysql_global_variables_innodb_use_global_flush_log_at_trx_commit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_global_flush_log_at_trx_commit gauge
mysql_global_variables_innodb_use_global_flush_log_at_trx_commit 1
# HELP mysql_global_variables_innodb_use_native_aio Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_native_aio gauge
mysql_global_variables_innodb_use_native_aio 1
# HELP mysql_global_variables_innodb_use_stacktrace Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_stacktrace gauge
mysql_global_variables_innodb_use_stacktrace 0
# HELP mysql_global_variables_innodb_use_sys_malloc Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_sys_malloc gauge
mysql_global_variables_innodb_use_sys_malloc 1
# HELP mysql_global_variables_innodb_use_sys_stats_table Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_use_sys_stats_table gauge
mysql_global_variables_innodb_use_sys_stats_table 0
# HELP mysql_global_variables_innodb_write_io_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_innodb_write_io_threads gauge
mysql_global_variables_innodb_write_io_threads 4
# HELP mysql_global_variables_interactive_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_interactive_timeout gauge
mysql_global_variables_interactive_timeout 28800
# HELP mysql_global_variables_join_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_join_buffer_size gauge
mysql_global_variables_join_buffer_size 131072
# HELP mysql_global_variables_join_buffer_space_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_join_buffer_space_limit gauge
mysql_global_variables_join_buffer_space_limit 2.097152e+06
# HELP mysql_global_variables_join_cache_level Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_join_cache_level gauge
mysql_global_variables_join_cache_level 2
# HELP mysql_global_variables_keep_files_on_create Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_keep_files_on_create gauge
mysql_global_variables_keep_files_on_create 0
# HELP mysql_global_variables_key_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_key_buffer_size gauge
mysql_global_variables_key_buffer_size 1.34217728e+08
# HELP mysql_global_variables_key_cache_age_threshold Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_key_cache_age_threshold gauge
mysql_global_variables_key_cache_age_threshold 300
# HELP mysql_global_variables_key_cache_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_key_cache_block_size gauge
mysql_global_variables_key_cache_block_size 1024
# HELP mysql_global_variables_key_cache_division_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_key_cache_division_limit gauge
mysql_global_variables_key_cache_division_limit 100
# HELP mysql_global_variables_key_cache_segments Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_key_cache_segments gauge
mysql_global_variables_key_cache_segments 0
# HELP mysql_global_variables_large_files_support Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_large_files_support gauge
mysql_global_variables_large_files_support 1
# HELP mysql_global_variables_large_page_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_large_page_size gauge
mysql_global_variables_large_page_size 0
# HELP mysql_global_variables_large_pages Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_large_pages gauge
mysql_global_variables_large_pages 0
# HELP mysql_global_variables_local_infile Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_local_infile gauge
mysql_global_variables_local_infile 1
# HELP mysql_global_variables_lock_wait_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_lock_wait_timeout gauge
mysql_global_variables_lock_wait_timeout 3.1536e+07
# HELP mysql_global_variables_locked_in_memory Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_locked_in_memory gauge
mysql_global_variables_locked_in_memory 0
# HELP mysql_global_variables_log Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log gauge
mysql_global_variables_log 0
# HELP mysql_global_variables_log_bin Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_bin gauge
mysql_global_variables_log_bin 0
# HELP mysql_global_variables_log_bin_trust_function_creators Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_bin_trust_function_creators gauge
mysql_global_variables_log_bin_trust_function_creators 0
# HELP mysql_global_variables_log_queries_not_using_indexes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_queries_not_using_indexes gauge
mysql_global_variables_log_queries_not_using_indexes 0
# HELP mysql_global_variables_log_slave_updates Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_slave_updates gauge
mysql_global_variables_log_slave_updates 0
# HELP mysql_global_variables_log_slow_queries Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_slow_queries gauge
mysql_global_variables_log_slow_queries 0
# HELP mysql_global_variables_log_slow_rate_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_slow_rate_limit gauge
mysql_global_variables_log_slow_rate_limit 1
# HELP mysql_global_variables_log_warnings Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_log_warnings gauge
mysql_global_variables_log_warnings 1
# HELP mysql_global_variables_long_query_time Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_long_query_time gauge
mysql_global_variables_long_query_time 10
# HELP mysql_global_variables_low_priority_updates Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_low_priority_updates gauge
mysql_global_variables_low_priority_updates 0
# HELP mysql_global_variables_lower_case_file_system Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_lower_case_file_system gauge
mysql_global_variables_lower_case_file_system 0
# HELP mysql_global_variables_lower_case_table_names Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_lower_case_table_names gauge
mysql_global_variables_lower_case_table_names 0
# HELP mysql_global_variables_master_verify_checksum Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_master_verify_checksum gauge
mysql_global_variables_master_verify_checksum 0
# HELP mysql_global_variables_max_allowed_packet Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_allowed_packet gauge
mysql_global_variables_max_allowed_packet 1.048576e+06
# HELP mysql_global_variables_max_binlog_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_binlog_cache_size gauge
mysql_global_variables_max_binlog_cache_size 1.8446744073709548e+19
# HELP mysql_global_variables_max_binlog_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_binlog_size gauge
mysql_global_variables_max_binlog_size 1.073741824e+09
# HELP mysql_global_variables_max_binlog_stmt_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_binlog_stmt_cache_size gauge
mysql_global_variables_max_binlog_stmt_cache_size 1.8446744073709548e+19
# HELP mysql_global_variables_max_connect_errors Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_connect_errors gauge
mysql_global_variables_max_connect_errors 10
# HELP mysql_global_variables_max_connections Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_connections gauge
mysql_global_variables_max_connections 151
# HELP mysql_global_variables_max_delayed_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_delayed_threads gauge
mysql_global_variables_max_delayed_threads 20
# HELP mysql_global_variables_max_error_count Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_error_count gauge
mysql_global_variables_max_error_count 64
# HELP mysql_global_variables_max_heap_table_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_heap_table_size gauge
mysql_global_variables_max_heap_table_size 1.6777216e+07
# HELP mysql_global_variables_max_insert_delayed_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_insert_delayed_threads gauge
mysql_global_variables_max_insert_delayed_threads 20
# HELP mysql_global_variables_max_join_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_join_size gauge
mysql_global_variables_max_join_size 1.8446744073709552e+19
# HELP mysql_global_variables_max_length_for_sort_data Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_length_for_sort_data gauge
mysql_global_variables_max_length_for_sort_data 1024
# HELP mysql_global_variables_max_long_data_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_long_data_size gauge
mysql_global_variables_max_long_data_size 1.048576e+06
# HELP mysql_global_variables_max_prepared_stmt_count Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_prepared_stmt_count gauge
mysql_global_variables_max_prepared_stmt_count 16382
# HELP mysql_global_variables_max_relay_log_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_relay_log_size gauge
mysql_global_variables_max_relay_log_size 0
# HELP mysql_global_variables_max_seeks_for_key Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_seeks_for_key gauge
mysql_global_variables_max_seeks_for_key 4.294967295e+09
# HELP mysql_global_variables_max_sort_length Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_sort_length gauge
mysql_global_variables_max_sort_length 1024
# HELP mysql_global_variables_max_sp_recursion_depth Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_sp_recursion_depth gauge
mysql_global_variables_max_sp_recursion_depth 0
# HELP mysql_global_variables_max_tmp_tables Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_tmp_tables gauge
mysql_global_variables_max_tmp_tables 32
# HELP mysql_global_variables_max_user_connections Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_user_connections gauge
mysql_global_variables_max_user_connections 0
# HELP mysql_global_variables_max_write_lock_count Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_max_write_lock_count gauge
mysql_global_variables_max_write_lock_count 4.294967295e+09
# HELP mysql_global_variables_metadata_locks_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_metadata_locks_cache_size gauge
mysql_global_variables_metadata_locks_cache_size 1024
# HELP mysql_global_variables_min_examined_row_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_min_examined_row_limit gauge
mysql_global_variables_min_examined_row_limit 0
# HELP mysql_global_variables_mrr_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_mrr_buffer_size gauge
mysql_global_variables_mrr_buffer_size 262144
# HELP mysql_global_variables_multi_range_count Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_multi_range_count gauge
mysql_global_variables_multi_range_count 256
# HELP mysql_global_variables_myisam_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_block_size gauge
mysql_global_variables_myisam_block_size 1024
# HELP mysql_global_variables_myisam_data_pointer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_data_pointer_size gauge
mysql_global_variables_myisam_data_pointer_size 6
# HELP mysql_global_variables_myisam_max_sort_file_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_max_sort_file_size gauge
mysql_global_variables_myisam_max_sort_file_size 9.223372036853727e+18
# HELP mysql_global_variables_myisam_mmap_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_mmap_size gauge
mysql_global_variables_myisam_mmap_size 1.8446744073709552e+19
# HELP mysql_global_variables_myisam_repair_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_repair_threads gauge
mysql_global_variables_myisam_repair_threads 1
# HELP mysql_global_variables_myisam_sort_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_sort_buffer_size gauge
mysql_global_variables_myisam_sort_buffer_size 8.388608e+06
# HELP mysql_global_variables_myisam_use_mmap Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_myisam_use_mmap gauge
mysql_global_variables_myisam_use_mmap 0
# HELP mysql_global_variables_net_buffer_length Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_net_buffer_length gauge
mysql_global_variables_net_buffer_length 16384
# HELP mysql_global_variables_net_read_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_net_read_timeout gauge
mysql_global_variables_net_read_timeout 30
# HELP mysql_global_variables_net_retry_count Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_net_retry_count gauge
mysql_global_variables_net_retry_count 10
# HELP mysql_global_variables_net_write_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_net_write_timeout gauge
mysql_global_variables_net_write_timeout 60
# HELP mysql_global_variables_old Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_old gauge
mysql_global_variables_old 0
# HELP mysql_global_variables_old_alter_table Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_old_alter_table gauge
mysql_global_variables_old_alter_table 0
# HELP mysql_global_variables_old_passwords Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_old_passwords gauge
mysql_global_variables_old_passwords 0
# HELP mysql_global_variables_open_files_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_open_files_limit gauge
mysql_global_variables_open_files_limit 1e+06
# HELP mysql_global_variables_optimizer_prune_level Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_optimizer_prune_level gauge
mysql_global_variables_optimizer_prune_level 1
# HELP mysql_global_variables_optimizer_search_depth Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_optimizer_search_depth gauge
mysql_global_variables_optimizer_search_depth 62
# HELP mysql_global_variables_performance_schema Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema gauge
mysql_global_variables_performance_schema 0
# HELP mysql_global_variables_performance_schema_events_waits_history_long_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_events_waits_history_long_size gauge
mysql_global_variables_performance_schema_events_waits_history_long_size 10000
# HELP mysql_global_variables_performance_schema_events_waits_history_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_events_waits_history_size gauge
mysql_global_variables_performance_schema_events_waits_history_size 10
# HELP mysql_global_variables_performance_schema_max_cond_classes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_cond_classes gauge
mysql_global_variables_performance_schema_max_cond_classes 80
# HELP mysql_global_variables_performance_schema_max_cond_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_cond_instances gauge
mysql_global_variables_performance_schema_max_cond_instances 1000
# HELP mysql_global_variables_performance_schema_max_file_classes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_file_classes gauge
mysql_global_variables_performance_schema_max_file_classes 50
# HELP mysql_global_variables_performance_schema_max_file_handles Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_file_handles gauge
mysql_global_variables_performance_schema_max_file_handles 32768
# HELP mysql_global_variables_performance_schema_max_file_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_file_instances gauge
mysql_global_variables_performance_schema_max_file_instances 10000
# HELP mysql_global_variables_performance_schema_max_mutex_classes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_mutex_classes gauge
mysql_global_variables_performance_schema_max_mutex_classes 200
# HELP mysql_global_variables_performance_schema_max_mutex_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_mutex_instances gauge
mysql_global_variables_performance_schema_max_mutex_instances 1e+06
# HELP mysql_global_variables_performance_schema_max_rwlock_classes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_rwlock_classes gauge
mysql_global_variables_performance_schema_max_rwlock_classes 30
# HELP mysql_global_variables_performance_schema_max_rwlock_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_rwlock_instances gauge
mysql_global_variables_performance_schema_max_rwlock_instances 1e+06
# HELP mysql_global_variables_performance_schema_max_table_handles Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_table_handles gauge
mysql_global_variables_performance_schema_max_table_handles 100000
# HELP mysql_global_variables_performance_schema_max_table_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_table_instances gauge
mysql_global_variables_performance_schema_max_table_instances 50000
# HELP mysql_global_variables_performance_schema_max_thread_classes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_thread_classes gauge
mysql_global_variables_performance_schema_max_thread_classes 50
# HELP mysql_global_variables_performance_schema_max_thread_instances Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_performance_schema_max_thread_instances gauge
mysql_global_variables_performance_schema_max_thread_instances 1000
# HELP mysql_global_variables_port Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_port gauge
mysql_global_variables_port 3306
# HELP mysql_global_variables_preload_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_preload_buffer_size gauge
mysql_global_variables_preload_buffer_size 32768
# HELP mysql_global_variables_profiling Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_profiling gauge
mysql_global_variables_profiling 0
# HELP mysql_global_variables_profiling_history_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_profiling_history_size gauge
mysql_global_variables_profiling_history_size 15
# HELP mysql_global_variables_progress_report_time Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_progress_report_time gauge
mysql_global_variables_progress_report_time 5
# HELP mysql_global_variables_protocol_version Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_protocol_version gauge
mysql_global_variables_protocol_version 10
# HELP mysql_global_variables_query_alloc_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_alloc_block_size gauge
mysql_global_variables_query_alloc_block_size 8192
# HELP mysql_global_variables_query_cache_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_cache_limit gauge
mysql_global_variables_query_cache_limit 1.048576e+06
# HELP mysql_global_variables_query_cache_min_res_unit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_cache_min_res_unit gauge
mysql_global_variables_query_cache_min_res_unit 4096
# HELP mysql_global_variables_query_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_cache_size gauge
mysql_global_variables_query_cache_size 0
# HELP mysql_global_variables_query_cache_strip_comments Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_cache_strip_comments gauge
mysql_global_variables_query_cache_strip_comments 0
# HELP mysql_global_variables_query_cache_type Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_cache_type gauge
mysql_global_variables_query_cache_type 1
# HELP mysql_global_variables_query_cache_wlock_invalidate Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_cache_wlock_invalidate gauge
mysql_global_variables_query_cache_wlock_invalidate 0
# HELP mysql_global_variables_query_prealloc_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_query_prealloc_size gauge
mysql_global_variables_query_prealloc_size 8192
# HELP mysql_global_variables_range_alloc_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_range_alloc_block_size gauge
mysql_global_variables_range_alloc_block_size 4096
# HELP mysql_global_variables_read_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_read_buffer_size gauge
mysql_global_variables_read_buffer_size 131072
# HELP mysql_global_variables_read_only Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_read_only gauge
mysql_global_variables_read_only 0
# HELP mysql_global_variables_read_rnd_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_read_rnd_buffer_size gauge
mysql_global_variables_read_rnd_buffer_size 262144
# HELP mysql_global_variables_relay_log_purge Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_relay_log_purge gauge
mysql_global_variables_relay_log_purge 1
# HELP mysql_global_variables_relay_log_recovery Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_relay_log_recovery gauge
mysql_global_variables_relay_log_recovery 0
# HELP mysql_global_variables_relay_log_space_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_relay_log_space_limit gauge
mysql_global_variables_relay_log_space_limit 0
# HELP mysql_global_variables_replicate_annotate_row_events Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_replicate_annotate_row_events gauge
mysql_global_variables_replicate_annotate_row_events 0
# HELP mysql_global_variables_report_port Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_report_port gauge
mysql_global_variables_report_port 3306
# HELP mysql_global_variables_rowid_merge_buff_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_rowid_merge_buff_size gauge
mysql_global_variables_rowid_merge_buff_size 8.388608e+06
# HELP mysql_global_variables_rpl_recovery_rank Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_rpl_recovery_rank gauge
mysql_global_variables_rpl_recovery_rank 0
# HELP mysql_global_variables_secure_auth Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_secure_auth gauge
mysql_global_variables_secure_auth 0
# HELP mysql_global_variables_server_id Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_server_id gauge
mysql_global_variables_server_id 0
# HELP mysql_global_variables_skip_external_locking Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_skip_external_locking gauge
mysql_global_variables_skip_external_locking 1
# HELP mysql_global_variables_skip_name_resolve Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_skip_name_resolve gauge
mysql_global_variables_skip_name_resolve 0
# HELP mysql_global_variables_skip_networking Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_skip_networking gauge
mysql_global_variables_skip_networking 0
# HELP mysql_global_variables_skip_show_database Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_skip_show_database gauge
mysql_global_variables_skip_show_database 0
# HELP mysql_global_variables_slave_compressed_protocol Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slave_compressed_protocol gauge
mysql_global_variables_slave_compressed_protocol 0
# HELP mysql_global_variables_slave_max_allowed_packet Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slave_max_allowed_packet gauge
mysql_global_variables_slave_max_allowed_packet 1.073741824e+09
# HELP mysql_global_variables_slave_net_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slave_net_timeout gauge
mysql_global_variables_slave_net_timeout 3600
# HELP mysql_global_variables_slave_skip_errors Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slave_skip_errors gauge
mysql_global_variables_slave_skip_errors 0
# HELP mysql_global_variables_slave_sql_verify_checksum Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slave_sql_verify_checksum gauge
mysql_global_variables_slave_sql_verify_checksum 1
# HELP mysql_global_variables_slave_transaction_retries Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slave_transaction_retries gauge
mysql_global_variables_slave_transaction_retries 10
# HELP mysql_global_variables_slow_launch_time Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slow_launch_time gauge
mysql_global_variables_slow_launch_time 2
# HELP mysql_global_variables_slow_query_log Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_slow_query_log gauge
mysql_global_variables_slow_query_log 0
# HELP mysql_global_variables_sort_buffer_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sort_buffer_size gauge
mysql_global_variables_sort_buffer_size 2.097152e+06
# HELP mysql_global_variables_sql_auto_is_null Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_auto_is_null gauge
mysql_global_variables_sql_auto_is_null 0
# HELP mysql_global_variables_sql_big_selects Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_big_selects gauge
mysql_global_variables_sql_big_selects 1
# HELP mysql_global_variables_sql_big_tables Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_big_tables gauge
mysql_global_variables_sql_big_tables 0
# HELP mysql_global_variables_sql_buffer_result Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_buffer_result gauge
mysql_global_variables_sql_buffer_result 0
# HELP mysql_global_variables_sql_log_bin Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_log_bin gauge
mysql_global_variables_sql_log_bin 1
# HELP mysql_global_variables_sql_log_off Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_log_off gauge
mysql_global_variables_sql_log_off 0
# HELP mysql_global_variables_sql_low_priority_updates Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_low_priority_updates gauge
mysql_global_variables_sql_low_priority_updates 0
# HELP mysql_global_variables_sql_max_join_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_max_join_size gauge
mysql_global_variables_sql_max_join_size 1.8446744073709552e+19
# HELP mysql_global_variables_sql_notes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_notes gauge
mysql_global_variables_sql_notes 1
# HELP mysql_global_variables_sql_quote_show_create Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_quote_show_create gauge
mysql_global_variables_sql_quote_show_create 1
# HELP mysql_global_variables_sql_safe_updates Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_safe_updates gauge
mysql_global_variables_sql_safe_updates 0
# HELP mysql_global_variables_sql_select_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_select_limit gauge
mysql_global_variables_sql_select_limit 1.8446744073709552e+19
# HELP mysql_global_variables_sql_slave_skip_counter Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_slave_skip_counter gauge
mysql_global_variables_sql_slave_skip_counter 0
# HELP mysql_global_variables_sql_warnings Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sql_warnings gauge
mysql_global_variables_sql_warnings 0
# HELP mysql_global_variables_stored_program_cache Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_stored_program_cache gauge
mysql_global_variables_stored_program_cache 256
# HELP mysql_global_variables_sync_binlog Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sync_binlog gauge
mysql_global_variables_sync_binlog 0
# HELP mysql_global_variables_sync_frm Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sync_frm gauge
mysql_global_variables_sync_frm 1
# HELP mysql_global_variables_sync_master_info Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sync_master_info gauge
mysql_global_variables_sync_master_info 0
# HELP mysql_global_variables_sync_relay_log Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sync_relay_log gauge
mysql_global_variables_sync_relay_log 0
# HELP mysql_global_variables_sync_relay_log_info Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_sync_relay_log_info gauge
mysql_global_variables_sync_relay_log_info 0
# HELP mysql_global_variables_table_definition_cache Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_table_definition_cache gauge
mysql_global_variables_table_definition_cache 400
# HELP mysql_global_variables_table_open_cache Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_table_open_cache gauge
mysql_global_variables_table_open_cache 400
# HELP mysql_global_variables_thread_cache_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_cache_size gauge
mysql_global_variables_thread_cache_size 0
# HELP mysql_global_variables_thread_concurrency Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_concurrency gauge
mysql_global_variables_thread_concurrency 10
# HELP mysql_global_variables_thread_pool_idle_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_pool_idle_timeout gauge
mysql_global_variables_thread_pool_idle_timeout 60
# HELP mysql_global_variables_thread_pool_max_threads Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_pool_max_threads gauge
mysql_global_variables_thread_pool_max_threads 500
# HELP mysql_global_variables_thread_pool_oversubscribe Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_pool_oversubscribe gauge
mysql_global_variables_thread_pool_oversubscribe 3
# HELP mysql_global_variables_thread_pool_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_pool_size gauge
mysql_global_variables_thread_pool_size 1
# HELP mysql_global_variables_thread_pool_stall_limit Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_pool_stall_limit gauge
mysql_global_variables_thread_pool_stall_limit 500
# HELP mysql_global_variables_thread_stack Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_thread_stack gauge
mysql_global_variables_thread_stack 294912
# HELP mysql_global_variables_timed_mutexes Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_timed_mutexes gauge
mysql_global_variables_timed_mutexes 0
# HELP mysql_global_variables_tmp_table_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_tmp_table_size gauge
mysql_global_variables_tmp_table_size 1.6777216e+07
# HELP mysql_global_variables_transaction_alloc_block_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_transaction_alloc_block_size gauge
mysql_global_variables_transaction_alloc_block_size 8192
# HELP mysql_global_variables_transaction_prealloc_size Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_transaction_prealloc_size gauge
mysql_global_variables_transaction_prealloc_size 4096
# HELP mysql_global_variables_unique_checks Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_unique_checks gauge
mysql_global_variables_unique_checks 1
# HELP mysql_global_variables_userstat Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_userstat gauge
mysql_global_variables_userstat 0
# HELP mysql_global_variables_wait_timeout Generic gauge metric from SHOW GLOBAL VARIABLES.
# TYPE mysql_global_variables_wait_timeout gauge
mysql_global_variables_wait_timeout 28800
# HELP mysql_info_schema_auto_increment_column The current value of an auto_increment column from information_schema.
# TYPE mysql_info_schema_auto_increment_column gauge
mysql_info_schema_auto_increment_column{column="Time_zone_id",schema="mysql",table="time_zone"} 1
mysql_info_schema_auto_increment_column{column="id",schema="mydb",table="app02_author"} 1
mysql_info_schema_auto_increment_column{column="id",schema="mydb",table="app02_book"} 1
mysql_info_schema_auto_increment_column{column="id",schema="mydb",table="app02_book_authors"} 1
mysql_info_schema_auto_increment_column{column="id",schema="mydb",table="app02_publisher"} 1
mysql_info_schema_auto_increment_column{column="id",schema="mydb",table="django_migrations"} 2
mysql_info_schema_auto_increment_column{column="id",schema="test",table="authors"} 4
mysql_info_schema_auto_increment_column{column="id",schema="test",table="books"} 5
mysql_info_schema_auto_increment_column{column="id",schema="test",table="students"} 6
mysql_info_schema_auto_increment_column{column="id",schema="test",table="teachers"} 4
mysql_info_schema_auto_increment_column{column="id",schema="zabbix",table="proxy_autoreg_host"} 1
mysql_info_schema_auto_increment_column{column="id",schema="zabbix",table="proxy_dhistory"} 1
mysql_info_schema_auto_increment_column{column="id",schema="zabbix",table="proxy_history"} 1
# HELP mysql_info_schema_auto_increment_column_max The max value of an auto_increment column from information_schema.
# TYPE mysql_info_schema_auto_increment_column_max gauge
mysql_info_schema_auto_increment_column_max{column="Time_zone_id",schema="mysql",table="time_zone"} 4.294967295e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="mydb",table="app02_author"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="mydb",table="app02_book"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="mydb",table="app02_book_authors"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="mydb",table="app02_publisher"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="mydb",table="django_migrations"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="test",table="authors"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="test",table="books"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="test",table="students"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="test",table="teachers"} 2.147483647e+09
mysql_info_schema_auto_increment_column_max{column="id",schema="zabbix",table="proxy_autoreg_host"} 1.8446744073709552e+19
mysql_info_schema_auto_increment_column_max{column="id",schema="zabbix",table="proxy_dhistory"} 1.8446744073709552e+19
mysql_info_schema_auto_increment_column_max{column="id",schema="zabbix",table="proxy_history"} 1.8446744073709552e+19
# HELP mysql_info_schema_innodb_cmp_compress_ops_ok_total Number of times a B-tree page of the size PAGE_SIZE has been successfully compressed.
# TYPE mysql_info_schema_innodb_cmp_compress_ops_ok_total counter
mysql_info_schema_innodb_cmp_compress_ops_ok_total{page_size="1024"} 0
mysql_info_schema_innodb_cmp_compress_ops_ok_total{page_size="16384"} 0
mysql_info_schema_innodb_cmp_compress_ops_ok_total{page_size="2048"} 0
mysql_info_schema_innodb_cmp_compress_ops_ok_total{page_size="4096"} 0
mysql_info_schema_innodb_cmp_compress_ops_ok_total{page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmp_compress_ops_total Number of times a B-tree page of the size PAGE_SIZE has been compressed.
# TYPE mysql_info_schema_innodb_cmp_compress_ops_total counter
mysql_info_schema_innodb_cmp_compress_ops_total{page_size="1024"} 0
mysql_info_schema_innodb_cmp_compress_ops_total{page_size="16384"} 0
mysql_info_schema_innodb_cmp_compress_ops_total{page_size="2048"} 0
mysql_info_schema_innodb_cmp_compress_ops_total{page_size="4096"} 0
mysql_info_schema_innodb_cmp_compress_ops_total{page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmp_compress_time_seconds_total Total time in seconds spent in attempts to compress B-tree pages.
# TYPE mysql_info_schema_innodb_cmp_compress_time_seconds_total counter
mysql_info_schema_innodb_cmp_compress_time_seconds_total{page_size="1024"} 0
mysql_info_schema_innodb_cmp_compress_time_seconds_total{page_size="16384"} 0
mysql_info_schema_innodb_cmp_compress_time_seconds_total{page_size="2048"} 0
mysql_info_schema_innodb_cmp_compress_time_seconds_total{page_size="4096"} 0
mysql_info_schema_innodb_cmp_compress_time_seconds_total{page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmp_uncompress_ops_total Number of times a B-tree page of the size PAGE_SIZE has been uncompressed.
# TYPE mysql_info_schema_innodb_cmp_uncompress_ops_total counter
mysql_info_schema_innodb_cmp_uncompress_ops_total{page_size="1024"} 0
mysql_info_schema_innodb_cmp_uncompress_ops_total{page_size="16384"} 0
mysql_info_schema_innodb_cmp_uncompress_ops_total{page_size="2048"} 0
mysql_info_schema_innodb_cmp_uncompress_ops_total{page_size="4096"} 0
mysql_info_schema_innodb_cmp_uncompress_ops_total{page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmp_uncompress_time_seconds_total Total time in seconds spent in uncompressing B-tree pages.
# TYPE mysql_info_schema_innodb_cmp_uncompress_time_seconds_total counter
mysql_info_schema_innodb_cmp_uncompress_time_seconds_total{page_size="1024"} 0
mysql_info_schema_innodb_cmp_uncompress_time_seconds_total{page_size="16384"} 0
mysql_info_schema_innodb_cmp_uncompress_time_seconds_total{page_size="2048"} 0
mysql_info_schema_innodb_cmp_uncompress_time_seconds_total{page_size="4096"} 0
mysql_info_schema_innodb_cmp_uncompress_time_seconds_total{page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmpmem_pages_free_total Number of blocks of the size PAGE_SIZE that are currently available for allocation.
# TYPE mysql_info_schema_innodb_cmpmem_pages_free_total counter
mysql_info_schema_innodb_cmpmem_pages_free_total{buffer_pool="0",page_size="1024"} 0
mysql_info_schema_innodb_cmpmem_pages_free_total{buffer_pool="0",page_size="16384"} 0
mysql_info_schema_innodb_cmpmem_pages_free_total{buffer_pool="0",page_size="2048"} 0
mysql_info_schema_innodb_cmpmem_pages_free_total{buffer_pool="0",page_size="4096"} 0
mysql_info_schema_innodb_cmpmem_pages_free_total{buffer_pool="0",page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmpmem_pages_used_total Number of blocks of the size PAGE_SIZE that are currently in use.
# TYPE mysql_info_schema_innodb_cmpmem_pages_used_total counter
mysql_info_schema_innodb_cmpmem_pages_used_total{buffer_pool="0",page_size="1024"} 0
mysql_info_schema_innodb_cmpmem_pages_used_total{buffer_pool="0",page_size="16384"} 0
mysql_info_schema_innodb_cmpmem_pages_used_total{buffer_pool="0",page_size="2048"} 0
mysql_info_schema_innodb_cmpmem_pages_used_total{buffer_pool="0",page_size="4096"} 0
mysql_info_schema_innodb_cmpmem_pages_used_total{buffer_pool="0",page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmpmem_relocation_ops_total Number of times a block of the size PAGE_SIZE has been relocated.
# TYPE mysql_info_schema_innodb_cmpmem_relocation_ops_total counter
mysql_info_schema_innodb_cmpmem_relocation_ops_total{buffer_pool="0",page_size="1024"} 0
mysql_info_schema_innodb_cmpmem_relocation_ops_total{buffer_pool="0",page_size="16384"} 0
mysql_info_schema_innodb_cmpmem_relocation_ops_total{buffer_pool="0",page_size="2048"} 0
mysql_info_schema_innodb_cmpmem_relocation_ops_total{buffer_pool="0",page_size="4096"} 0
mysql_info_schema_innodb_cmpmem_relocation_ops_total{buffer_pool="0",page_size="8192"} 0
# HELP mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total Total time in seconds spent in relocating blocks.
# TYPE mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total counter
mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total{buffer_pool="0",page_size="1024"} 0
mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total{buffer_pool="0",page_size="16384"} 0
mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total{buffer_pool="0",page_size="2048"} 0
mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total{buffer_pool="0",page_size="4096"} 0
mysql_info_schema_innodb_cmpmem_relocation_time_seconds_total{buffer_pool="0",page_size="8192"} 0
# HELP mysql_info_schema_threads The number of threads (connections) split by current state.
# TYPE mysql_info_schema_threads gauge
mysql_info_schema_threads{state="after create"} 0
mysql_info_schema_threads{state="altering table"} 0
mysql_info_schema_threads{state="analyzing"} 0
mysql_info_schema_threads{state="checking permissions"} 0
mysql_info_schema_threads{state="checking table"} 0
mysql_info_schema_threads{state="cleaning up"} 0
mysql_info_schema_threads{state="closing tables"} 0
mysql_info_schema_threads{state="converting heap to myisam"} 0
mysql_info_schema_threads{state="copying to tmp table"} 0
mysql_info_schema_threads{state="creating sort index"} 0
mysql_info_schema_threads{state="creating table"} 0
mysql_info_schema_threads{state="creating tmp table"} 0
mysql_info_schema_threads{state="deleting"} 0
mysql_info_schema_threads{state="end"} 0
mysql_info_schema_threads{state="executing"} 0
mysql_info_schema_threads{state="execution of init_command"} 0
mysql_info_schema_threads{state="flushing tables"} 0
mysql_info_schema_threads{state="freeing items"} 0
mysql_info_schema_threads{state="fulltext initialization"} 0
mysql_info_schema_threads{state="idle"} 0
mysql_info_schema_threads{state="init"} 0
mysql_info_schema_threads{state="killed"} 0
mysql_info_schema_threads{state="logging slow query"} 0
mysql_info_schema_threads{state="login"} 0
mysql_info_schema_threads{state="manage keys"} 0
mysql_info_schema_threads{state="opening tables"} 0
mysql_info_schema_threads{state="optimizing"} 0
mysql_info_schema_threads{state="other"} 0
mysql_info_schema_threads{state="preparing"} 0
mysql_info_schema_threads{state="reading from net"} 0
mysql_info_schema_threads{state="removing duplicates"} 0
mysql_info_schema_threads{state="removing tmp table"} 0
mysql_info_schema_threads{state="reopen tables"} 0
mysql_info_schema_threads{state="repair by sorting"} 0
mysql_info_schema_threads{state="repair done"} 0
mysql_info_schema_threads{state="repair with keycache"} 0
mysql_info_schema_threads{state="replication master"} 0
mysql_info_schema_threads{state="rolling back"} 0
mysql_info_schema_threads{state="searching rows for update"} 0
mysql_info_schema_threads{state="sending data"} 0
mysql_info_schema_threads{state="sorting for group"} 0
mysql_info_schema_threads{state="sorting for order"} 0
mysql_info_schema_threads{state="sorting index"} 0
mysql_info_schema_threads{state="sorting result"} 0
mysql_info_schema_threads{state="statistics"} 0
mysql_info_schema_threads{state="updating"} 0
mysql_info_schema_threads{state="waiting for lock"} 0
mysql_info_schema_threads{state="waiting for table flush"} 0
mysql_info_schema_threads{state="waiting for tables"} 0
mysql_info_schema_threads{state="waiting on cond"} 0
mysql_info_schema_threads{state="writing to net"} 0
# HELP mysql_info_schema_threads_seconds The number of seconds threads (connections) have used split by current state.
# TYPE mysql_info_schema_threads_seconds gauge
mysql_info_schema_threads_seconds{state="after create"} 0
mysql_info_schema_threads_seconds{state="altering table"} 0
mysql_info_schema_threads_seconds{state="analyzing"} 0
mysql_info_schema_threads_seconds{state="checking permissions"} 0
mysql_info_schema_threads_seconds{state="checking table"} 0
mysql_info_schema_threads_seconds{state="cleaning up"} 0
mysql_info_schema_threads_seconds{state="closing tables"} 0
mysql_info_schema_threads_seconds{state="converting heap to myisam"} 0
mysql_info_schema_threads_seconds{state="copying to tmp table"} 0
mysql_info_schema_threads_seconds{state="creating sort index"} 0
mysql_info_schema_threads_seconds{state="creating table"} 0
mysql_info_schema_threads_seconds{state="creating tmp table"} 0
mysql_info_schema_threads_seconds{state="deleting"} 0
mysql_info_schema_threads_seconds{state="end"} 0
mysql_info_schema_threads_seconds{state="executing"} 0
mysql_info_schema_threads_seconds{state="execution of init_command"} 0
mysql_info_schema_threads_seconds{state="flushing tables"} 0
mysql_info_schema_threads_seconds{state="freeing items"} 0
mysql_info_schema_threads_seconds{state="fulltext initialization"} 0
mysql_info_schema_threads_seconds{state="idle"} 0
mysql_info_schema_threads_seconds{state="init"} 0
mysql_info_schema_threads_seconds{state="killed"} 0
mysql_info_schema_threads_seconds{state="logging slow query"} 0
mysql_info_schema_threads_seconds{state="login"} 0
mysql_info_schema_threads_seconds{state="manage keys"} 0
mysql_info_schema_threads_seconds{state="opening tables"} 0
mysql_info_schema_threads_seconds{state="optimizing"} 0
mysql_info_schema_threads_seconds{state="other"} 0
mysql_info_schema_threads_seconds{state="preparing"} 0
mysql_info_schema_threads_seconds{state="reading from net"} 0
mysql_info_schema_threads_seconds{state="removing duplicates"} 0
mysql_info_schema_threads_seconds{state="removing tmp table"} 0
mysql_info_schema_threads_seconds{state="reopen tables"} 0
mysql_info_schema_threads_seconds{state="repair by sorting"} 0
mysql_info_schema_threads_seconds{state="repair done"} 0
mysql_info_schema_threads_seconds{state="repair with keycache"} 0
mysql_info_schema_threads_seconds{state="replication master"} 0
mysql_info_schema_threads_seconds{state="rolling back"} 0
mysql_info_schema_threads_seconds{state="searching rows for update"} 0
mysql_info_schema_threads_seconds{state="sending data"} 0
mysql_info_schema_threads_seconds{state="sorting for group"} 0
mysql_info_schema_threads_seconds{state="sorting for order"} 0
mysql_info_schema_threads_seconds{state="sorting index"} 0
mysql_info_schema_threads_seconds{state="sorting result"} 0
mysql_info_schema_threads_seconds{state="statistics"} 0
mysql_info_schema_threads_seconds{state="updating"} 0
mysql_info_schema_threads_seconds{state="waiting for lock"} 0
mysql_info_schema_threads_seconds{state="waiting for table flush"} 0
mysql_info_schema_threads_seconds{state="waiting for tables"} 0
mysql_info_schema_threads_seconds{state="waiting on cond"} 0
mysql_info_schema_threads_seconds{state="writing to net"} 0
# HELP mysql_up Whether the MySQL server is up.
# TYPE mysql_up gauge
mysql_up 1
# HELP mysql_version_info MySQL version and distribution.
# TYPE mysql_version_info gauge
mysql_version_info{innodb_version="5.5.59-MariaDB-38.11",version="5.5.60-MariaDB",version_comment="MariaDB Server"} 1
# 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.12.7",revision="48667bf7c3b438b5e93b259f3d17b70a7c9aff96",version="0.12.1"} 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 0.24
# HELP process_max_fds Maximum number of open file descriptors.
# TYPE process_max_fds gauge
process_max_fds 1e+06
# HELP process_open_fds Number of open file descriptors.
# TYPE process_open_fds gauge
process_open_fds 8
# HELP process_resident_memory_bytes Resident memory size in bytes.
# TYPE process_resident_memory_bytes gauge
process_resident_memory_bytes 1.1116544e+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.56749811275e+09
# HELP process_virtual_memory_bytes Virtual memory size in bytes.
# TYPE process_virtual_memory_bytes gauge
process_virtual_memory_bytes 1.16150272e+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
# 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"} 14
promhttp_metric_handler_requests_total{code="500"} 0
promhttp_metric_handler_requests_total{code="503"} 0
View Code

# curl localhost:9104/metrics | grep mysql_up
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 233k 100 233k 0 0 4322k 0 --:--:-- --:--:-- --:--:-- 4410k
# HELP mysql_up Whether the MySQL server is up.
# TYPE mysql_up gauge
mysql_up 1  #说明mysql启动,并且能正常监控到了

6,修改prometheus配置文件,scrape_configs下面添加

# vim /usr/local/prometheus/prometheus.yml
scrape_configs:
  - job_name: 'mysql'
    static_configs:
      - targets: ['localhost:9104']

 7,在界面可以看到mysql相关指标

 8,设置报警规则,可参考示例:https://github.com/prometheus/mysqld_exporter/blob/master/example.rules

groups:
- name: GaleraAlerts
  rules:
  - alert: MySQLReplicationNotRunning
    expr: mysql_slave_status_slave_io_running == 0 or mysql_slave_status_slave_sql_running
      == 0
    for: 2m
    labels:
      severity: critical
    annotations:
      description: Slave replication (IO or SQL) has been down for more than 2 minutes.
      summary: Slave replication is not running

 

posted @ 2019-09-06 16:54  卡布爱学习  阅读(15291)  评论(1编辑  收藏  举报