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

      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

            Assignee:
            markus makela markus makela
            Reporter:
            elena.kotsinova Elena Kotsinova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration