https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32700
Bug ID: 32700
Summary: Action logs logging should be divided into smaller
components to reduce table size
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
In Koha-Suomi our action_logs tables fill up with tens of millions rows of data
in one year. For example our Vaski-libraries had accumulated 800 000 entries in
one week.
To be able to manage this massive amount of data (cleanups/archiving) better,
Koha should save the actions to dedicated tables based on interface for
example. Currently we archive the action_logs table each year to archive tables
based on the year found on timestamps. If the data was split into smaller
tables based on interface we could better organize these cleanups.
The time it takes to make archived tables and reinserting newest entries back
to a clean active action_logs table would take far less time with invidual
action_log tables based on interface (action_logs_api etc.).
Also deciding the time of storage might be easier based on interface.
Moving millions of rows with massive time taking insert queries takes almost up
to a day for us and would eventually bring Koha to a halt.
Ps. After we moved to version 21.11 last year, the amount of data written to
action_logs has increased dramatically due to various logging settings we want
to have enabled.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
