Bug #58123 add variables to set defaults for row_format and key_block_size for new tables
Submitted: 10 Nov 2010 19:53 Modified: 12 Nov 2010 12:22
Reporter: Ben Krug Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[10 Nov 2010 19:53] Ben Krug 
Description:
Currently, when using barracuda, if a user wants row_format=compressed and a key_block_size other than 8k, they have to specify it for each new table.

Would like to be able to set system defaults for all new tables.  Eg, have default_row_format and a default_key_block_size variables.

How to repeat:
n/a

Suggested fix:
add system variables
[10 Nov 2010 21:33] Simon Mudd 
Or more precisely given the naming of innodb variables:

innodb_default_row_format
innodb_default_key_block_size
[22 Jan 2015 6:21] MySQL Verification Team 
Bug #75576 marked as duplicate of this
[12 Mar 2019 21:02] Mike Developer 
It is available to change default row format for innodb since MySQL 5.7.9 via directive innodb_default_row_format. See https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_default_row_f...