mysql-list-active-queries

tools:
  list_active_queries:
    kind: mysql-list-active-queries
    source: my-mysql-instance
    description: Lists top N (default 10) ongoing queries from processlist and innodb_trx, ordered by execution time in descending order. Returns detailed information of those queries in json format, including process id, query, transaction duration, transaction wait duration, process time, transaction state, process state, username with host, transaction rows locked, transaction rows modified, and db schema.

{
  "proccess_id": "id of the MySQL process/connection this query belongs to",
  "query": "query text",
  "trx_started": "the time when the transaction (this query belongs to) started",
  "trx_duration_seconds": "the total elapsed time (in seconds) of the owning transaction so far",
  "trx_wait_duration_seconds": "the total wait time (in seconds) of the owning transaction so far",
  "query_time": "the time (in seconds) that the owning connection has been in its current state",
  "trx_state": "the transaction execution state",
  "proces_state": "the current state of the owning connection",
  "user": "the user who issued this query",
  "trx_rows_locked": "the approximate number of rows locked by the owning transaction",
  "trx_rows_modified": "the approximate number of rows modified by the owning transaction",
  "db": "the default database for the owning connection"
}