Add setup warning in case row_format=compressed is still used

[PVince81]

Since #30129 any new install of NC >= 24 will have row_format=dynamic with MariaDB.

Also, we saw reports where having "compressed" might negatively affect performance.

We should look into the following:

• add a setup check that verifies that all known tables have row_format=dynamic instead of compressed.
• if possible: add an occ command that migrates the tables to the new format. To be verified whether it's a quick thing or whether it can take hours for lots of data

@icewind1991 @juliushaertl @nickvergessen @CarlSchwan @szaimen

[nickvergessen]

if possible: add an occ command that migrates the tables to the new format. To be verified whether it's a quick thing or whether it can take hours for lots of data

We have that already as a repair step and it's also reachable via occ db:convert-mysql-charset ?
https://github.com/nextcloud/server/blob/master/lib/private/Repair/Collation.php#L82

Also your initial statement is wrong, every new install will NOT have compressed anymore, but dynamic.

[PVince81]

sorry, I typed it wrong. fixed now.

hmm, the command occ db:convert-mysql-charset seems a bit obscure.
but if it does the job then we could direct to it from the setup check then