Hello! 👋
MariaDB's performance_schema.events_statements_summary_by_digest has a SUM_LOCK_TIME column, just like MySQL 8.0.28+.
It would be a nice little improvement to use that column to populate the mysql_events_statements_lock_time_seconds_total metric when scraping new-enough MariaDB servers.
This will need a new query - perfEventsStatementsQueryMySQL won't work as MariaDB doesn't have the SUM_CPU_TIME or QUANTILE_* columns. This may justify using SELECT * over that table and looking at which columns get returned instead.
This is something I'd be very happy to tackle myself when I get the time but would appreciate any ideas or gotchas before I do.
Hello! 👋
MariaDB's
performance_schema.events_statements_summary_by_digesthas aSUM_LOCK_TIMEcolumn, just like MySQL 8.0.28+.It would be a nice little improvement to use that column to populate the
mysql_events_statements_lock_time_seconds_totalmetric when scraping new-enough MariaDB servers.This will need a new query -
perfEventsStatementsQueryMySQLwon't work as MariaDB doesn't have theSUM_CPU_TIMEorQUANTILE_*columns. This may justify usingSELECT *over that table and looking at which columns get returned instead.This is something I'd be very happy to tackle myself when I get the time but would appreciate any ideas or gotchas before I do.