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
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
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