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