Re: Fragmentation problem with MYD/MYI files

2003-09-19 Thread Dan Nelson
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

Re: Fragmentation problem with MYD/MYI files

2003-09-18 Thread Jeremy Zawodny
On Thu, Sep 18, 2003 at 01:57:17PM +0300, Mikko Noromaa wrote: > Hi, > > 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. > This way the files would need to be grown only

Fragmentation problem with MYD/MYI files

2003-09-18 Thread Mikko Noromaa
Hi, I have a large MyISAM database with 22 million rows. The MYD file is now 4 GB in size, and the MYI file is 2 GB. I am constantly adding rows to this database and rarely deleting any. Thus the database size grows constantly. MySQL seems to increase the database files (MYD/MYI) in very small in