Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: [Mondrian] Mondrian Cache

  1. #1
    Bruno Gomes Guest

    Default [Mondrian] Mondrian Cache

    Hi,
    i want know if its possible, given a determined MDX query, know if mondrian
    uses the cache or search directly for the multidimensional cell in the DBMS.
    In other words, to each mdx quey, i want to determine the multidimensional
    cell's that will be used, and if that cells are already retained in mondrian
    memory - mondrian cache - or if its necessary retrieve then from the data
    base.

    Thanks for the help.
    Best regards.

    --
    Bruno Gomes

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Guest

    Default RE: [Mondrian] Mondrian Cache

    Sort of related...

    Has anybody ever looked into a mechanism for reporting cell cache statistics? The types of statistics I'm thinking about are:

    * Some measure of cache size
    * Some measure of cache effectiveness, such as hit ratio

    --Jeff Wright

    ________________________________

    From: mondrian-bounces (AT) pentaho (DOT) org on behalf of Bruno Gomes
    Sent: Sun 3/21/2010 9:32 AM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Mondrian Cache


    Hi,
    i want know if its possible, given a determined MDX query, know if mondrian uses the cache or search directly for the multidimensional cell in the DBMS. In other words, to each mdx quey, i want to determine the multidimensional cell's that will be used, and if that cells are already retained in mondrian memory - mondrian cache - or if its necessary retrieve then from the data base.

    Thanks for the help.
    Best regards.

    --
    Bruno Gomes


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Julian Hyde Guest

    Default RE: [Mondrian] Mondrian Cache

    Both of these are reasonable feature requests. We could have a logger &
    given tracing level that prints out every request for a base cell (i.e. a
    cell that comes from the database, not involving any calc members) and
    whether it was a hit or a miss. And also print all cells retrieved by a
    fetch from the database. (We often fetch more cells than were asked for.)

    Cache size is simple: it is JVM max memory. However, it makes sense to print
    the cache hit ratio for each query.

    Please log feature requests for these. Or better, contribute them.

    I am a bit worried that if we implemented these, people would start
    obsessing about achieving a 100% hit ratio... but I guess that's a matter
    for them and their therapist.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of jeff.s.wright (AT) thomsonreuters (DOT) com
    Sent: Sunday, March 21, 2010 1:46 PM
    To: mondrian (AT) pentaho (DOT) org
    Subject: RE: [Mondrian] Mondrian Cache


    Sort of related...

    Has anybody ever looked into a mechanism for reporting cell cache
    statistics? The types of statistics I'm thinking about are:

    * Some measure of cache size
    * Some measure of cache effectiveness, such as hit ratio

    --Jeff Wright

    _____

    From: mondrian-bounces (AT) pentaho (DOT) org on behalf of Bruno Gomes
    Sent: Sun 3/21/2010 9:32 AM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Mondrian Cache


    Hi,
    i want know if its possible, given a determined MDX query, know if mondrian
    uses the cache or search directly for the multidimensional cell in the DBMS.
    In other words, to each mdx quey, i want to determine the multidimensional
    cell's that will be used, and if that cells are already retained in mondrian
    memory - mondrian cache - or if its necessary retrieve then from the data
    base.

    Thanks for the help.
    Best regards.

    --
    Bruno Gomes



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.