Use row_format=dynamic by default when creating a table #16834

see https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html

when creating a table can we specify the dynamic format like CREATE TABLE t1 (c1 INT) ROW_FORMAT=DYNAMIC;?

refs https://github.com/matomo-org/matomo/issues/16810 to avoid row size too large error.

We'd need to check that this works on all MySQL or not sure if we need to check whether dynamic row format is supported or whether some MySQL maybe don't support it.

Note: row format dynamic requires the same settings as utf8mb4... e.g innodb_file format=Barracuda and enabled innodb_file_per_table