This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| moodle:innodb [2017-09-08] – dcai | moodle:innodb [2020-04-19] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | < | ||
| + | SET GLOBAL innodb_file_format=Barracuda; | ||
| + | SET GLOBAL innodb_file_per_table=ON; | ||
| + | SET GLOBAL innodb_large_prefix=1; | ||
| + | logout & login (to get the global values); | ||
| + | ALTER TABLE tbl ROW_FORMAT=DYNAMIC; | ||
| + | </ | ||
| + | https:// | ||
| + | |||
| + | add to my.cnf | ||
| + | |||
| + | < | ||
| + | innodb_file_format=Barracuda | ||
| + | innodb_file_per_table=1 | ||
| + | innodb_large_prefix=1 | ||
| + | binlog_format=ROW | ||
| + | </ | ||