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@wikimedia.org
wrote:
On Mon, Apr 30, 2018 at 10:57 AM, Jaime Crespo jcrespo@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l