Resetting Roxie Metrics

Wed Jul 31, 2013 3:29 am

In the "Cluster Processes" section of ECL Watch, you can choose to view Roxie Metrics for a Roxie cluster. Is there a way to reset those statistics for testing/evaluation purposes? Restarting the Roxie cluster performs a reset, but I was hoping for something a little less drastic.

Thanks,

Dan

Wed Jul 31, 2013 2:01 pm

Good question.

I am researching this for you and someone reply here. After we have an answer, I will add that info to the Using Roxie Manual.

Your question also made me think of another question. I would like to know how to view metrics for time periods previous to any restart.

Stay tuned...

Wed Jul 31, 2013 3:53 pm

You can send control messages to Roxie using testsocket:

Code: Select all: testsocket roxieip "<control:resetindexmetrics/>" testsocket roxieip "<control:resetMetrics/> testsocket roxieip "<control:resetquerystats/>" testsocket roxieip "<control:resetquerystats><Query id='queryId'/></control:resetquerystats>"

We should probably provide access via the eclwatch gui...

Wed Jul 31, 2013 4:22 pm

Great information!

Is this documented anywhere? If not, can we get it added to the "to be documented" list?

Thanks!

Dan

Wed Jul 31, 2013 4:23 pm

It is on my list, now. Thanks