Greetings! Got two questions;
1- I'm getting in mysql.log;
I'm on ZFS (FreeBSD) and I've read that I wouldn't need it because ZFS already does it. So, I set;
2- Does a combination of FreeBSD 13 + ZFS support:
Because I've been reading that, it should only be used with hardware and file systems that guarantees that 64K writes are atomic (and if you have specialized hardware and drivers to do that).
If not, why it comes enabled by default?
my server.cnf (settings for performance gain):
Many thanks.
1- I'm getting in mysql.log;
Code:
2021-11-04 11:19:12 0 [Warning] InnoDB: Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6.innodb_checksum_algorithm as none. Would that be any damage sooner or later?2- Does a combination of FreeBSD 13 + ZFS support:
innodb_use_atomic_writes=1 on MariaDB?Because I've been reading that, it should only be used with hardware and file systems that guarantees that 64K writes are atomic (and if you have specialized hardware and drivers to do that).
If not, why it comes enabled by default?
my server.cnf (settings for performance gain):
Code:
innodb_doublewrite = 0
innodb_flush_method = O_DSYNC
innodb_checksum_algorithm=none
innodb_log_write_ahead_size=16384
innodb_flush_neighbors=0
innodb_use_atomic_writes=0
innodb_read_io_threads = 10
innodb_write_io_threads = 10
innodb_fast_shutdown = 0Many thanks.
