Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-7631

ExasolRouter stream data from Exasol to client

    XMLWordPrintable

Details

    • MXS-SPRINT-281
    • Hide
      ExasolRouter now streams the resultset from Exasol to the client. This means that the memory consumption of MaxScale will stay flat, irrespective of the size of the resultset. Earlier the entire ODBC resultset was read and only then it was converted to a MariaDB resultset.
      Show
      ExasolRouter now streams the resultset from Exasol to the client. This means that the memory consumption of MaxScale will stay flat, irrespective of the size of the resultset. Earlier the entire ODBC resultset was read and only then it was converted to a MariaDB resultset.

    Description

      Currently the Exasol Router reads the entire ODBC resultset from Exasol, before converting it to a MariaDB resultset to be sent to the client. That lends itself well for an heavy analytical query that produces a small result, but not for a query returning large amounts of data. In that case, MaxScale may even run out of memory.

      To handle large resultsets, the Exasol Router must do the conversion in chunks, so that the amount of needed memory is bounded.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            johan.wikman Johan Wikman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 5d
                5d
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1d Time Not Required
                1d

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.