https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36569
Andreas Jonsson <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #164631|0 |1 is obsolete| | --- Comment #2 from Andreas Jonsson <[email protected]> --- Created attachment 164632 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=164632&action=edit Bug 36569: Compact action log/combined index With cataloguing logging enabled on the action_logs table it will become large. The module and action columns in action_logs are MEDIUMTEXT (max ~16 million bytes) with 196 first characters used for the index. Since these columns holds names that are only used programatically we could reduce the size of these columns to make the index more compact. Since module and action is often used together we can instead create a combined index and still have a smaller table. Test plan: * Start koha-testing-docker without patch applied (ku) * Apply patch * Run the command: sudo koha-upgrade-schema kohadev * Verify database schema: > sudo koha-mysql kohadev -t -e 'SHOW CREATE TABLE action_logs' | \ grep -E '`action`|`module`' The output should be (truncated long lines here): `module` varchar(30) CHARACTER SET ascii COLLATE ascii_general_ci ... `action` varchar(30) CHARACTER SET ascii COLLATE ascii_general_ci ... KEY `module_idx` (`module`), KEY `action_idx` (`action`), KEY `module_action_idx` (`module`,`action`), * Run unit test: prove t/db_dependent/Koha/ActionLogs.t * Stop koha-testing-docker and delete the containers (kd) * Start koha-testing-docker with patch applied * Verify database schema: > sudo koha-mysql kohadev -t -e 'SHOW CREATE TABLE action_logs' | \ grep -E '`action`|`module`' The output should be same as above -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ 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/
