Re: database bigger than the RAM ?
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).
Subject
Views
Written By
Posted
3891
December 17, 2004 03:08AM
2419
December 17, 2004 11:15PM
2311
December 18, 2004 03:52AM
2423
December 20, 2004 12:23AM
2470
December 20, 2004 06:54AM
Re: database bigger than the RAM ?
3277
December 23, 2004 06:46PM
2269
January 24, 2005 04:09PM
2475
January 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.