maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #05069
Re: accelerating CREATE TABLE
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> 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
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchpad.net/ListHelp
>
>
--
Mark Callaghan
mdcallag@xxxxxxxxx
Follow ups
References