bash - Sensu check for MySQL long running Queries. -


i need build test / checker ( ruby, python, bash , personal pref) check long running queries every few minutes. incorporate sensu, , alarm if threshold met. sensu able alarm ( or can set custom slack notifications )

honestly not sure start. looking how guys approach issue. great!

i can provide sample of used test other things on db if help.

you execute following queries in context of checker activate slow query log , read name of file logs slow query contents:

  1. activate slow query log file:

set global log_slow_queries = 'on';

  1. get path slow query file:

show global variables '%slow_query_log_file%'

you can monitor file slow queries.


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -