[Koha-devel] MariaDB and Auto Increment - it's the good news
David Cook
dcook at prosentient.com.au
Tue Mar 27 08:02:47 CEST 2018
Liz ftw
David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St
Ultimo, NSW 2007
Australia
Office: 02 9212 0899
Direct: 02 8005 0595
From: koha-devel-bounces at lists.koha-community.org [mailto:koha-devel-bounces at lists.koha-community.org] On Behalf Of Liz Rea
Sent: Tuesday, 27 March 2018 11:39 AM
To: koha-devel at lists.koha-community.org
Subject: [Koha-devel] MariaDB and Auto Increment - it's the good news
I was quite nosing around looking for something else, and came across this:
> Until MariaDB 10.2.3, InnoDB and XtraDB used an auto-increment counter that is stored in memory. When the server restarts, the counter is re-initialized to the highest value used in the table, which cancels the effects of any AUTO_INCREMENT = N option in the table statements.
Of course. We knew that. What we didn't know, possibly, was the following:
> From MariaDB 10.2.4, this restriction has been lifted and AUTO_INCREMENT is persistent.
Note that this isn't the current package version of mariadb-server for Debian 9, it's lagging behind a bit at 10.1.26. However, the days of auto increment issues, at least for MariaDB, may soon be coming to a close.
Information from: https://mariadb.com/kb/en/library/auto_increment/
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House,
150 Willis Street, Wellington.
P.O Box 11053, Manners Street,
Wellington 6142
04 803 2265
GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20180327/0d1bc903/attachment.html>
More information about the Koha-devel
mailing list