[Koha-devel] MySQL/MariaDB Auto-increment Persistence
David Cook
dcook at prosentient.com.au
Mon Jul 16 03:58:06 CEST 2018
Hi all,
This may or may not have already done the rounds, but I figure it doesn't
hurt to bring it up again, as I just learned about it, so maybe it will be
news to some of you still.
MariaDB 10.2.4 (from 17 Feb 2017) has "Persistent AUTO_INCREMENT for InnoDB
(MDEV-6076)".
MySQL 8.0 (I think maybe 8.0.1 from April 2017) has "the current maximum
auto-increment value is persisted, preventing the reuse of previously
allocated values."
(https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
).
I reckon this is great news, as I've found this particular issue to be a
perpetual thorn in my side.
David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St
Ultimo, NSW 2007
Australia
Office: 02 9212 0899
Direct: 02 8005 0595
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20180716/a1dcc78e/attachment.html>
More information about the Koha-devel
mailing list