[Koha-bugs] [Bug 28534] pending_offline_circulations table uses MyISAM engine

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

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

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|In Discussion               |Signed Off

--- Comment #12 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #9)
> 1. I would not modify the old DB rev
> 
> 2.
> There was a comment about that prior to
>   commit 8c5845ef9ecd92584723cd60a221ecd4710a2516
>   Bug 26947: Update kohastructure.sql
> 
> 
> -- this table is MyISAM, InnoDB tables are growing only and this table is
> filled/emptied/filled/emptied...
> -- so MyISAM is better in this case

tmp_holdsqueue is constantly filled/emptied and is InnoDB and has no issues

It seems the other problem of InnoDB is the resetting of auto_increment on a
restart, which we have handled and should not affect here

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