Springle added a comment. Smaller fields are still better for performance, so I vote for a conservative 300, unless 400 is demonstrably needed.
Correct, 767 bytes (bytes, not characters) is the limit for a single InnoDB index with our current DB config, which is enough, and in any case with a config change[1], a policy change[2], and table rebuilds[3] that limit could be raised to 3072 bytes. [1] https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_large_prefix [2] We still claim MySQL 5.0.2 support for Mediawiki. [3] Needs InnoDB tables with barracuda file format. TASK DETAIL https://phabricator.wikimedia.org/T99459 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Springle Cc: Krenair, jcrespo, Springle, Lydia_Pintscher, aude, daniel, Aklapper, hoo, Wikidata-bugs _______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
