List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 19 2003 7:00am
Subject:Re: Fragmentation problem with MYD/MYI files
View as plain text  
In the last episode (Sep 18), Jeremy Zawodny said:
> On Thu, Sep 18, 2003 at 01:57:17PM +0300, Mikko Noromaa wrote:
> > Is it possible to configure MySQL so that it would allocate a large
> > amount of extra space for the MYD/MYI files, and then use this
> > space as necessary?
> I don't know of any.

If you have a blob field in your table, you can create a record with a
100MB blob, then delete it.

Or how about just dd'ing 100MB into the end of an existing MYI or MYD
file?  Mysql may not care that the filesize is different than what its
headers say.

	Dan Nelson
Fragmentation problem with MYD/MYI filesMikko Noromaa18 Sep
  • Re: Fragmentation problem with MYD/MYI filesJeremy Zawodny19 Sep
    • Re: Fragmentation problem with MYD/MYI filesDan Nelson19 Sep