Re: [Maria-developers] accelerating CREATE TABLE

2013-02-18 Thread Toshikuni Fukaya
Hi Kristian, (2013/02/08 23:52), Kristian Nielsen wrote: Toshikuni Fukaya writes: 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. Thanks for your work. Today I took a closer look at the patch and the

Re: [Maria-developers] accelerating CREATE TABLE

2013-02-04 Thread Toshikuni Fukaya
Hi Kristian, Toshikuni Fukaya writes: I want to know whether this patch is correct, and if so, could I ask you to merge this to Maria? Sorry that we have not had time to get back to you. There is a lot going on at the moment, but the whole point of MariaDB is to be a place where the

Re: [Maria-developers] accelerating CREATE TABLE

2013-01-31 Thread Toshikuni Fukaya
Hi, I want to know whether this patch is correct, and if so, could I ask you to merge this to Maria? Could you review this? If there are any things I need to prepare for the review, please tell me. Please give me any comments. Thanks, Toshikuni Fukaya

Re: [Maria-developers] accelerating CREATE TABLE

2013-01-22 Thread Toshikuni Fukaya
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 mailto:toshikuni-fuk

[Maria-developers] accelerating CREATE TABLE

2013-01-22 Thread Toshikuni Fukaya
.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 # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: toshikuni-fuk...@cybozu.co.jp-20130122005