>> Your MariaDB needs to be modified to enable this feature.
Thank you very much. I have already conducted performance testing by compiling mariadb on my own.
guoweikang@cmss.chinamobile.com
时 间: 2023/08/03(星期四)14:52
主题: Re: Inquiry about XFS Atomic Write and MariaDB Adaptation
On 2023/8/3 14:19, guoweikang wrote:
> Joseph Qi <mailto:Joseph Qi <joseph.qi@linux.alibaba.com>>:
> Hi,
> I hope this email finds you well. I am writing to seek some clarification regarding XFS Atomic Write and the adaptation of MariaDB. I have followed the instructions on the website you provided for enabling XFS Atomic Write, but I haven't seen any successful log entries on my local system.
>
> As mentioned in my previous email, I suspect that MariaDB might have some modifications for XFS 16K Atomic Write support. I have indeed found relevant information in the following repository: https://gitee.com/anolis/mariadb-server/commits/joseph/10.5-atomic-write <https://gitee.com/anolis/mariadb-server/commits/joseph/10.5-atomic-write>. It seems that the adaptation for MariaDB was added as part of your patch modifications.
Your MariaDB needs to be modified to enable this feature.
>
> Now, I have a few questions and uncertainties:
>
> 1. 1 Are these patches already merged into the mainline? Based on my investigation, I couldn't find any records of them being merged.
These patches won't be merged to the community mainline (either XFS or MariaDB), since:
1) XFS has their two own ways to do atomic write:
a) use atomic extent swap developped by Darrick;
https://lore.kernel.org/r/168506064947.3734442.7654653738998941813.stgit@frogsfrogsfrogs
b) use aligned extent way much like ext4 bigalloc, which is developped by another Oracle guy:
https://lore.kernel.org/r20230503183821.1473305-1-john.g.garry@oracle.com/
2) Our XFS Atomic Write is only landed on Anolis OS.
> 2. 2 Is there a possibility that the installation instructions in the provided guide for MariaDB are incorrect?
> 3. 3 Should I consider installing MariaDB from your joseph/10.5(3)-atomic-write branch to ensure proper XFS Atomic Write support?
I think if you use anolis os and follow the guide, it should work.
Thanks,
Gao Xiang
> 4.
>
>
> I apologize for any inconvenience, and I greatly appreciate your assistance in clarifying these matters. Thank you for your time and support.
>
> Best regards,
>
> guoweikang@cmss.chinamobile.com
>