At 02:45 AM 11/23/2011, you wrote:
Also,
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)
Claudio
Claudio,
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.
Mike
(joking)
2011/11/23 Johan De Meersman <vegiv...@tuxera.be>
> ----- Original Message -----
> > From: "Yu Watanabe" <yu.watan...@jp.fujitsu.com>
> >
> > 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=claudio.na...@gmail.com
>
>
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
