How to enable large index in MariaDB 10? : <p>In Debian Jessie I installed MariaDB server 10.0.30 and I try to increase max key length. AFAIU it depends of the config parameter <code>innodb_large_prefix</code> being enabled. According to the <a href="https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_large_prefix" rel="noreferrer">docs</a>, it also requires <code>barracuda</code> file format and <code>innodb_file_per_table</code>. After setting them in config and restarting server I see in client, that those parameters are set correctly:</p>

<pre><code>&gt; SHOW GLOBAL VARIABLES LIKE 'innodb_large%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| innodb_large_prefix | ON    |
+---------------------+-------+
1 row in set (0.00 sec)

&gt; SHOW GLOBAL VARIABLES LIKE 'innodb_file%';
+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| innodb_file_format       | Barracuda |
| innodb_file_format_check | OFF       |
| innodb_file_format_max   | Antelope  |
| innodb_file_per_table    | ON        |
+--------------------------+-----------+
4 rows in set (0.00 sec)

&gt; SHOW GLOBAL VARIABLES LIKE 'innodb_page%';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| innodb_page_size | 16384 |
+------------------+-------+
1 row in set (0.00 sec)
</code></pre>

<p>I am not sure, why <code>innodb_file_format_max</code> is set <code>Antelope</code>, but while <code>innodb_file_format_check</code> is OFF, it should not matter. Actually, even if I had it also set <code>Barracuda</code>, it did not made difference.</p>

<p>If i try now create table with large index like:</p>

<pre><code>CREATE TABLE `some_table` (
  `some_tableID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `column` varchar(750) COLLATE utf8mb4_estonian_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`some_tableID`),
  KEY `column` (`column`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci;
</code></pre>

<p>I get error:</p>

<pre><code>ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.
</code></pre>

<p>On Ubuntu 16.04 with mysql server 5.7.17 are all related settings same (by default) and there is no problem with large index (for utf8mb4 it is 750*4 = 3000).</p>

<p>What is wrong with my MariaDB setup?</p>
