[Koha-bugs] [Bug 32700] New: Action logs logging should be divided into smaller components to reduce table size

[bugzilla-daemon at bugs.koha-community.org]

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: koha-bugs at lists.koha-community.org
          Reporter: lmstrand at gmail.com
        QA Contact: testopia at bugs.koha-community.org

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.