2 ms·
fwiw the limit is effectively 3072 bytes nowadays, default since MySQL 5.7. You could actually bump it up to 3072 in 5.5 and 5.6 too, but it required changing
by evanelias 5y ago
fwiw the limit is effectively 3072 bytes nowadays, default since MySQL 5.7.
You could actually bump it up to 3072 in 5.5 and 5.6 too, but it required changing several settings (innodb_large_prefix, innodb_file_format, innodb_file_per_table, and the table's ROW_FORMAT).
- chrismorgan 5y agoCool, didn’t know that; thanks for the correction. I haven’t touched MySQL since 2016, and I suppose what I worked with then wasn’t 5.7, or was configured differently for historical reasons, or something.