I've created
https://phabricator.wikimedia.org/T194125 No matter if we
enable innodb_large_preffix, migrate to binary only or reduce the maximum
size of indexes, there is work/migrations/installer changes/maintenance
needed for each of the possible solutions.
On Mon, Apr 30, 2018 at 5:18 PM, Brad Jorsch (Anomie) <bjorsch(a)wikimedia.org
wrote:
> On Mon, Apr 30, 2018 at 10:57 AM, Jaime Crespo <jcrespo(a)wikimedia.org>
wrote:
>
> > > MediaWiki currently doesn't even try to support UTF-8
> >
> > I thought the installer gave the option to chose between binary and utf8
> > 83-bytes)?
>
>
> Hmm. Yes, it looks like it does. But if all fields are varbinary, does it
> matter? Maybe it should be removed from the installer.
>
> There's also a $wgDBmysql5 configuration setting, which controls whether
> MediaWiki does "SET NAMES 'utf8'" or "SET NAMES
'binary'". I don't know
> what difference this makes, maybe none since all the columns are varbinary.
>
>
> > innodb_large_preffix cannot be enabled anymore because it is enabled
> > (hardcoded) automatically on MySQL 8.0.
> >
>
> That's good, once we raise the supported version that far. Currently it
> looks like we still support 5.5.8, which at least has the setting to
> enable.
>
> --
> Brad Jorsch (Anomie)
> Senior Software Engineer
> Wikimedia Foundation
> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>
--
Jaime Crespo
<http://wikimedia.org>