Mark Maunder wrote:
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
There is:
REPAIR TABLE t1 USE_FRM
--
Sasha P
Hi Mark,
- Original Message -
From: "Mark Maunder"
Sent: Monday, February 23, 2004 4:17 PM
Subject: Re: HEAP tables vs MYISAM on ramdisk
> 411 is packed with features I'm dying to have on my production server,
> but I had it on my dev box, and I got some t
411 is packed with features I'm dying to have on my production server,
but I had it on my dev box, and I got some table corruption which,
admittedly, I was too lazy to try to reproduce. So I've downgraded to
production 4 again. I have a heavily updated fulltext index which may be
the root of the ev
Index caches are new to 4.1.x, but key caches have been around for a while.
Definitely in 4.0, can't remember about 3.x. Either way though, I don't see
either helping with inserts or updates. Only with queries.
MySQL does suggest using a seperate key cache for temporary tables though:
http://www
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
http://www.mysql.com/doc/en/CACHE_INDEX.html
Index caches are on
How are you ensuring syncronization between the ram disk and the HD? Is
there a writeback / writethrough mechanism for ram disks? Are you not
risking major data loss if ever you have a power failure or PC failure?
Thanks for the info!
Eric
"Mark Maunder" <[EMAIL PROTECTED]> wrote in message
ne
At 11:41 -0800 3/6/03, Steve Quezadas wrote:
I have a mysql table that I refer to a lot and needs to be quick. I
set it as a HEAP table because of the speed (and HEAP tales ARE
fast. zip baaannn). Anyway, whenever I restart the server
the contents of the heap tables disappear! What the h
Or just give MySQL plenty of ram and trust it to keep frequently used data
in ram - which it does. "Prime" the system by doing some form of search
which forces all the rows into memory (Select * from table where
unindexedfield = somethingimpossible), the do a speed test on this versus a
heap table
Store it in another table and have a start up script that creates a heap
once the server is started ?
Jerry
- Original Message -
From: "Steve Quezadas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 7:41 PM
Subject: heap tables keep on disappearing!
> I have
At 10:15 -0500 3/20/02, Ramaraju.R.V wrote:
>Hi,
>
>Application uses Jboss server with mysql backend.
>IMDB tables (Heap tables) are created by the app. Things work on fine.
>Suddenly we miss Heap tables. We are not able to reproduce this at any
>particular event.
Is someone restarting the server
Hi,
On Wed, 2002-03-06 at 15:50, Scalper wrote:
> If I create a temporary heap table from a select statement, does the new
> table also inherit the indexes (indices?) from the original table. Or will
I think that every CREATE [...] TABLE [...] SELECT does not inherit any
indexes (doesn't mat
Hi.
On Thu, Dec 13, 2001 at 03:50:01PM +0200, [EMAIL PROTECTED] wrote:
>
> is it possible to insert many rows into a heap table?
Yes. By the way, why didn't you simply try out yourself?
> I'm not sure how from the documentation.
The same way as with other table types.
> If not, are there ot
is it possible to insert many rows into a heap table?
I'm not sure how from the documentation.
If not, are there other kinds of temporary tables that can be used?
I need to enter 100 rows into a table and then select them with order
by.
do I need to create a table, select the records I want, ins
Hi.
On Mon, Oct 01, 2001 at 04:53:33PM +0400, [EMAIL PROTECTED] wrote:
> Hello mysql,
>
> Could anyone tell me if heap tables are cyrrently working with
> replication.
>
> As I remember some time ago you might get problems then server
> restarts (so empty it's heap tables) there fore sl
So sprach »Fournier Jocelyn [Presence-PC]« am 2001-07-15 um 23:37:57 +0200 :
> Hi,
>
> Definitely yes :)
> But the table structure won't be lost.
Thanks to all who replied!
filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:
> Hello
>
> When I store some data in a table of type Heap, this data will be lost
> when the server is shutdown (and later restarted), won't it?
Correct.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
16 matches
Mail list logo