Hi Hugh,
this is almost the case. I would like to keep the amount of available
buffers
in order to keep the performance.
However, I want in each query execution these buffers to be clear as if the
server
was started and no query had executed.
I suppose that if some query results are already cont
Hi Alex,
To be clear, you are saying you do not want these test queries to run from
memory and always run from disk as that seems to be the implication of what you
are saying which does not make sense to me as they will never then be
performant ? You could set the NumberOfBuffers to a low value
Hi Hugh,
yes I suppose these are the wanted buffers to be cleared.
We are running some tests with some queries multiple times and we cannot
explain a better response time. So we would like to exclude the
buffer/cache parameter. We already clear the cache of the system with the
drop cache command,
Hi Alex,
By buffers I presume you mean as specified in the NumberOfBuffers INI file
param, which can be seen from the “status()” output as:
25 buffers, 50745 used, 1 dirty 0 wired down, repl age 0 0 w. io 0
w/crsr.
The buffers themselves are allocated for use by the server at start
Hello to all,
I would like to ask if there is any way to clear all buffers/cache in
virtuoso server.
Thanks.
