topic MySQL General Query log filled with alf_transaction queries in Alfresco Forum

MySQL General Query log filled with alf_transaction queries

dkeidel — Tue, 04 Sep 2018 23:59:14 GMT

I turned on MySQL general logging to watch the logs when I poke around Alfresco. I am finding that the log is filled with queries such as the following: 17 Query select txn.id as id, txn.version as version, txn.change_txn_id as change_txn_id

Re: MySQL General Query log filled with alf_transaction queries

afaust — Wed, 05 Sep 2018 08:39:36 GMT

This is part of the index tracking of SOLR / Alfresco Search Services. It checks on a regular interval for updates in the database to reindex, and does so by checking for alf_transaction entries, which are used to group updates to nodes (documents / folders).

Re: MySQL General Query log filled with alf_transaction queries

dkeidel — Wed, 05 Sep 2018 19:43:52 GMT

Thank you Axel Faust. I am trying to look for queries in MySQL that are specific to the actions I am performing such as adding a document and these queries are fillin gup the general query log. I need to figure out a way to suppress these regular interval queries so that I can see only the ones of interest. Is there a way in Alfresco or MySQL to do that?

Re: MySQL General Query log filled with alf_transaction queries

afaust — Wed, 05 Sep 2018 21:28:25 GMT

Not sure about MySQL - I rarely ever use that anymore. The only way in Alfresco to suppress these queries would be to disable index tracking in SOLR (or not use SOLR at all).