Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-998

Improve Mondrian monitoring



    • Type: New Feature
    • Status: Open
    • Severity: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: None
    • Labels:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.


      For monitoring, we need (a) objects (list of connections, statements), (b) counters (we brainstormed a list of about 20, see below), and (c) events (SQL statement started executing, SQL statement stopped executing).

      Outside of Mondrian, we need a way to create time-averaged counters (cf load average as displayed by top). And we of course need a UI to display this stuff. But the mondrian bits are easy, so here they are.

      Counters (quick list – some are duplicates and others don't make sense under close scrutiny)

      1. stmts
      2. connections
        rows fetched
      3. sql stmts open
      4. sql stmts by category (cell query, member query, other)
        cell cache requests
        cell cache misses
        cell cache hits
        cache misses in the last minute
        cache hits in the last minute
        number of mdx statements open, executing
        jvm memory usage
        number of segments
        number of segments created
        number of aggregates
        number of mdx function calls cumulative
        how many operations have been evaluated in sql?
        number of members in cache
        number of cells in segments
        mdx query time
        sql query time
        sql rows
        olap4j connection pool size
        sql connection pool size
        thread count
      5. schemas in schema cache
        cells fulfilled by sql statements
        mondrian server count (other stats relate to just one server)


      SQL statement start
      SQL statment stop
      external cache call
      (other expensive operations similar to sort?)


          Issue Links



              • Assignee:
                jhyde Julian Hyde (Inactive)
              • Votes:
                2 Vote for this issue
                3 Start watching this issue


                • Created: