[Koha] Large number of action_logs records

[Fridolin SOMERS]

Hi,

You can use daily cron : cleanup_database.pl --logs DAYS

https://git.koha-community.org/Koha-community/Koha/src/branch/master/misc/cronjobs/cleanup_database.pl#L88

Le 31/08/2023 à 06:17, Coehoorn, Joel a écrit :
> I found the --incremental was missing. This is an installation that has 
> evolved since before 2016, so I suspect it predates that addition. I've 
> added it and am monitoring to see if growth is more reasonable.
> 
> What I may submit as a bug report or feature request is an option to 
> rotate these logs. So we'd add a background task to delete records older 
> than some reasonable (possibly configurable) number. This would keep the 
> table from growing indefinitely.
> 
> *Joel Coehoorn*
> Director of Information Technology
> *York University*
> Office: 402-363-5603 | jcoehoorn at york.edu <mailto:jcoehoorn at york.edu> | 
> york.edu <https://york.edu>
> 
> 
> 
> On Thu, Aug 31, 2023 at 3:22 AM Fridolin SOMERS 
> <fridolin.somers at biblibre.com <mailto:fridolin.somers at biblibre.com>> wrote:
> 
>     Do you use update_totalissues.pl <http://update_totalissues.pl> with
>     --incremental ?
> 
>     Le 30/08/2023 à 21:37, Jonathan Druart a écrit :
>      > Hi Joel,
>      >
>      > We could skip the logging when the biblio is modified by this
>     cronjob,
>      > please report this problem in a new bug report.
>      >
>      > Regards,
>      > Jonathan
>      >
>      > Le mar. 29 août 2023 à 21:22, Coehoorn, Joel <jcoehoorn at york.edu
>     <mailto:jcoehoorn at york.edu>> a écrit :
>      >>
>      >> We're seeing a large quantity of records filling the action_logs
>     table...
>      >> nearly 18,000 in the last 24 hours. This in turn uses a LOT of disk
>      >> space... it was briefly over 90GB until I intervened, and
>     because MySQL is
>      >> dumb about shrinking tables we were fortunate I caught it in time.
>      >>
>      >> It looks like the update_totalissues.pl
>     <http://update_totalissues.pl> script is running every night and
>      >> putting the entire biblio record into the info column in the
>     table for
>      >> every record we have.
>      >>
>      >> What could be causing this, and how can I stop it (without
>     disabling the
>      >> job completely, which I assume is part of Koha and important)?
>      >>
>      >> *Joel Coehoorn*
>      >> Director of Information Technology
>      >> *York University*
>      >> Office: 402-363-5603 | jcoehoorn at york.edu
>     <mailto:jcoehoorn at york.edu> | york.edu <http://york.edu>
>      >>
>      >> *Please contact helpdesk at york.edu <mailto:helpdesk at york.edu>
>     <helpdesk at york.edu <mailto:helpdesk at york.edu>> for technical
>      >> assistance.*
>      >>
>      >>
>      >> The mission of York University is to transform lives through
>      >> Christ-centered education and to equip students for lifelong
>     service to
>      >> God, family, and society
>      >> _______________________________________________
>      >>
>      >> Koha mailing list http://koha-community.org
>     <http://koha-community.org>
>      >> Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>      >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
>      > _______________________________________________
>      >
>      > Koha mailing list http://koha-community.org
>     <http://koha-community.org>
>      > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>      > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
> 
>     -- 
>     Fridolin SOMERS <fridolin.somers at biblibre.com
>     <mailto:fridolin.somers at biblibre.com>>
>     Software and system maintainer 🦄
>     BibLibre, France
>     _______________________________________________
> 
>     Koha mailing list http://koha-community.org <http://koha-community.org>
>     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
> 

-- 
Fridolin SOMERS <fridolin.somers at biblibre.com>
Software and system maintainer 🦄
BibLibre, France