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

Split the fts cache to avoid excessive memory growth during sync

    XMLWordPrintable

Details

    Description

      Sync operation locks fts cache, reads one row from cache, releases fts cache. By doing frequent unlock, Incoming DML commit can increase the cache
      memory by adding doc ids to cache. This leads to longer sync operation and memory growth.

      To address this issue, InnoDB can have 2 cache. When InnoDB does sync operation, it can use already filled one cache and incoming DML
      thread can use other cache for adding the doc ids. Here sync operation doesn't have to release the cache lock and it can be done atomically.

      Note:
      InnoDB should handle 2 cache while doing query read.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.