At 02:45 AM 11/23/2011, you wrote:
>since MySQL 5.1 MyISAM has an algorythm to detect if you are going to
>delete a row without ever reading it,
>so when you insert it, it will use the blackhole storage engine instead.
> :O (NB: it is a joke)
I have been using the blackhole storage engine for archiving
my important data for the past 3 years, and I must say it is
extremely fast and its compression level is fantastic. All 2.5 TB of
data that I archived can fit on a single DVD. My boss is really impressed.
>2011/11/23 Johan De Meersman <vegivamp@stripped>
> > ----- Original Message -----
> > > From: "Yu Watanabe" <yu.watanabe@stripped>
> > >
> > > It seems that MYD is the data file but this file size seems to be not
> > > increasing after the insert sql.
> > That's right, it's an L-space based engine; all the data that has, is and
> > will ever be created is already in there, so storage never increases :-p
> > Seriously though; the MYD file is the datafile and the MYI file is the
> > index file. Both of those will increase with use, although since storage
> > allocation happens based off pages, not records, increases will only happed
> > when the existing pages are filling up.
> > --
> > Bier met grenadyn
> > Is als mosterd by den wyn
> > Sy die't drinkt, is eene kwezel
> > Hy die't drinkt, is ras een ezel
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1