Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-437

Downloading database usage statistics

    Details

    • Type: Explanation
    • Status: Published
    • Affects Version/s: EXASolution 5.0
    • Fix Version/s: None
    • Component/s: EXAoperation, EXASolution
    • Labels:
      None
    • Solution:
      Hide

      Why

      Exasol logs a multitude of system information in statistical system tables (schema EXA_STATISTICS). This information is kept long-term and provides good insights concerning changes in database behavior. Many times it is easy to spot if a "system is slow" report was triggered by a sudden change or by a long-standing trend.

      Those statistics also provide a good starting point for further system analysis concerning sizing and performance.

      How

      a) Manually

      1. Log into EXAoperation
      2. Select your database instance
      3. Select "Statistics" in the bottom pane
      4. Enter valid login credentials for the database and click on "Download"
        The given user must have the system privileges CREATE CONNECTION and SELECT ANY DICTIONARY.
      5. When prompted by your browser, chose to save the zip-archive

      b) Automated (XML/RPC)

      The XML/RPC interface also provides a function to download these statistics. The following is a minimal parametrized example in python:

      s = xmlrpclib.ServerProxy(httpstring + '/cluster1')
      t = xmlrpclib.ServerProxy(httpstring + '/cluster1/' + urllib.quote_plus('db_' + dbname))
      data = base64.b64decode(t.getDatabaseStatistics(dbuser, dbpass, startdate, enddate))
      file(filename, 'w').write(data)
      

      More on that in the Exasol XML/RPC reference manual.

      What

      The zip archive contains a set of CSV files (all unencrypted) with extracts of the most important statistical system tables.
      All data is in aggregated form, it does not contain any of the following:

      • User names
      • Schema names
      • Table names
      • SQL texts
      Show
      Why Exasol logs a multitude of system information in statistical system tables (schema EXA_STATISTICS ). This information is kept long-term and provides good insights concerning changes in database behavior. Many times it is easy to spot if a "system is slow" report was triggered by a sudden change or by a long-standing trend. Those statistics also provide a good starting point for further system analysis concerning sizing and performance. How a) Manually Log into EXAoperation Select your database instance Select "Statistics" in the bottom pane Enter valid login credentials for the database and click on "Download" The given user must have the system privileges CREATE CONNECTION and SELECT ANY DICTIONARY . When prompted by your browser, chose to save the zip-archive b) Automated (XML/RPC) The XML/RPC interface also provides a function to download these statistics. The following is a minimal parametrized example in python: s = xmlrpclib.ServerProxy(httpstring + '/cluster1' ) t = xmlrpclib.ServerProxy(httpstring + '/cluster1/' + urllib.quote_plus( 'db_' + dbname)) data = base64.b64decode(t.getDatabaseStatistics(dbuser, dbpass, startdate, enddate)) file(filename, 'w' ).write(data) More on that in the Exasol XML/RPC reference manual. What The zip archive contains a set of CSV files (all unencrypted) with extracts of the most important statistical system tables. All data is in aggregated form, it does not contain any of the following: User names Schema names Table names SQL texts
    • Category 1:
      Database Administration
    • Category 2:
      Cluster Administration - Monitoring & Logging

      Attachments

        Activity

          People

          • Assignee:
            CaptainEXA Captain EXASOL
            Reporter:
            CaptainEXA Captain EXASOL
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: