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

Statistics export for support V6.0.x

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.x
    • Fix Version/s: None
    • Component/s: EXASolution
    • Labels:
      None
    • Solution:
      Hide

      Problem

      The scripts attached to this issue can be used to gather and export database usage statistics for databases in version 6.x (Version 5.0.x is SOL-38) .

      Solution

      We provide scripts for three different purposes:

      • 3rdLevelStatsIndices.sql: statistics on indices and database objects
      • 3rdLevelStatsLastDay.sql: statistics of the last day
      • 3rdLevelStatsHourly.sql:hourly statistics for the last x days (x is a script parameter)

      The script exportStatsHourly.sql contains a parameter which defines the number of days in the past to export statistics for. When executing the script via the command line or the GUI the user will be prompted to enter this parameter.

      NOTE: The size of the generated CSV's vary and could be quite large - make sure that there is enough space on the directory that you are saving them to.

      Show
      Problem The scripts attached to this issue can be used to gather and export database usage statistics for databases in version 6.x (Version 5.0.x is SOL-38) . Solution We provide scripts for three different purposes: 3rdLevelStatsIndices.sql: statistics on indices and database objects 3rdLevelStatsLastDay.sql: statistics of the last day 3rdLevelStatsHourly.sql:hourly statistics for the last x days (x is a script parameter) The script exportStatsHourly.sql contains a parameter which defines the number of days in the past to export statistics for. When executing the script via the command line or the GUI the user will be prompted to enter this parameter. NOTE: The size of the generated CSV's vary and could be quite large - make sure that there is enough space on the directory that you are saving them to.
    • Category 1:
      Database Administration

      Attachments

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated: