O.K., when I am creating the table as a heap type these are created as a
temporary tables as in
when I shutdown the server all the table(heap-table) content no where
exits. so suppose I create all my table as a type heap, then shutting
down of server means I will loose all my data, isn't it?
so, what's the method by which table contents remain in the secondary
storage, while I am creating the table as a heap type.
From: Jeremy Zawodny [mailto:jzawodn@stripped]
Sent: Tuesday, January 22, 2002 1:14 PM
To: Chetan Lavti
Subject: Re: regarding the MySQL's server Caching feature
On Tue, Jan 22, 2002 at 01:07:09PM +0530, Chetan Lavti wrote:
> thanks again ,
> yes, I have seen that but isn't it MySQL's default feature.. I will
> explore it more and talk to you for further queries..
Hmm. Not sure what you mean. Every version of MySQL released in the
last couple years has had HEAP tables.
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 19 days, processed 442,551,663 queries (264/sec.