Hi Maxime I have been able to recreate and we are looking into this ...
Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 20 Sep 2011, at 14:57, Maxime Teissèdre wrote: > Hello, > > To monitor and graph value from virtuoso we decided to use the command > "select sys_stat ()"; > We did some tests gathering buffers values (st_db_buffers st_db_used_buffers > st_db_dirty_buffers st_db_wired_buffers) each 10 seconds, we noted during > several tens of second that the values weren't updated, it seems there where > cached or not updated. > After we ran some test with status(); and the same values were updated more > regularly. > > Finally, we did a test where we run "select sys_stat ()" several times, and > after we run "status ();" command, we discovered that coincidently, values > returned by "sys_stat ();" were updated after the "status ()" . > > So my questions are: > * is there some caching done somewhere when calling "select sys_stat ()" ? > * does "status();" bypass or invalid this cache ? > * is a way to bypass the cache when using "select sys_stat ()" ? > > Could you enlighten us on that part ? > > We use VOS 6.1.3. > > Regards. > > Maxime T. > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2dcopy1_______________________________________________ > Virtuoso-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
