MDEV-35609 requests Atomic writes. This would facilitate the development of MariaDB utilizing the latest available technology from the Linux Kernel.

Kernel Image (to save building one ourselves):

• Fedora Rawhide has a 6.13-rc2 kernel at the moment https://koji.fedoraproject.org/koji/packageinfo?packageID=8

As innovation will be in innodb a mtr of the innodb test suite is desired.

Tests to cover:

• xfs and ext4
• An 8k sector size and a 16k min atomic size should be able to cover 4k to 64k innodb pages sizes the the appropriate boundaries of each.

The scsi_debug module allows the construction of a fake capable atomic write

Instructions:

• https://lore.kernel.org/linux-fsdevel/20241106005740.GM2386201@frogsfrogsfrogs/
• scsi_debug uses ram - https://www.kernel.org/doc/html/v4.13/driver-api/scsi.html?highlight=scsi_debug#debug-transport
• reference manual: http://sg.danny.cz/sg/scsi_debug.html (seems 3 years out of date)
• "modinfo scsi_debug" for the latest

scsi_debug args:

• dev_size_mb=3600 (based on 2.3G observed during mysql-test/mtr --suite=innodb --parallel=16 --vardir=$(mktemp -d))
• atomic_rw - 1 (enable)
• sector_size=8192
• atomic_wr_align=2 (blocks of sector size so 16k)
• atomic_wr_gran=2 (blocks of sector size so 16k)