MariaDB healthcheck

MariaDB dashboard using ElasticSearch, metricbeat with mysql and sql (sql_response_format=table) modules.

MariaDB healthcheck screenshot 1
MariaDB healthcheck screenshot 2

MariaDB dashboard using MySQL module with status metrics. I used sql.yml module with sql_response_format=table as following:

  • module: sql metricsets:
    • query period: 10s hosts: ["<monitoring_user>:@tcp(:3306)/"] driver: “mysql” sql_query: “select * from information_schema.processlist” sql_response_format: table processors:
    • add_fields: fields: mariadb.alias: “local_instance:3306” # this may be useless, but i use it also in mysql module so I can group documents by mariadb.alias field
Revisions
RevisionDescriptionCreated

Get this dashboard

Import the dashboard template

or

Download JSON

Datasource
Dependencies