Re: [Koha] Large number of action_logs records

2023-08-31 Thread 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 evolve

Re: [Koha] [Koha-devel] needed help in koha cataloguing module

2023-08-31 Thread David Nind
Hi Zahid. From my limited knowledge, I think using setting up MARC overlay rules is what you would need to do. Happy for anyone who has setup these types of rules to comment on whether this is the best way to do what you want. The ByWater Solutions Team has a nice clear video about setting up th

Re: [Koha] Performance improvement suggestions

2023-08-31 Thread Furst, Kevin
After running the tuner and making some changes to my config, I believe the improvements are satisfactory for now. *Kevin Furst* Technology Director Pine River-Backus Schools o | 218.587.8030 @ | kfu...@prbschools.org Technology Office/Help Desk: 218-587-8510 *Confidentiality Notice: This E-mai

Re: [Koha] Performance improvement suggestions

2023-08-31 Thread Fridolin SOMERS
Please answer to the mailling list instead of me directly. Le 31/08/2023 à 03:11, Furst, Kevin a écrit : 1. Plack is enabled and running 2. Haven't run db tuner you suggested yet. Will look at it today. 3. Hardware is Intel Xeon E5520 8GB RAM  and (8) 2TB SSDs in a RAID. *Kevin Furst* Technolo

Re: [Koha] Large number of action_logs records

2023-08-31 Thread Coehoorn, Joel
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

Re: [Koha] Slow Item Edit Routines

2023-08-31 Thread Rudy Hinojosa
I only have 9 item types. I figured out what happened. My client is using a consortium, and discovered that 3 libraries were sharing an item type collectively, which is fine. However, there is a table called itemtype_branches that had 30k duplicates of this collection, and this was causing the

[Koha] Koha Community Newsletter: August 2023

2023-08-31 Thread Koha Newsletter
The Koha Community Newsletter for August 2023 is here: https://koha-community.org/koha-community-newsletter-august-2023/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Comm

Re: [Koha] Large number of action_logs records

2023-08-31 Thread Fridolin SOMERS
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

Re: [Koha] Large number of action_logs records

2023-08-31 Thread Jonathan Druart
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 a écrit : > > We're seeing a large quantity of records filling the action_logs table... > nearly 18,000