Setting innodb_file_format from antelope to barracuda

ℹ️ Support
#1

Nextcloud version: 15.0.14
Operating system and version: Debian 9
Apache or nginx version Apache 2.4.25
PHP version 7.0.33
DB version: mariadb-server-10.1 (10.1.37)

Hi Support,
i’m starting to upgrading NC from 15.0.14 to the latest stable version.
In the last upgrade stage, NC let me to add support for 4 byte in MySQL.

My actual innodb_file_format is set as ‘Antelope’ .
Is not clear for my if I must run:

mysql> SET GLOBAL innodb_file_format=Barracuda;

or if follow literally each point of the MariaDB 10.2 or earlier doc, leaving out the above command.

Many thanks!

#2

Well Antelope is the default and as long as you don’t need the special features of Barracuda you don’t have to change.

#3

If I decide, do I have to execute the above command or is it not necessary for MariaDB?

Anyway, it seems that this error/warning will not allow me to upgrade to the next release, via web interface.

Thanks again!

#4

If you want to have it as default - yes.
Which means every new table will be Barracuda - file format
AND:
you have to change every old table that should have the new file format!

See this one
https://docs.nextcloud.com/server/18/admin_manual/configuration_database/mysql_4byte_support.html

#5

This is a good reason for do not change file format! :smiley:

What do you want to say me?
Does this have to do with the inability to upgrade?

Thanks again!

#6

These are the steps to perform the upgrade to 4byte support - so I think you should do it

#7

Excuse me, but I struggle to follow you :flushed:
What you mean is to follow the entire documentation, except for the command:

mysql> SET GLOBAL innodb_file_format=Barracuda;

Is it right?

Thanks again!

#8

No - I read it again and it says in the note at the beginning:
On some shared hosts, you may not have the permissions to upgrade the InnoDB file format, meaning you are unable to use utf8mb4
So you have to upgrade (MariadDB) if you want to upgrade (Nextcloud).

#9

Ah, ok.
But I’m using a VPS none shared hosts.
And I’m using MariadDB.
So you want to say that I should “migrate” to utf8mb4?

#10

Yes. It is needed for this Upgrade. Before it was not necessary.