[Asterisk-Users] Asterisk & MySQL Blobs

[Adam Goryachev]

On Mon, 2005-03-07 at 13:30 -0800, beonice wrote:
> --- Colin Anderson <ColinA at landmarkmasterbuilder.com>
> wrote:
> The problem I suspect will arise is the number of
> inodes allowed by the file system. I don't know the
> exact size of the typical inode-max, but this will
> also presumably become an issue when the user tries to
> scale to really large amounts of faxes or voicemail!
> Would it help to split the db off to a separate server
> (that should reduce the CPU load on the asterisk
> server)?
> 
> Any other alternatives? Anyone verified whether the
> BLOB storage solution breaks down first or the number
> of inodes runs out first? :)

reiserfs doesn't have inodes, it also uses 'compression' for files
smaller than the 'block' size.

ie, say you use 4k blocks, and you need to store 4 x 1k files, then it
will store all 4 files into a single block, and record that the one
block includes 4 files etc.... so it is space efficient for lots of
small files.

It is also very efficient in the case where you have a lot of files in a
single directory, hence you don't need to worry about that (as much)
either. Though if you are expecting 10's of thousands of files, I'd
still do some sort of directory hashing.... (actually, I'd probably test
it and see)...

Regards,
Adam

 
 -- 
Adam Goryachev
Website Managers
Ph:  +61 2 9345 4395                        adam at websitemanagers.com.au
Fax: +61 2 9345 4396                        www.websitemanagers.com.au