This content has been marked as final. Show 4 replies
We had the similar issue with our indexes, though the numbers were a bit higher. Our baselines would deliver indexes around 20G, that would grow to over 50G each in the course of a week of partial updates.1 person found this helpful
We opened a ticket with Oracle support about this, and we were told that it is expected to see a slow growth in memory utilization over time. As a Dgraph runs throughout the week (we do weekly baselines), it adds different pieces from the index into memory. In addition, each partial update that is added contributes to the memory of the process as different generations files are added and loaded. These, combined with any sorts that are specified for the data set, and the cache, will cause the memory to grow over time.
We were also told that, if the memory usage of the dgraph is predictable, then make sure to have enough physical RAM on the machine to accommodate the entire dgraph process (or processes). We have found this to be really important. If you don't have sufficient RAM to hold the dgraph(s), then they will begin to swap to disk when they hit the RAM limit, and your search performance will go through the floor.
I just wanted to add that the query performance degradation was partly due to the dgraph cache being cleared after partial update. You will want to run a dgraph warming script after each partial update to get your engine to a steady state quickly.1 person found this helpful
The spike in memory surge for partial update is partly due to new generation index being created and the subsequent merging. The memory usage should come down after the generation merge completes. Assuming no other processes running on your machine, the second line for 'free' command (used: -/+ buffers/cache) tells you the RAM consumption (RSS) for your dgraphs and the first line 'cached' tells you your file system cache consumption. Make sure your total physical RAM is big enough to maintain a healthy balance between the two.
Thanks MP and Jim. We will use this information while sourcing the RAM. We are doing partial every 20 minutes and what sort of dgraph warming script should I use?
Thanks once again,
Edited by: 924798 on 02-Sep-2012 17:15
The warming script is basically a script replaying your commonly used queries to your dgraph to warm the cache. One way of getting the commonly used queries is to parse your production dgraph request logs. You would want to experiment the number of queries you use in your warming script to fit them in your 20 minute partial window.