Roundcube Community Forum

 

Upgrade - DB Question

Started by l2kphil, June 18, 2024, 12:11:29 PM

Previous topic - Next topic

l2kphil

Hi All, first time posting here, glad to (virtually) meet you!

I'm in the throes of planning an upgrade from v1.3.9 to v1.6.7. I see in the UPGRADING notes the following comment:

QuoteWARNING: If you use MySQL < 5.7.7 or MariaDB < 10.2.2 make sure to configure it with:
            innodb_large_prefix=1
            innodb_file_per_table=1
            innodb_file_format=Barracuda

Does this *only* apply when using a version of MariaDB that is earlier than 10.2.2? My target system has MariaDB v10.5.22 installed and the global variables look like this:

QuoteMariaDB [(none)]> show global variables like "innodb_large%";
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| innodb_large_prefix |       |
+---------------------+-------+
1 row in set (0.001 sec)

MariaDB [(none)]> show global variables like "innodb_file%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_format    |       |
| innodb_file_per_table | ON    |
+-----------------------+-------+
2 rows in set (0.001 sec)

Do I need to change these to match the UPGRADING document or can I just leave at the default settings since I'm running a version > 10.2.2?