Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
Best answer by Chris Macadam
Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
Hi Vincent,
You can perform a 'dummy' save executing this command:
save (fsxy
This will read all your data from disk including anything that is in files that have been dx'ed or dy'ed but it doesn't bother writing it anywhere.
You could set up a cron job that runs a script like this one:
#!/bin/bash
d3 -r -n pick0 -d "dm
dm
save (fsxy
exit
"
That assumes that the DM user and account do not have passwords set.
Cheers.
+1Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
Hy
i usually do like this
SELECT FOF TO LIST
LOOP
READNEXT KEY FROM LIST ELSE EXIT
READ F.FILE FROM FOF,KEY ELSE CONTINUE
EXECUTE 'SELECT ':F.FILE<1>:",":F.FILE<2>:","
REPEAT
STOP
Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
The solution as proposed by Alberto works with the following caveats:
By comparison, a file-save took only 5 minutes and achieved the same objective. The time taken and CPU intensity are basically irrelevant as this process would take place as a part of the cold-start process at midnight after the VM shuts down, performs a backup and then restarts.
My question therefore becomes: Is there a way to script the file-save process from Linux that will run unattended?
Brian, can you help in this regard?
Vincent
Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
Hi Vincent,
You can perform a 'dummy' save executing this command:
save (fsxy
This will read all your data from disk including anything that is in files that have been dx'ed or dy'ed but it doesn't bother writing it anywhere.
You could set up a cron job that runs a script like this one:
#!/bin/bash
d3 -r -n pick0 -d "dm
dm
save (fsxy
exit
"
That assumes that the DM user and account do not have passwords set.
Cheers.
+1Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
One question... you reboot your VM everyday ?
if you want when the VM starts you can add to coldstart the step to execute the file-save
and since you just did one before reboot you can use check-account macro that does a dummy save ( all the file-save without the save)
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/check_account_macro.htm#reference2651
Hi,
We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.
As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?
Vincent
Alberto and Chris,
Thanks a mil... you are both champs.
Vincent
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
