← All dashboards

Netdata: MySQL Overview

Detailed stats for MySQL (queries, cache, buffers, etc)

About dashboard

A dashboard with an overview for MySQL metrics:

  • Bandwidth, queries, connections
  • Handlers, queries by type
  • InnoDB (bandwidth, buffers, logs, locks, etc)
  • MyISAM (key cache requests, blocks, operations)
  • Replication stats (binlog, threads, delay)
  • Galera Cluster (writesets, queue, conflicts, flow control)
  • Query Cache (operations, queries, memory, blocks)
  • Threads, opened files, temp tables

More dashboards for Netdata you can find here.

How to use

Netdata setup

Follow these instructions to setup MySQL monitoring in Netdata.

Prometheus setup

Please note that you need Netdata as an exporter for metrics. Plus, these labels are mandatory:

  • job
  • env
  • instance
  • group
  • source

In your prometheus.yml it should look like this:

yaml
- job_name: netdata
  metrics_path: /api/v1/allmetrics?format=prometheus_all_hosts&source=raw
  relabel_configs:
  - source_labels: [__address__]
    regex: ^(.+)\.\w+:\d+
    target_label: instance
    action: replace
  static_configs:
  - targets: [netdata.hostname.here:19999]
    labels:
      env: production
      group: applications
      source: newproject

WARNING: Without these labels, this dashboard won’t be fully functioning.

License

GPL3

Author

OSSHelp Team, see https://oss.help

Dashboard revisions

RevisionDecscriptionCreated

Reviews

Login or Sign up to write a review

Reviews from the community

Get this dashboard

Data source:

Dependencies:

Import the dashboard template:

or

Download JSON

Docs: Importing dashboards

Downloads: 164