David Johnson wrote:
>
> We have five big tables with blobs in them that get fragmented very fast.
> We have to stop out (24 X 7) operation to defrag them too frequently (one a
> week). It seems that the fragmentation happens so fast because MySQL tries
> very hard not to waste space. For instance, we had one table that had 6.75
> Blocks/Record but only had 1% lost space.
>
> We'd love if we could tell MySQL to use 2Gig for the table and populate it
> sparsely, rather than trying
> so hard to save space. Is this possible? Do we need to hack the source?
>
> DJ
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5976@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
How about storing the blobs on the filesystem and storing references to
them in the database? You are not searching through the blobs for
patterns, are you?
--
Sasha Pachev
http://www.sashanet.com
