Add option to specify default row format

[monty solomon]

I would like to configure the server to use a default ROW FORMAT for newly created tables.

For example,

ROW_FORMAT=DYNAMIC;

or

ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

Please add the capability to specify a default row format.

Thanks.

[Valerii Kravchuk (valerii-kravchuk)]

Makes sense for the Wishlist

[monty solomon (monty+launchpad)]

DYNAMIC row format is now the default for MySQL 5.7.9 and there is a new configuration option, innodb_default_row_format,

https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-9.html

https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_default_row_format

[Laurynas Biveinis (laurynas-biveinis)]

Is 5.7.9 innodb_default_row_format good enough for your purposes or do you need innodb_default_key_block_size too?

[monty solomon (monty+launchpad)]

We use compressed row format and would prefer to be able to specify that as the default. I suspect that MySQL does not permit compressed to be specified as the default because compressed row format is not supported for the InnoDB tables in the mysql database.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2465