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 <z...@debian.org>