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

[vitachaos]

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

[j-ed]

@vitachaos

… and and would it be safe turn on innodb_strict_mode.

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:

Not that fast hdd's and 250mbps internet connection - i/o waits

Make sure that the database is on a separate physical disk. When sql is the bottle neck the rest will be slow too. Try adjusting InnoDB to tune it. Use mysqltuner script. This is a sample config I’m trying on an old 2 core 1.6ghz AMD e-350. Warning. Do not use O_DSYNC and doublewrite=0 unless you are using a journaling filsystem like btrfs… [mysqld] innodb_buffer_pool_size = 2G innodb_buffer_pool_instances = 2 innodb_file_per_table = 1 innodb_compression_algorithm = …

[vitachaos]

@Not that fast hdd's and 250mbps internet connection - i/o waits

Warning. Do not use O_DSYNC and doublewrite=0 unless you are using a journaling filsystem like btrfs…

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

[j-ed]

I think so, see: https://en.wikipedia.org/wiki/Ext4

[vitachaos]

indeed , I got exact answer here: https://www.percona.com/blog/2014/05/23/improve-innodb-performance-write-bound-loads/