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 | jcoeho...@york.edu | york.edu On Thu, Aug 31, 2023 at 3:22 AM Fridolin SOMERS < fridolin.som...@biblibre.com> wrote: > Do you use 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 <jcoeho...@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 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 | jcoeho...@york.edu | york.edu > >> > >> *Please contact helpd...@york.edu <helpd...@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 > >> Koha@lists.katipo.co.nz > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > Fridolin SOMERS <fridolin.som...@biblibre.com> > Software and system maintainer 🦄 > BibLibre, France > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha