Good evening,
thanks for the links and instructions, but unfortunately still no success.
What I did:
mysql -u root -p
I changed all tables of database mattermost manually, because there are not really many tables.
MariaDB [(none)]> use mattermost;
MariaDB [(mattermost)]> ALTER TABLE <each table extra> ROW_FORMAT=DYNAMIC;
No error occurred and apparently only a few tables were changed.
Here is the recording:
MariaDB [mattermost]> ALTER TABLE Audits ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.50 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE ChannelMemberHistory ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE ChannelMembers ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.10 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Channels ROW_FORMAT=DYNAMIC;
Query OK, 100 rows affected (0.28 sec)
Records: 100 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE ClusterDiscovery ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE CommandWebhooks ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Commands ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Compliances ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Emoji ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE FileInfo ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.15 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE IncomingWebhooks ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Jobs ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Licenses ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE OAuthAccessData ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE OAuthApps ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE OAuthAuthData ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.12 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE OutgoingWebhooks ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE PluginKeyValueStore ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Posts ROW_FORMAT=DYNAMIC;
Query OK, 7059 rows affected (2.96 sec)
Records: 7059 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Preferences ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.17 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Reactions ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Roles ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Schemes ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Sessions ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Status ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Systems ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE TeamMembers ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Teams ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.17 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE UserAccessTokens ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mattermost]> ALTER TABLE Users ROW_FORMAT=DYNAMIC;
Query OK, 25 rows affected (0.47 sec)
Records: 25 Duplicates: 0 Warnings: 0