Documentation on MariaDB upgrade is outdated

[freakynl]

Hi,

the documentation for owncloud still says things have to be done with MariaDB >10.6.

This however is no longer true from what I can see. They decided to keep support for compressed rows.

So this: https://doc.owncloud.com/server/next/admin_manual/maintenance/upgrading/database_upgrade.html#upgrading-to-mariadb-10-6

no longer seems relevant unless the version is between >= 10.6.0 and <10.6.6. And between those versions it probably quicker to just set innodb_read_only_compressed to OFF than following instructions.

https://mariadb.com/kb/en/innodb-compressed-row-format/

Read-Only
MariaDB starting with 10.6
From MariaDB 10.6.0 until MariaDB 10.6.5, tables that are of the COMPRESSED row format are read-only by default. This was intended to be the first step towards removing write support and deprecating the feature.

This plan has been scrapped, and from MariaDB 10.6.6, COMPRESSED tables are no longer read-only by default.

From MariaDB 10.6.0 to MariaDB 10.6.5, set the innodb_read_only_compressed variable to OFF to make the tables writable.

[phil-davis]

I will have a look. I remember being involved in looking into this when MariaDB made this change in 10.6.0.