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.
