Master Branch update MariaDB 10.1 & 10.2 default /etc/my.cnf default for innodb_def…

update MariaDB 10.1 & 10.2 default /etc/my.cnf default for innodb_default_row_format

- MariaDB 10.1.32 and MariaDB 10.2.2 and higher introduced a new variable for InnoDB which Oracle MySQL already supported for innodb_default_row_format https://mariadb.com/kb/en/library/xtradbinnodb-server-system-variables/#innodb_default_row_format. Prior to this MariaDB defaulted to innodb row format = COMPACT but MySQL 5.7.9 and MySQL 8.0 changed the defaults to DYNAMIC https://community.centminmod.com/posts/62934/.
- This update in Centmin Mod 123.09beta01 and newer branches sets in MariaDB 10.1 and 10.2 /etc/my.cnf the new variable which now changes the default row format for InnoDB tables from COMPACT to DYNAMIC, innodb_default_row_format = dynamic. This only applies to new Centmin Mod 123.09beta01 fresh installs so as to avoid any unforeseen changes to existing Centmin Mod user's MariaDB database tables. You can manually convert your InnoDB tables from ROW_FORMAT = COMPACT to ROW_FORMAT = DYNAMIC via ALTER TABLES command if needed. Basic example posted in gist at https://gist.github.com/centminmod/aec90a8594280b0697651e434fe22e00
- This update doesn't change the base my.cnf templates but instead at initial MariaDB install and MariaDB 10.1 and 10.2 upgrade times does an on the fly addition to existing /etc/my.cnf adding the value to [mariadb-10.1] or [mariadb-10.2] sections of /etc/myc.f for variable set as, innodb_default_row_format = dynamic. This allows for the variable to only apply to MariaDB 10.1 or 10.2 servers and not MariaDB 10.0 as the variable doesn't exist in version prior to MariaDB 10.1.32 or 10.2.2.

Continue reading...

Centmin Mod Github Master branch

Master branch is where most recent commits are made as at May 24, 2015.

• Branch: https://github.com/centminmod/centminmod
• Commit History: https://github.com/centminmod/centminmod/commits/master

---