Enabling MySQL 4-byte support?

🚧 Installation
1

It ist described here how to configure it: https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html#mariadb-support

MariaDB 10.3 or later

  • Make sure the following InnoDB settings are set on your MariaDB server:

    [mysqld]
    innodb_file_per_table=1

Which file need to be edited? I couldn’t figure it out of the installation instruction.

2 
grep -r "\[mysqld\]" /etc/

will tell you.

1 Like
3

Thanks, it’s /etc/mysql/mariadb.conf.d/50-server.cnf in my case.

Why do they not provide that information at the installation instruction?

4

Practically, I believe quite some people still use mysql instead of mariadb, not to mention other variation and/or version that use different path and file name.

Reasonably, people doing this level of “hack” should know what they are doing and what they have done. No one will put [mysqld] into /etc/fstab, right?

5

In this case it is always a good idea to check the manual of the software you want to configure :wink:

https://mariadb.com/kb/en/library/configuring-mariadb-for-optimal-performance/