Re: [Mysqlfs-general] Patch to mysqlfs-0.2 to break file data into records of 4k chunks

[Michal L. <mi...@lo...>]

Hi Lester,

> My patch does seem to provide exceptional performance enhancements in my
> test cases, and is actually not a complicated set of patches.  The premise
> is simple, instead of storing the file data in a longblob in the fs table,
> I created a related table, fs_file_blocks, that holds the data in blocks
> of no more than 4k chunks, with a tabledef as follows:

That looks like a pretty good idea. However the codebase and DB schema 
changed *a lot* since mysqlfs-0.2. Could you forward port your changes 
to 0.3 please? We don't use the full path as a key anymore instead we 
use inodes. But that shouldn't make a big difference for you.

I also suggest to pull the current sources from the anonymous CVS and 
send us the output of "cvs diff -up" once you're done with porting. A 
good test of mysqlfs stability proved to be compilation of some 
nontrivial package (I use openssl-0.9.8 myself as that does some pretty 
nasty things ;-) so you can try that as well to see how your changes 
behave in a real life.

I'm looking forward to see your patch in the next mysqlfs release!

Michal