Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15690

benchmark the overhead caused by system versioning

    XMLWordPrintable

Details

    Description

      Thoughts:

      • inserts should work pretty much as before, little or no overhead (unless there are indexes and history size >> current data size)
      • updates should have about the same (2x?) overhead in partitioned and non-partitioned case
      • selects should have little or no overhead in partitioned case, and notable overhead in non-partitioned case (with history size >> current data size)
      • deletes should have little overhead in non-partitioned case, and notable overhead (2x?) in partitioned case
      • versioning by transaction id has more overhead as compared with versioning by timestamps

      Attachments

        1. MDEV-15690-4.ods
          88 kB
          Axel Schwenke
        2. MDEV-15690-5.ods
          88 kB
          Axel Schwenke

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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