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

Re: Running mtSQL on a RAM disk

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
>
>

Re: Running mtSQL on a RAM disk

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/features/mysql/article.php/3 077531).

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