mysqld on jffs2: MyISAM Index write is slow

[Artem B. Bityuckiy]

Not expert in this issue, but I was told by David that JFFS2 is 
synchronous, and you need redesigning it if you want asynchronous 
behaviour.

> Hi,
> I am using mysqld on jffs2. Tables work fine, but as soon as
> i am using indexes the writing of new entries becomes very slow.
> I found that mysql is writing one 1024 byte block to the index file
> of the MyISAM table (.MYI) for every new row. This is up to 20 times in
> sequence
> the same block. On non synchronous filesystems
> this goes to a Buffer in RAM, but on jffs2 this causes many writes to
> the flash. In my amdflash emulator I found that mysql writes about 180MB to
> the flash
> for a table of 13MB with 88000 rows.
> 
> Is there a way to make jffs2 a little bit asynchronous ? Or does anybody
> know
> how to tell mysqld to write smaller blocks ? Mounting a reiser as loopback
> from
> a file on jffs2 does not work because jffs2 doesn't support mmap.
> 
> Jochen
> 
> 
> ______________________________________________________
> Linux MTD discussion mailing list
> http://lists.infradead.org/mailman/listinfo/linux-mtd/
> 

--
Best Regards,
Artem B. Bityuckiy,
St.-Petersburg, Russia.