mysqld on jffs2: MyISAM Index write is slow

Jochen Karrer j.karrer at lightmaze.com
Fri Jan 14 14:08:30 EST 2005


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





More information about the linux-mtd mailing list