Should I turn on innodb_strict_mode and add primary key to tables with no primary keys

I am using mariadb galera cluster of nextcloud database node across multple site,

should I alter oc_* tables without primary key to add a primary key field.
and and would it be safe turn on innodb_strict_mode.

Nextcloud version (eg, 18.0.2): 20.1.1
Operating system and version (eg, Ubuntu 20.04): 18.04
Apache (eg, Apache 2.4.25): 2.4
PHP version (eg, 7.1): 7.4

So far I haven’t faced any problem but I read on severalnines website but they were talking about percona XtraDB Cluster

I found this thread using the search function of this forum, in which a user reported that he has enabled the named parameter. Perhaps his hints to optimize the database access helps you too:

1 Like

so in my case the file system is ext4 ! does ext fall in the same category as btrfs ?

I think so, see:

indeed , I got exact answer here: