[Mondrian] performance issue - 30sec delay catch on log

Miguel Gaspar miguel.gaspar at webdetails.pt
Wed Sep 21 05:27:43 EDT 2016


I am facing some performance issues running some MDX queries on Mondrian. The SQL queries are running very fast, but we got a big delay until we get response from Mondrian. 

Looking to the logs the delay is about 30sec where Mondrian is taking some time (please see below). I have tested it in multiple machines and multiple times and always get stuck here.

 

Why is this happening?

Is there a way to solve the issue? What would be the drawback?

 

Thanks in advanced.

 

 

2016-09-19 15:43:11,971 DEBUG [mondrian.rolap.RolapMember] RolapMember.makeUniqueName: uniqueName=[Vehicle].[#null]

2016-09-19 15:43:11,971 DEBUG [mondrian.server.monitor] ExecutionPhaseEvent(690162, 0)

2016-09-19 15:43:11,973 DEBUG [mondrian.rolap.FastBatchingCellReader] Using grouping sets

2016-09-19 15:43:11,973 DEBUG [mondrian.rolap.FastBatchingCellReader] load (millis): 0

 

30 SECONDS DELAY HERE 

 

2016-09-19 15:43:40,587 DEBUG [mondrian.rolap.agg.SegmentBuilder] Rolling up segments with parameters:

keepColumns=[DATE_DIMENSION.DAY_KEY, USER_GROUP_DIMENSION.VEH_WEIGHT_CLASS]

aggregator=sum

datatype=Numeric

*Segment Header

Schema:[Network]

Checksum:[7342b0bb83663119e0d9fef045afcf43]

Cube:[Idletime_Vehicle]

Measure:[Idle Time]

Axes:[

    {DATE_DIMENSION.DAY_KEY=('20160912','20160913','20160914','20160915','20160916','20160917','20160918','20160919')}

    {USER_GROUP_DIMENSION.VEH_WEIGHT_CLASS=('Heavy','Light')}

    {USER_GROUP_DIMENSION.VEH_KEY=(*)}]

Excluded Regions:[]

Compound Predicates:[]

ID:[df315378263e823a6ced69aba404e1d8a8c4e0266491a44602b95614fa29a561]

 

AxisInfos constructed:column.columnExpression=DATE_DIMENSION.DAY_KEY

column.valueCount=7306

column.values=[20160912, 20160913, 20160914, 20160915, 20160916, 20160917, 20160918, 20160919]

requestedValues=[20160912, 20160913, 20160914, 20160915, 20160916, 20160917, 20160918, 20160919]

valueSet=[20160912, 20160913, 20160914, 20160915, 20160916, 20160917, 20160918, 20160919]

values=[20160912, 20160913, 20160914, 20160915, 20160916, 20160917, 20160918, 20160919]

hasNull=false

src=0

lostPredicate=false

column.columnExpression=USER_GROUP_DIMENSION.VEH_WEIGHT_CLASS

column.valueCount=5

column.values=[Heavy, Light]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160921/75a64384/attachment.html 


More information about the Mondrian mailing list