Running mtSQL on a RAM disk

[Claude]

Folks - some years ago a thread was started (I believe) by a gentleman
named Creigh Shank regarding his use of a RAMdisk mySQL db. I am
trying to set up the same thing but have been stopped right from the
get go as I can not get a larger than 2G RAM disk going (using a 64 bit
Ubuntu installation).

I am hoping someone who has gone through the basic set up might get me
squared away to start. An offline conversation would be fine and
perhaps save the rest of y'all wading through said basics.

Any help at this point would be very much appreciated.

Thank you

Claude
--
Claude
------------------------------------------------------------------------
Claude's Profile: http://forums.yourdomain.com.au/member.php?userid=97
View this thread: http://forums.yourdomain.com.au/showthread.php?t=83210

[Steven Musumeche]

Check out the MySQL docs for information on Heap tables.

-Steven

Claude wrote:

Folks - some years ago a thread was started (I believe) by a gentleman
named Creigh Shank regarding his use of a RAMdisk mySQL db. I am
trying to set up the same thing but have been stopped right from the
get go as I can not get a larger than 2G RAM disk going (using a 64 bit
Ubuntu installation).

I am hoping someone who has gone through the basic set up might get me
squared away to start. An offline conversation would be fine and
perhaps save the rest of y'all wading through said basics.

Any help at this point would be very much appreciated.

Thank you

Claude

[Claude]

Stephen, thank you for the pointer to heap (memory) tables. I have
checked them out. I was hoping thespeed increase of using RAM would be
a lot better than just 30%
(http://www.databasejournal.com/featu...e.php/3077531).

Are there any RAM-based approaches that will speed things up?

Thanks

Claude
--
Claude
------------------------------------------------------------------------
Claude's Profile: http://forums.yourdomain.com.au/member.php?userid=97
View this thread: http://forums.yourdomain.com.au/showthread.php?t=83210