1. mysqld-exporter

  1. apiVersion: monitoring.coreos.com/v1
  2. kind: PrometheusRule
  3. metadata:
  4.   labels:
  5.     app: kube-prometheus-stack
  6.     app.kubernetes.io/instance: prometheus
  7.     release: prometheus
  8.   name: mysqld-exporter.rules
  9.   namespace: monitoring
  10. spec:
  11.   groups:
  12.     - name: mysql-exporter.rules
  13.       rules:
  14.         - record: mysql:uptime
  15.           expr: mysql_global_status_uptime{job="mariadb-galera-metrics"}
  16.         - record: mysql:com_insert
  17.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="insert"}
  18.         - record: mysql:com_set_option
  19.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="set_option"}
  20.         - record: mysql:com_show_variables
  21.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="show_variables"}
  22.         - record: mysql:com_show_status
  23.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="show_status"}
  24.         - record: mysql:com_admin_commands
  25.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="admin_commands"}
  26.         - record: mysql:com_begin
  27.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="begin"}
  28.         - record: mysql:com_commit
  29.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="commit"}
  30.         - record: mysql:com_update
  31.           expr: mysql_global_status_commands_total{job="mariadb-galera-metrics",command="update"}
  32.         - record: mysql:slow_queries
  33.           expr: mysql_global_status_slow_queries{job="mariadb-galera-metrics"}
  34.         - record: mysql:threads_connected
  35.           expr: mysql_global_status_threads_connected{job="mariadb-galera-metrics"}
  36.         - record: mysql:threads_running
  37.           expr: mysql_global_status_threads_running{job="mariadb-galera-metrics"}
  38.         - record: mysql:bytes_sent
  39.           expr: mysql_global_status_bytes_sent{job="mariadb-galera-metrics"}
  40.         - record: mysql:bytes_received
  41.           expr: mysql_global_status_bytes_received{job="mariadb-galera-metrics"}
  42.         - record: mysql:created_tmp_tables
  43.           expr: mysql_global_status_created_tmp_tables{job="mariadb-galera-metrics"}
  44.         - record: mysql:created_tmp_disk_tables
  45.           expr: mysql_global_status_created_tmp_disk_tables{job="mariadb-galera-metrics"}
  46.         - record: mysql:created_tmp_files
  47.           expr: mysql_global_status_created_tmp_files{job="mariadb-galera-metrics"}
  48.         - record: mysql:table_locks_immediate
  49.           expr: mysql_global_status_table_locks_immediate{job="mariadb-galera-metrics"}
  50.         - record: mysql:table_locks_waited
  51.           expr: mysql_global_status_table_locks_waited{job="mariadb-galera-metrics"}
  52.         - record: mysql:handler_commit
  53.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="commit"}
  54.         - record: mysql:handler_delete
  55.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="delete"}
  56.         - record: mysql:handler_discover
  57.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="discover"}
  58.         - record: mysql:handler_read_key
  59.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="read_key"}
  60.         - record: mysql:handler_read_rnd_next
  61.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="read_rnd_next"}
  62.         - record: mysql:handler_write
  63.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="write"}
  64.         - record: mysql:handler_update
  65.           expr: mysql_global_status_handlers_total{job="mariadb-galera-metrics",handler="update"}
  66.         - record: mysql:qcache_hits
  67.           expr: mysql_global_status_qcache_hits{job="mariadb-galera-metrics"}
  68.         - record: mysql:qcache_inserts
  69.           expr: mysql_global_status_qcache_inserts{job="mariadb-galera-metrics"}
  70.         - record: mysql:qcache_not_cached
  71.           expr: mysql_global_status_qcache_not_cached{job="mariadb-galera-metrics"}
  72.         - record: mysql:qcache_lowmem_prunes
  73.           expr: mysql_global_status_qcache_lowmem_prunes{job="mariadb-galera-metrics"}
  74.         - record: mysql:qcache_queries_in_cache
  75.           expr: mysql_global_status_qcache_queries_in_cache{job="mariadb-galera-metrics"}
  76.         - record: mysql:innodb_rows_inserted
  77.           expr: mysql_global_status_innodb_system_rows_inserted{job="mariadb-galera-metrics"}
  78.         - record: mysql:innodb_rows_read
  79.           expr: mysql_global_status_innodb_system_rows_read{job="mariadb-galera-metrics"}
  80.         - record: mysql:innodb_rows_deleted
  81.           expr: mysql_global_status_innodb_system_rows_deleted{job="mariadb-galera-metrics"}
  82.         - record: mysql:innodb_rows_updated
  83.           expr: mysql_global_status_innodb_system_rows_updated{job="mariadb-galera-metrics"}
  84.         - record: mysql_innodb:buffer_pool_read_requests
  85.           expr: mysql_global_status_innodb_buffer_pool_read_requests{job="mariadb-galera-metrics"}
  86.         - record: mysql_innodb:buffer_pool_write_requests
  87.           expr: mysql_global_status_innodb_buffer_pool_write_requests{job="mariadb-galera-metrics"}