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
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp