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

Add timer for Insert Cache flush

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 6.2.3
    • 23.10
    • cache_insert
    • None

    Description

      1) Add timer to flush every time period. (in seconds)
      2) Add option to not flush upon select.
      3) Ensure at least one of the above is on, but allow for both.

      Suggested names for variables are:
      columnstore_cache_flush_type=SELECT
      columnstore_cache_flush_type=TIMER
      columnstore_cache_flush_type=BOTH <default>
      columnstore_cache_flush_time=300

      Documentation: When Cache Insert is on, all traffic should go to primary PM only.

      If columnstore_cache_flush_type=SELECT, MaxScale can be configured using the CCR filter:

      https://mariadb.com/kb/en/mariadb-maxscale-2208-consistent-critical-read-filter/

      Attachments

        Issue Links

          Activity

            People

              leonid.fedorov Leonid Fedorov
              David.Hall David Hall (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.