[MDEV-9646] Allow setting default ROW_FORMAT (innodb_default_row_format) Created: 2016-02-27 Updated: 2017-03-09 Resolved: 2016-11-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Storage Engine - XtraDB |
| Fix Version/s: | 10.2.2 |
| Type: | Task | Priority: | Minor |
| Reporter: | Darrell Enns | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | innodb, upstream, xtradb | ||
| Issue Links: |
|
||||||||
| Description |
|
MySQL has a innodb_default_row_format sysvar which allows setting the default row format. This is useful in situations where innodb_large_prefix, as large prefixes don't work with COMPACT row format (which is the default). http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_default_row_format |
| Comments |
| Comment by BitSmid [ 2016-03-01 ] |
|
Especially with the new character encoding utf8mb4 (which contains emojis and is therefore preferred to store data from iPhones) the need to use innodb_large_prefix is even more pressing. The main solution now is to include "ROW_FORMAT=DYNAMIC" in all the table create statements, but that makes it impossible to build your SQL from separate files in standard libraries that have to be compatible with older systems. It would be nice to be able to set the default ROW_FORMAT at the start of a script and use table create statement without the ROW_FORMAT option. For example implementation of modular SQL, see https://www.howtoforge.com/tutorial/evolving-a-database-with-mysql/#modular-code . |
| Comment by Ian Gilfillan [ 2016-03-07 ] |
|
This is a subset of |
| Comment by Ian Gilfillan [ 2016-11-09 ] |
|
Done as part of |