Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1711

Poor performance of the adapter in case of bulk data loading

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.1.6
    • Icebox
    • None
    • None

    Description

      Configuration:
      TX -> MaxScale -> ColumnStore

      Use case:
      Data was loaded from file with load command in TX.

      Result:
      CDC adapter starts inserting data row by row.
      After 134970 records have been loaded in TX, they are inserted into CS with speed of half second per record.
      This is around 18 hours inserting saga.

      So slow speed is not acceptable for daily operations in this configuration.
      Even these are regular inserts the adapter performs with the same average speed of half second per record.

      Attachments

        Activity

          People

            markus makela markus makela
            elena.kotsinova Elena Kotsinova (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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