I am currently testing SQL in a container. I have attached a 6TB volume from XtremIO to this box and mapping my database directory to this volume(Partition name-/dev/sdb1). To get the optimal performance Microsoft have recommended to set the block size of the partition to 64K as per this-
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-performance-best-practices?view=sql-server-ver16
I have created XFS filesystem with the command on the partition
sudo mkfs.xfs -f -b size=64k /dev/sdb1
I can see that the partition is created and the block size is 64K, however I cannot mount this partition to any directory.(for example /mnt/xfs_mount) and its throwing an error like below-
# sudo mount /dev/sdb1 /mnt/xfs_mount
mount: /mnt/xfs_mount: mount(2) system call failed: Function not implemented.
# sudo mount -o bs=64k /dev/sdb1 /mnt/xfs_mount
mount: /mnt/xfs_mount: wrong fs type, bad option, bad superblock on /dev/sdb1, missing codepage or helper program, or other error.
When investigated, I found that the system does not support mounting a volume which has block size >4K but this was for the old Linux kernels(less than 2.0 or 3.0) however my kernel version is 5.15.0-72-generic and its still not able to mount this volume which has xfs filesystem already created which I have confirmed by fdisk -l and here is the output-
Disk /dev/sdb: 6 TiB, 6597069766656 bytes, 12884901888 sectors
Disk model: XtremApp
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 16384 bytes / 65536 bytes
Disklabel type: gpt
Disk identifier: D6FECC4B-F90F-C34E-8C63-D75E89809B7C
Device Start End Sectors Size Type
/dev/sdb1 2048 12884901854 12884899807 6T Linux filesystem
Can someone faced this issue? I cannot identify why the volume can not be mounted even if I have the latest kernel version and what are the changes I have to make to achieve this?
Thanks in advance