[Mondrian] Mondrian execute query very slow

wenxzhen wenxing.zheng at qq.com
Thu Sep 29 03:54:21 EDT 2016


attach 2 jstack outputs from the process when it's ongoing the query for your reference


Kind Regards, Wenxing
------------------ Original ------------------
From:  "wenxzhen";<wenxing.zheng at qq.com>;
Date:  Sep 29, 2016
To:  "mondrian"<mondrian at pentaho.org>; 

Subject:  [Mondrian] Mondrian execute query very slow



Dear all,


Today we found an issue on the Mondrian when we are executing a query with 2 measures + 4 dimensions, and it took 100 seconds to complete from the mondrian_mdx.log. But from the mondrian_sql.log, we see the SQL statements were just taking 20 seconds to executes. 


How about the other 80 seconds? Is it taken by the Mondrian to do the construction of the Cube?


Thanks, Wenxing
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160929/c21f6eb2/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: saiku_call_stack.txt
Type: application/octet-stream
Size: 98631 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20160929/c21f6eb2/attachment-0002.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: saiku_call_stack1.txt
Type: application/octet-stream
Size: 98708 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20160929/c21f6eb2/attachment-0003.obj 


More information about the Mondrian mailing list