Ok - so how do I do that ? Each node has a node.name which I would like to cache.
Wayne On Monday, 13 March 2017 17:19:59 UTC, Michael Hunger wrote: > > You can but its not as general as nodes and rels and harder to implement > efficiently > > Von meinem iPhone gesendet > > Am 13.03.2017 um 13:25 schrieb unrealadmin23 via Neo4j < > ne...@googlegroups.com <javascript:>>: > > Ok, so I have set: > dbms.memory.pagecache.size=81g > > Restarted Neo4j and run: > > call apoc.warmup.run() ; > > My process allocation is now 200GB (Good). > I will try some tests to see how the performance compares. > > Question - why can't you cache the properties also ? I use ".name" a > lot. > > > On Monday, 13 March 2017 08:14:57 UTC, Michael Hunger wrote: >> >> Can you please comment in the pagecache setting and put it (it close to >> the sum of neostore.*.db) files but keep the total memory and heap into >> account >> >> >> >> Von meinem iPhone gesendet >> >> Am 13.03.2017 um 08:54 schrieb unrealadmin23 via Neo4j < >> ne...@googlegroups.com>: >> >> I have the following settings in neo4j.conf: >> >> This is about 1/8th of the machines memory: >> >> dbms.memory.heap.initial_size=120000m >> dbms.memory.heap.max_size=120000m >> >> >> The page cache is commented out: >> #dbms.memory.pagecache.size=10g >> >> Wayne >> >> >> On Monday, 13 March 2017 02:35:00 UTC, Michael Hunger wrote: >>> >>> What does your configuration look like in neo4j.conf for heap and >>> page-cache? >>> >>> neo4j> call apoc.warmup.run() ; >>> pageSize nodesPerPage nodesTotal nodePages nodesTime relsPerPage >>> relsTotal >>> 8192 546 123396013 226001 2 240 2035429925 >>> relPages relsTime totalTime >>> 8480959 73 76 >>> >>> so it loaded 226001 pages of nodes totalling 123m = 1.7 GB >>> and 8480959 pages of relationships totalling 2bn = 65 GB >>> >>> in 76 seconds >>> >>> So depending on your configuration you either have now 67GB of >>> page-cache filled or it spilled over. >>> >>> All operations that now require only node or relationship-record access >>> should access them in-memory. >>> >>> Operations that require properties will still need to load them into the >>> page-cache and depending on the size setup displace existing entries. >>> >>> >>> >>> On Sun, Mar 12, 2017 at 4:45 PM, unrealadmin23 via Neo4j < >>> ne...@googlegroups.com> wrote: >>> >>>> I installed apoc - I didn't know this existed - looks very >>>> comprehensive; thanks: >>>> >>>> neo4j> call apoc.warmup.run() ; >>>> pageSize, nodesPerPage, nodesTotal, nodePages, nodesTime, relsPerPage, >>>> relsTotal, relPages, relsTime, totalTime >>>> 8192, 546, 123396013, 226001, 2, 240, 2035429925, 8480959, 73, 76 >>>> >>>> Not much in the way of a noticeable speedup though. >>>> >>>> I don't know anything about Java, and cannot find the jvm command. >>>> Can you be more specific about what I need to run or configure from the >>>> Linux command line ? >>>> >>>> Wayne. >>>> >>>> >>>> On Saturday, 11 March 2017 10:14:49 UTC, Michael Hunger wrote: >>>>> >>>>> There is not a kernel buffer, but own own page cache that you have to >>>>> configure >>>>> >>>>> call apoc.warmup.run() >>>>> >>>>> Which warms up node and rel blocks >>>>> >>>>> Other speedup comes from jvm JIT warmup >>>>> >>>>> >>>>> Von meinem iPhone gesendet >>>>> >>>>> Am 11.03.2017 um 08:28 schrieb unrealadmin23 via Neo4j < >>>>> ne...@googlegroups.com>: >>>>> >>>>> Hi, >>>>> >>>>> Assuming that I have enough memory to loaded the entire DB into it, >>>>> are there any options (optimisations) to allow for this or is it just a >>>>> case of the disk blocks being able to reside in the kernels buffer cache ? >>>>> >>>>> Currently, the same query gets faster the more it is run - to a >>>>> point. I can live with an elongated startup time. >>>>> >>>>> Thanks, Wayne >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Neo4j" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to neo4j+un...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Neo4j" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to neo4j+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "Neo4j" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to neo4j+un...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> >> -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to neo4j+un...@googlegroups.com <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
