[Mondrian] Monitoring Mondrian

Matt Campbell mcampbell at pentaho.com
Mon Mar 4 08:56:33 EST 2013

Take a look at the mondrian.server.monitor package if you haven't already.  This infrastructure is intended to capture some the information you're looking for.  That said, there are at least some bugs where metrics are captured incorrectly (e.g. MONDRIAN-1449<http://jira.pentaho.com/browse/MONDRIAN-1449>).  The features has not been used much to date.  It also requires programmatic access to read the metrics-you need to have a connection object in order to read monitoring data.  I'd love to see this data exposed via JMX (MONDRIAN-1448<http://jira.pentaho.com/browse/MONDRIAN-1448>) and through pentaho BI (MONDRIAN-857<http://jira.pentaho.com/browse/MONDRIAN-857>).  I believe new relic supports JMX, so that might be an option for you if 1448 gets implemented.

Vote for Jira cases if any of the above would help you, and add new ones if you find bugs or missing use cases.

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Oren Mazor
Sent: Sunday, March 03, 2013 8:30 PM
To: mondrian at pentaho.org
Subject: [Mondrian] Monitoring Mondrian

Hey all,

I built a stack on top of mondrian using pg and rails. I monitor the rails app using new relic, but once a request goes into mondrian, its a black hole. what would you recommend for monitoring?

The questions I want to ask is:
 - did this query hit the cache?
 - how much cache got loaded by this query?
 - how long did each step take?
 - what does the jvm look like at this stage?

I feel like editing the mondrian source code to push to newrelic (or statsd) with custom instrumentation is a step in the wrong direction.

between splunk and a variety of jvm debug tools I have something going, but I think there's a better way that I dont know about.

thanks for your help!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130304/1c157225/attachment.html 

More information about the Mondrian mailing list