[debian-mysql] Bug#848603: Enable innodb_large_prefix

[Christian Hofstaedtler]

Package: mariadb-server
Version: 10.0.28-2
Severity: serious

mariadb-server, the new default-mysql-server, breaks existing
well-functioning applications that need to index columns defined as
VARCHAR(255). This worked fine with mysql-server-5.6.

This is caused by two questionable choices:

  * default character set is utf8mb4 (causing index prefix lengths
    quadruple).
  * innodb_large_prefix is OFF.

I'd suggest you enable innodb_large_prefix or revert to what
mysql-server-5.6 did, i.e. set the character set to utf8 (which uses
"just" 3 bytes per character).

Thanks,
-- 
christian hofstaedtler <zeha at debian.org>