trying to run pto on a table that has ROW_FORMAT=fixed.
Mysql 5.6 used to silently convert to compact, but mysql 5.7 just straight up refuses to create a table in that format.
Unfortunately this means pto is unusable in tables like this. I am trying to remove all table definition row_formats where we have them (so it defaults to whatever is default for the version), but for that i need an alter, which i cannot run because pto cannot create the new table. I cannot run straight alter table commands as some tables are quite big and it will cause delays and cluster lock ups.
Any ideas how i can solve the issue? Hopefully other than going in and editing the pto script.
My only thought so far is that i can run pto through our proxysql and using the proxysql query rewriting features to force removal of the row_format clause on table creation when running pto. But that sounds too hacky.