[Koha-bugs] [Bug 32719] db_revs 210600001 can take a long time

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32719

Emmi Takkinen <emmi.takkinen at koha-suomi.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |emmi.takkinen at koha-suomi.fi

--- Comment #1 from Emmi Takkinen <emmi.takkinen at koha-suomi.fi> ---
If I have understood correctly, while DELETE is performed, deleted rows are
still kept in case of a rollback or crash (could be something else, here are
some reasons and tips I found: https://mariadb.com/kb/en/big-deletes/).

We faced similar problem while archiving our action_logs table. We ended up
renaming action_logs as work_action_logs and creating a new action_logs based
on it. Then after moving everything in archive table and back to action_logs
work_action_logs is dropped. Could something similar work here? Rename sessions
table e.g. drop_sessions -> create new sessions table -> drop renamed table ->
alter new sessions table.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.