Skip navigation links

MySQL Forums :: Cluster :: database bigger than the RAM ?


Advanced Search

Re: database bigger than the RAM ?
Posted by: Stewart Smith ()
Date: December 23, 2004 06:46PM

This is true - however, you can cheat and add swap space. Then, telling ndbd to use more memory, or running more ndbd processes, you can have a database bigger than your physical memory. HOWEVER, you will be hitting swap and be at the mercy of a number of factors. Performance may suck... but then again, it may be good enough for you.

With linux, you can easily add swap temporarily from a file. something like:
dd if=/dev/zero of=swapfile1 bs=1024 count=10000

(increase bs and count as appropriate)
mkswap swapfile1
swapon swapfile1

Remmeber though, if you're using a 32bit machine, you'll probably have to use funky kernel options and those horrible extended memory modes of the x86.

Would be interested to see how you go.

But Harisson is right - the best way is to add more machines or add more RAM (preferably both).

Options: ReplyQuote


Subject Views Written By Posted
database bigger than the RAM ? 2398 Jörg Nowak 12/17/2004 03:08AM
Re: database bigger than the RAM ? 1684 Harrison Fisk 12/17/2004 11:15PM
Re: database bigger than the RAM ? 1613 sanjeev jain 12/18/2004 03:52AM
Re: database bigger than the RAM ? 1676 Florian Rissner 12/20/2004 12:23AM
Re: database bigger than the RAM ? 1701 Jörg Nowak 12/20/2004 06:54AM
Re: database bigger than the RAM ? 2311 Stewart Smith 12/23/2004 06:46PM
Re: database bigger than the RAM ? 1636 Robert McHugh 01/24/2005 04:09PM
Re: database bigger than the RAM ? 1684 Harrison Fisk 01/24/2005 09:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.