469,160 Members | 1,819 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,160 developers. It's quick & easy.

Running mtSQL on a RAM disk


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

Aug 8 '06 #1
2 3854
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

Aug 10 '06 #2

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

Aug 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sgt. Sausage | last post: by
4 posts views Thread by GTi | last post: by
6 posts views Thread by Guillermo | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.