Page 1 of 1

appgini_query_log

Posted: 2023-01-12 00:43
by rpierce
My database is filling up with appgini_query_log entries. It is generating a new record every 20 seconds or so. Is this a normal thing? At this time there are 168,135 records in this table. Should I delete them periodically or just ignore them?
Capture.JPG
appgini_query_log entries
Capture.JPG (25.2 KiB) Viewed 2883 times

Re: appgini_query_log

Posted: 2023-01-12 04:56
by jsetzer
Are you using latest version 22.14?

Re: appgini_query_log

Posted: 2023-01-13 04:39
by rpierce
Hi Jan,

I'm using 22.11

Re: appgini_query_log

Posted: 2023-01-13 08:54
by jsetzer
From changelog:

AppGini 22.12, Feb 24, 2022
...
Query logs page: show hint that logs older than x days are automatically cleaned up, with a button to clean up slow queries, and another for error queries.
...

And I remember in the first days of query logging feature, certain SQL commands related to database setup were logged regularly/repeatedly, although unnecessary. There was a change in a later version which drastically reduced the amount of errors being logged. But I don't remember the exact AG version nor can I find a changelog entry.

Hope this helps!

Re: appgini_query_log

Posted: 2023-01-13 17:33
by rpierce
Thank you Jan,

I'll get the newer version and see what happens.

Ray