trx

The trx domain includes metrics about transactions.

Currently, the domain reports only one metric derived from Information Schema table innodb_trx: oldest. This is useful for monitoring and alerting on long-running transactions that might signal a problem.

This domain does not collect or report column values from INFORMATION_SCHEMA.INNODB_TRX. If these metrics are needed, please create an issue or submit a PR.

Future version might report other metrics or use Performance Schema tables to obtain transaction metrics.

Time of oldest active (still running) transaction in seconds, calculated as:

SELECT
  COALESCE(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(MIN(trx_started)), 0) t
FROM
  information_schema.innodb_trx;

None.

None.

None.

None.

None.