<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>OK, got it.</p>
<p>I adjusted the innodb page size to match the ssd raid block size:
4KB, and this lowered the key size proportionally to 768 bytes.<br>
After restoring default 16KB page size everything is ok.</p>
<p>Regards!<br>
WS<br>
</p>
<br>
<div class="moz-cite-prefix">W dniu 15.07.2018 o 15:34, Wojciech
Staszewski pisze:<br>
</div>
<blockquote type="cite"
cite="mid:ca300c54-4d94-5ca6-1274-1d3c5f20bfa4@diagnostyka.pl">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
Hello!<br>
<br>
Is MariaDB v 10.3.x supported by midPoint 3.8?<br>
<br>
I have a problem importing empty database structure in freshly
intalled environment:<br>
<br>
# mysql -p midpoint < mysql-3.8-all.sql<br>
Enter password: <br>
ERROR 1071 (42000) at line 178: Specified key was too long; max
key length is 768 bytes<br>
<br>
The MariaDB documentation says, that:<br>
<h4 class="anchored_heading" id="innodb_file_format"><code>innodb_default_row_format
= dynamic (default),<br>
innodb_large_prefix - removed in 10.3.1<br>
innodb_file_format = </code><code><code>Barracuda (default)</code></code></h4>
<p>So the max key length should be 3072 bytes by default.</p>
<p>System spec: CentOS 7 64bit, MariaDB 10.3.8<br>
Hardware: 2 x Intel(R) Xeon(R) Gold 5120 CPU @ 2.20GHz (56
cores+ht total), 256GB RAM, Hardware RAID 10 of 8xSSD for
database, separate HW raid for system.<br>
</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
</body>
</html>