Wed Dec 01, 2021 4:21 pm
Login Register Lost Password? Contact Us


Resetting Roxie Metrics

Comments or questions specific to the features of ECL Watch

Wed Jul 31, 2013 3:29 am Change Time Zone

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
DSC
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 568
Joined: Tue Oct 18, 2011 4:45 pm

Wed Jul 31, 2013 2:01 pm Change Time Zone

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...
JimD
 
Posts: 157
Joined: Wed May 18, 2011 1:35 pm

Wed Jul 31, 2013 3:53 pm Change Time Zone

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...
richardkchapman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 110
Joined: Fri Jun 17, 2011 8:59 am

Wed Jul 31, 2013 4:22 pm Change Time Zone

Great information!

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

Thanks!

Dan
DSC
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 568
Joined: Tue Oct 18, 2011 4:45 pm

Wed Jul 31, 2013 4:23 pm Change Time Zone

It is on my list, now. Thanks
JimD
 
Posts: 157
Joined: Wed May 18, 2011 1:35 pm


Return to ECL Watch

Who is online

Users browsing this forum: No registered users and 1 guest