Why use a RAM disk? Why not just load the tables into HEAP tables?
On Jul 29, 2004, at 11:51 AM, Egor Egorov wrote:
Stephen Rasku [EMAIL PROTECTED] wrote:
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive. We want
to
At 04:45 PM 7/28/2004, you wrote:
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive
Flash drives are solid state (no moving parts) so you can't break them.
I've
: Jul 30, 2004 7:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive
At 04:45 PM 7/28/2004, you wrote:
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong
I just looked into this. It looks like HEAP tables don't support the
BLOB field type and we are using it.
...Stephen
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases
]
Sent: Jul 30, 2004 7:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive
At 04:45 PM 7/28/2004, you wrote:
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong
Just a thought, but perhaps you could set up a master/slave
on the box such that the master points to a RAM disk and the
slave points to disk. Then if someone pulls the plug or the
machine crashes, you'd still have almost all of the data on
disk. On startup, copy the slave's files to the RAM disk,
support the
BLOB field type and we are using it.
...Stephen
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive
Why use a RAM disk? Why not just load the tables
could get running on QNX.
...Stephen
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 10:23 AM
To: [EMAIL PROTECTED]
Subject: RE: Installing MySQL Databases on RAM Drive
QUOTE
Ok, then it makes sense to use compact flash just for backup and not the
primary
Stephen Rasku [EMAIL PROTECTED] wrote:
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive. We want to
install the database on the RAM disk on startup and save it to flash on
shutdown.
There are two databases
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive. We want to
install the database on the RAM disk on startup and save it to flash on
shutdown.
There are two
10 matches
Mail list logo