List:General Discussion« Previous MessageNext Message »
From:David Johnson Date:June 26 1999 5:55pm
Subject:to much fragmentation
View as plain text  
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




Thread
to much fragmentationDavid Johnson26 Jun
  • Re: to much fragmentationSasha Pachev27 Jun
  • Re: to much fragmentationScott Hess28 Jun
    • Re: to much fragmentationVivek Khera28 Jun
    • Re: to much fragmentationMichael Widenius29 Jun
      • Re: to much fragmentationEd Carp29 Jun
        • Re: to much fragmentationSasha Pachev29 Jun
        • Re: to much fragmentationMichael Widenius29 Jun
          • Authentication methodsRoger Smith29 Jun
            • Authentication methodsJani Tolonen1 Jul
        • Re: to much fragmentationScott Hess29 Jun
      • Re: to much fragmentationEd Carp29 Jun
        • Re: to much fragmentationMichael Widenius30 Jun
      • Re: to much fragmentationT├Ánu Samuel29 Jun
  • Re: to much fragmentationScott Hess28 Jun
Re: to much fragmentationFred Lindberg28 Jun