RE: Installing MySQL Databases on RAM Drive

2004-07-30 Thread Stephen Rasku
ing I 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 Ok, then it makes sense to use compact flash just for backup and not the primary

Re: Installing MySQL Databases on RAM Drive

2004-07-30 Thread Brent Baisley
oks 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 on RAM Drive Why use a RAM di

Re: Installing MySQL Databases on RAM Drive

2004-07-30 Thread Eamon Daly
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,

RE: Installing MySQL Databases on RAM Drive

2004-07-30 Thread mos
hen -Original Message- From: mos [mailto:[EMAIL PROTECTED] 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

RE: Installing MySQL Databases on RAM Drive

2004-07-30 Thread Stephen Rasku
TED] 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

Re: Installing MySQL Databases on RAM Drive

2004-07-30 Thread mos
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 neve

Re: Installing MySQL Databases on RAM Drive

2004-07-30 Thread Brent Baisley
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

Re: Installing MySQL Databases on RAM Drive

2004-07-29 Thread Egor Egorov
"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 dat