<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>I was quite nosing around looking for something else, and came
across this:<br>
</p>
<pre id="pre"><code id="ciphertext" class="hljs coffeescript">> Until MariaDB <span class="hljs-number">10.2</span><span class="hljs-number">.3</span>, InnoDB <span class="hljs-keyword">and</span> XtraDB used an auto-increment counter that <span class="hljs-keyword">is</span> stored <span class="hljs-keyword">in</span> memory. When the server restarts, the counter <span class="hljs-keyword">is</span> re-initialized to the highest value used <span class="hljs-keyword">in</span> the table, which cancels the effects <span class="hljs-keyword">of</span> any AUTO_INCREMENT = N option <span class="hljs-keyword">in</span> the table statements.
</code><code id="ciphertext" class="hljs coffeescript"></code></pre>
<p>Of course. We knew that. What we didn't know, possibly, was the
following:<br>
</p>
<pre id="pre"><code id="ciphertext" class="hljs coffeescript">
</code><pre><code id="ciphertext" class="hljs coffeescript">> From MariaDB <span class="hljs-number">10.2</span><span class="hljs-number">.4</span>, <span class="hljs-keyword">this</span> restriction has been lifted <span class="hljs-keyword">and</span> AUTO_INCREMENT <span class="hljs-keyword">is</span> persistent.</code></pre><pre><code id="ciphertext" class="hljs coffeescript"></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="moz-txt-link-freetext" href="https://mariadb.com/kb/en/library/auto_increment/">https://mariadb.com/kb/en/library/auto_increment/</a></p>
<p><br>
</p>
--
<pre class="moz-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>
</body>
</html>