Hi Mark, I tried to benchmark this patch on XFS. In this test, it showed similar result to using ext4:
Original MariaDB 5.5 trunk: 62.0 seconds (5 times avg.) Patched MariaDB 5.5 trunk: 32.6 seconds (5 times avg.) BTW, this results are total time of CREATE TABLEs, it is unclear whether any stalls had been happened. Thanks, Toshikuni Fukaya (2013/01/22 23:09), MARK CALLAGHAN wrote:
Can anyone provide results for XFS? The ext-2/3/4 variants that I used in the past were prone to stalls from sequential writes. On Tue, Jan 22, 2013 at 3:03 AM, Toshikuni Fukaya <toshikuni-fuk...@cybozu.co.jp <mailto:toshikuni-fuk...@cybozu.co.jp>> wrote: Hi, I made a patch to accelerate CREATE TABLE on the innodb plugin. To zero table spaces, I used fallocate instead of normal writes and sync. I compared MariaDB 5.5 trunk and the patched one by our own application, which creates > 1000 tables in series, with ext4 filesystem on Ubuntu 12.04. Results are shown below. Original MariaDB 5.5 trunk: 64.9 seconds (5 times avg.) Patched MariaDB 5.5 trunk: 36.0 seconds (5 times avg.) Any comments or suggestions? Thanks, Toshikuni Fukaya _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net <mailto:maria-developers@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp -- Mark Callaghan mdcal...@gmail.com <mailto:mdcal...@gmail.com>
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
