Restrict maximum amount of queries shown in UI when MySQL event listener is used

[konovenski]

When MySQL event listener is used and queries are persistent, the UI selector allows you to pick between showing 20, 50, 100 and all queries. The "all" option is problematic in this case, since it will return full content of "select * from trino_queries". There should be an option to disable that setting, or it should just be disabled by default when using the event listener

[Praveen2112]

How about configuring query.max-history and query.min-expire-age to restrict the SELECT * FROM TRINO_QUERIES won't it reduce the load in the UI side ?

[konovenski]

@Praveen2112 default value of query.max-history is 100, and looks like it is not affecting the mysql database. From what i understand it is only related to the cases when trino stores the queries on coordinator, not when persistence is used. We want to have a full query retention, but the console should not output all of them