473,372 Members | 848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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 3917
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: los | last post by:
Hi, I'm trying to create a program similar to that of Google's desktop that will crawl through the hard drive and index files. I have written the program and as of now I just put the thread to...
4
by: Mee Yamo | last post by:
Fellas!! This is a very complicated one and it took me a few days to figure out exactly what's going on, but here's the final story: I have a production environment running on .NET with a SQL...
1
by: Sgt. Sausage | last post by:
I've got a server (SQL 2K, Win2K) where the backups have started running long. The database is a bit largish -- 150GB or so. Up until last month, the backups were taking on the order of 4 to 5...
3
by: Marina | last post by:
Hi, let's see an application is sitting on a server elsewhere, and it is accessed via http:// or by just the location specified by \\servername. So on first request the app is downloaded, on...
6
by: Reinhard Lehner | last post by:
Hi there! I spent the last week trying to fix this problem - I am always getting an error when trying to run an application (WinForms or PPC) out of Visual Studio IDE: 'Error while trying to...
0
by: Lauren Wilson | last post by:
Hello dear People! For the very first time I have attempted to have BOTH Access 2000 AND Access 2002 installed on the same computer. I started with Access 2002 (XP). After I was sure the A2002...
4
by: GTi | last post by:
Maybe is this a old and well known question, but can't my C# .NET application run from a network share? Running it from a local disk is OK but not from my F:\ disk (nettwork disk).
8
by: Kathy Burke | last post by:
Hi. Yet another question. We're running a new asp.net app off a production network server. The PC is a PentiumII/III with 128MB of RAM. When running the app, the memory uses read at about...
6
by: Guillermo | last post by:
Hi, I need a script to keep running in the background after it's loaded some data. It will make this data available to the main program in the form of a dictionary, but I don't want to reload...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.