Re: Installing MySQL Databases on RAM Drive

[Brent Baisley]

Could you store your BLOBs as files external to the database (in the OS 
file system) and just store the path name to the file? I don't know 
what your reasons for having the BLOB is, usually it's just for 
portability of the application.

As for "saving" the HEAP tables, you would just TRUNCATE the stored 
tables and do a SELECT INTO from the HEAP tables into the stored 
tables. Although I would keep two or more copies of the database and 
alternate between the databases when storing.

On Jul 30, 2004, at 1:10 PM, Stephen Rasku wrote:
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 on RAM Drive
Why use a RAM disk? Why not just load the tables into HEAP tables?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]