<div dir="auto">Liz++ :D<div dir="auto"><br></div><div dir="auto"><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue 27 Mar, 2018, 6:09 AM Liz Rea, <<a href="mailto:liz@catalyst.net.nz">liz@catalyst.net.nz</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>I was quite nosing around looking for something else, and came
across this:<br>
</p>
<pre id="m_-9003950092877592640pre"><code id="m_-9003950092877592640ciphertext" class="m_-9003950092877592640hljs m_-9003950092877592640coffeescript">> Until MariaDB <span class="m_-9003950092877592640hljs-number">10.2</span><span class="m_-9003950092877592640hljs-number">.3</span>, InnoDB <span class="m_-9003950092877592640hljs-keyword">and</span> XtraDB used an auto-increment counter that <span class="m_-9003950092877592640hljs-keyword">is</span> stored <span class="m_-9003950092877592640hljs-keyword">in</span> memory. When the server restarts, the counter <span class="m_-9003950092877592640hljs-keyword">is</span> re-initialized to the highest value used <span class="m_-9003950092877592640hljs-keyword">in</span> the table, which cancels the effects <span class="m_-9003950092877592640hljs-keyword">of</span> any AUTO_INCREMENT = N option <span class="m_-9003950092877592640hljs-keyword">in</span> the table statements.
</code><code id="m_-9003950092877592640ciphertext" class="m_-9003950092877592640hljs m_-9003950092877592640coffeescript"></code></pre>
<p>Of course. We knew that. What we didn't know, possibly, was the
following:<br>
</p>
<pre id="m_-9003950092877592640pre"><code id="m_-9003950092877592640ciphertext" class="m_-9003950092877592640hljs m_-9003950092877592640coffeescript">
</code><pre><code id="m_-9003950092877592640ciphertext" class="m_-9003950092877592640hljs m_-9003950092877592640coffeescript">> From MariaDB <span class="m_-9003950092877592640hljs-number">10.2</span><span class="m_-9003950092877592640hljs-number">.4</span>, <span class="m_-9003950092877592640hljs-keyword">this</span> restriction has been lifted <span class="m_-9003950092877592640hljs-keyword">and</span> AUTO_INCREMENT <span class="m_-9003950092877592640hljs-keyword">is</span> persistent.</code></pre><pre><code id="m_-9003950092877592640ciphertext" class="m_-9003950092877592640hljs m_-9003950092877592640coffeescript"></code></pre></pre>
<br>
<p>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.</p>
<p>Information from:
<a class="m_-9003950092877592640moz-txt-link-freetext" href="https://mariadb.com/kb/en/library/auto_increment/" target="_blank" rel="noreferrer">https://mariadb.com/kb/en/library/auto_increment/</a></p>
<p><br>
</p>
--
<pre class="m_-9003950092877592640moz-signature" cols="72">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</pre>
</div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank" rel="noreferrer">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer noreferrer" target="_blank">http://bugs.koha-community.org/</a></blockquote></div>