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) <[email protected] > wrote: > On Mon, Apr 30, 2018 at 10:57 AM, Jaime Crespo <[email protected]> > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > -- Jaime Crespo <http://wikimedia.org> _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
