Can you force MariaDB to use MyISAM? There used to be a setting for that in the old my.cnf, but I can't find one in any of the current configuration files.


Rob

--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.

On Tue, 14 Nov 2017, Luka Cvetko wrote:

Hello,

I'm not a current Rivendell user, but know that this is a known limit of the 
InnoDB engine on MariaDB/MySQL <= 5.6 when dealing with utf8mb4 collations (I 
suppose your database is taht way since your list signature uses Cryrillic).

You may override the limit by setting
[mysqld]
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

But the limit is sane and it should be discussed if this particular table needs 
to be implemented with a lower key length (191 characters is a lot for a 
username, let alone 255) or added under MyISAM.

Kind regards,

--
Luka Cvetko
Presenter, Technical Operations and IT
Radio Študent, Svetčeva ulica 9, SI-1000 Ljubljana
[email protected] | +386 31 489 089

_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to