How karthickarumugam/sensu-plugins-mysql works
Sensu-Plugins-mysql is a collection of command-line MySQL checks and metric collectors. Operators invoke a check or collector with connection settings (optionally read from an ini file); the tool queries MySQL and reports a check result or emits metrics. The README documents checks for availability, connections, disk, locks, replication, status, threads, and query counts, plus several metric formats. Sampled source confirms direct database queries and result handling for some tools; unsampled tools are included as documented capabilities, with their internal links left unasserted.
Main entry points: check-mysql-alive.rb Availability check · check-mysql-connections.rb Connections check · check-mysql-disk.rb Disk usage check · check-mysql-innodb-lock.rb InnoDB lock check
Components 19
Health checks
- Availability check
bin/check-mysql-alive.rb - Connections check
bin/check-mysql-connections.rb - Disk usage check
bin/check-mysql-disk.rb - InnoDB lock check
bin/check-mysql-innodb-lock.rb - Query count check
bin/check-mysql-query-result-count.rb - Replication check
bin/check-mysql-replication-status.rb - Status check
bin/check-mysql-status.rb - Threads check
bin/check-mysql-threads.rb
Metric collectors
- Status metrics
bin/metrics-mysql-graphite.rb - Process metrics
bin/metrics-mysql-processes.rb - Query count metric
bin/metrics-mysql-query-result-count.rb - Historic metrics
bin/metrics-mysql.rb
Raw metrics
- Raw metrics
bin/metrics-mysql-raw.rb - Metrics SQL
bin/mysql-metrics.sql
Other components
- Operator
- MySQL server
- Sensu check result
- Graphite metrics
- Historic metrics DB
Connections 38
- Operator → Availability check: runs
README.md - Operator → Connections check: runs
README.md - Operator → Disk usage check: runs
README.md - Operator → InnoDB lock check: runs
README.md - Operator → Query count check: runs
README.md - Operator → Replication check: runs
README.md - Operator → Status check: runs
README.md - Operator → Threads check: runs
README.md - Operator → Status metrics: runs
README.md - Operator → Process metrics: runs
README.md - Operator → Query count metric: runs
README.md - Operator → Historic metrics: runs
README.md - Operator → Raw metrics: runs
README.md - Availability check → MySQL server: queries
- Connections check → MySQL server: queries
- Disk usage check → MySQL server: queries
bin/check-mysql-disk.rb - InnoDB lock check → MySQL server: queries
bin/check-mysql-innodb-lock.rb - Query count check → MySQL server: queries
bin/check-mysql-query-result-count.rb - Replication check → MySQL server: queries
bin/check-mysql-replication-status.rb - Status check → MySQL server: queries
bin/check-mysql-status.rb - Threads check → MySQL server: queries
- Status metrics → MySQL server: queries
bin/metrics-mysql-graphite.rb - Process metrics → MySQL server: queries
bin/metrics-mysql-processes.rb - Query count metric → MySQL server: queries
bin/metrics-mysql-query-result-count.rb - Raw metrics → MySQL server: collects from
bin/metrics-mysql-raw.rb - Availability check → Sensu check result: reports status
- Connections check → Sensu check result: reports status
- Disk usage check → Sensu check result: reports status
bin/check-mysql-disk.rb - InnoDB lock check → Sensu check result: reports status
bin/check-mysql-innodb-lock.rb - Query count check → Sensu check result: reports status
bin/check-mysql-query-result-count.rb - Replication check → Sensu check result: reports status
bin/check-mysql-replication-status.rb - Status check → Sensu check result: reports status
bin/check-mysql-status.rb - Threads check → Sensu check result: reports status
- Status metrics → Graphite metrics: emits metrics
bin/metrics-mysql-graphite.rb - Process metrics → Graphite metrics: emits metrics
bin/metrics-mysql-processes.rb - Query count metric → Graphite metrics: emits metric
bin/metrics-mysql-query-result-count.rb - Historic metrics → Historic metrics DB: writes metrics
- Raw metrics → Graphite metrics: emits metrics
bin/metrics-mysql-raw.rb