We want to save trino's query history for analysis and debugging. The simplest way to do this appears to be streaming the query events to a mysql database. Then we can use Trino to directly query the query history
docs are here
We want to save trino's query history for analysis and debugging. The simplest way to do this appears to be streaming the query events to a mysql database. Then we can use Trino to directly query the query history
docs are here
Hi @AStein-WMF, please associate one or more active project tags with this task (via the Add Action... → Change Project Tags dropdown). That will allow to see a task when looking at project workboards or searching for tasks in certain projects, and get notified about a task when watching a related project tag. Thanks.
@AStein-WMF I pushed up a branch T395338_trino_query_worker to puppet for your review. This should be the config elements needed for this but obviously needs testing in a working VB setup. With this config in place, it should create the trino_queries table in the database on start and then start logging data to that table.
the event listener has been implemented. there's a new trino database in mariadb. the trino_queries table stores the entire trino query history alongside data like execution plan, time taken, etc