For large libraries, the query to gather pending notices from the message queue can take a very long time. ByWater's Rackpace DBA Mike was kind enough to do some work on this for us and found the issue. He recommends adding a simple index on the status column to fix this issue.
Created attachment 162503 [details] [review] Bug 36178: Add index for status on message queue table For large libraries, the query to gather pending notices from the message queue can take a very long time. ByWater's Rackpace DBA Mike was kind enough to do some work on this for us and found the issue. He recommends adding a simple index on the status column to fix this issue. Test Plan: 1) Apply this patch 2) Run updatedatabase.pl 3) SHOW CREATE TABLE message_queue should show the new index via koha-mysql
Mike Griffin at Rackspace was the originator of this suggested change. :D
Created attachment 162685 [details] [review] Bug 36178: Add index for status on message queue table For large libraries, the query to gather pending notices from the message queue can take a very long time. ByWater's Rackpace DBA Mike was kind enough to do some work on this for us and found the issue. He recommends adding a simple index on the status column to fix this issue. Test Plan: 1) Apply this patch 2) Run updatedatabase.pl 3) SHOW CREATE TABLE message_queue should show the new index via koha-mysql Signed-off-by: Andrew Fuerste Henry <andrewfh@dubcolib.org>
Weird condition: + unless ( index_exists( 'message_queue', 'language_subtag' ) ) { WARN installer/data/mysql/atomicupdate/bug_36178.pl WARN tidiness The file is less tidy than before (bad/messy lines before: 0, now: 2)