maria-developers team mailing list archive

[Toshikuni Fukaya <toshikuni-fukaya@xxxxxxxxxxxx>]

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-fukaya@xxxxxxxxxxxx <mailto:toshikuni-fukaya@xxxxxxxxxxxx>>
> 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@xxxxxxxxxxxxxxxxxxx
>     <mailto:maria-developers@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~maria-developers
>     More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
> Mark Callaghan
> mdcallag@xxxxxxxxx <mailto:mdcallag@xxxxxxxxx>