infrasonar / mysql-probe

InfraSonar MySQL probe

InfraSonar MySQL Probe

Documentation: https://docs.infrasonar.com/collectors/probes/mysql/

Environment variable

Variable	Default	Description
AGENTCORE_HOST	127.0.0.1	Hostname or Ip address of the AgentCore.
AGENTCORE_PORT	8750	AgentCore port to connect to.
INFRASONAR_CONF	/data/config/infrasonar.yaml	File with probe and asset configuration like credentials.
MAX_PACKAGE_SIZE	500	Maximum package size in kilobytes (1..2000).
MAX_CHECK_TIMEOUT	300	Check time-out is 80% of the interval time with MAX_CHECK_TIMEOUT in seconds as absolute maximum.
DRY_RUN	none	Do not run demonized, just return checks and assets specified in the given yaml (see the Dry run section below).
LOG_LEVEL	warning	Log level (debug, info, warning, error or critical).
LOG_COLORIZED	0	Log using colors (0=disabled, 1=enabled).
LOG_FTM	%y%m%d %H:%M:%S	Log format prefix.

Docker build

docker build -t mysql-probe . --no-cache

Dry run

Available checks:

• innodb
• mysql

Create a yaml file, for example (test.yaml):

asset:
  name: "foo.local"
  check: "mysql"
  config:
    address: "192.168.1.2"
    port: 3306  # not required, default MYSQL port is 3306

Run the probe with the DRY_RUN environment variable set the the yaml file above.

DRY_RUN=test.yaml python main.py

mysql-probe's Issues

Add metric `long_query_time` to `variables` type of `mysql` check

Is your feature request related to a problem? Please describe.
The slow_queries counter is depended in the long_query_time variable.

Therefore, it would be useful to have this metric available as well. Is is not an issue if the metric is stored in another type (variables) but within the same check can be helpful.

See:
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_long_query_time

Describe the solution you'd like
Add the metric to the variables type of the mysql check.