MySQL Overview With Telegraf

Dashboard

Dashboard from Percona Monitoring and Management project. Metrics include - Uptime - Qps - Tps - Connections - Network Traffic - Handlers - Open Files - Innodb Buffer Pool - Select Insert Update Delete Detail
Last updated: 5 days ago

Start with Grafana Cloud and the new FREE tier. Includes 10K series Prometheus or Graphite Metrics and 50gb Loki Logs

Downloads: 3

Reviews: 0

  • mysql_.jpg
    mysql_.jpg

telegraf ---> n9e server ---> prometheus ---> grafana

Metrics include

  • Uptime
  • Qps
  • Tps
  • Connections
  • Network Traffic
  • Handlers
  • Open Files
  • Innodb Buffer Pool
  • Select Insert Update Delete Detail

Collector Configuration Details

telegraf


[global_tags]

[agent]
  interval = "10s"
  round_interval = true
  metric_batch_size = 1000
  metric_buffer_limit = 10000
  collection_jitter = "0s"
  flush_interval = "10s"
  flush_jitter = "0s"
  precision = ""
  hostname = "###Your Ip Address or  Endpoint Name###"
  omit_hostname = false
  logfile = "/data/telegraf/var/log/telegraf/telegraf.log"

[[outputs.opentsdb]]
  host = "http://###Your n9e-server ip###" # n9e-server
  port = 19000
  http_batch_size = 50
  http_path = "/opentsdb/put"
  debug = false
  separator = "_"

[[inputs.cpu]]
  percpu = true
  totalcpu = true
  collect_cpu_time = false
  report_active = true

[[inputs.disk]]
  ignore_fs = ["tmpfs", "devtmpfs", "devfs", "iso9660", "overlay", "aufs", "squashfs"]

[[inputs.diskio]]

[[inputs.kernel]]

[[inputs.mem]]

[[inputs.processes]]

[[inputs.system]]
  fielddrop = ["uptime_format"]

[[inputs.net]]
  ignore_protocol_stats = true

[[inputs.linux_sysctl_fs]]

[[inputs.netstat]]


[[inputs.mysql]]
  servers = [
    "###Mysql-user###:###passwd###@tcp(###ip###:3306)/?tls=false", # test
    "###Mysql-user###:###passwd###@tcp(###ip###:3306)/?tls=false", # dev
    "###Mysql-user###:###passwd###@tcp(###ip###:3306)/?tls=false",  # uat
  ]
Get this dashboard:
16500