Skip to content

Instantly share code, notes, and snippets.

@GroverChouT

GroverChouT/mariadb-max-key-error.md

Created November 18, 2020 16:18
Show Gist options
  • Save GroverChouT/9e7f72cf2415dbd8303ad91aacb9c3a7 to your computer and use it in GitHub Desktop.
Save GroverChouT/9e7f72cf2415dbd8303ad91aacb9c3a7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mariadb-max-key-error.md

MariaDB Max Key Length Error

Specified key was too long; max key length is 767 bytes

SET GLOBAL innodb_file_format = BARRACUDA;
SET GLOBAL innodb_file_per_table = ON;
SET GLOBAL innodb_large_prefix = ON;
SET GLOBAL innodb_default_row_format = 'DYNAMIC';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment