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

cache instances being ignored

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.11
    • N/A
    • Server
    • None
    • Linux

    Description

      I get this when writing to a very large RocksDB table, from many connections
      [Note] Detected table cache mutex contention at instance 1: 28% waits. Additional table cache instance activated. Number of instances after activation: 2.
      2018-12-25 20:19:00 51 [Note] Detected table cache mutex contention at instance 2: 20% waits. Additional table cache instance activated. Number of instances after activation: 3.

      but my configuration is

      -----------------------------------------------+----------+
      | rocksdb_force_compute_memtable_stats_cachetime | 60000000 |
      | rocksdb_table_cache_numshardbits               | 19        |
      | table_definition_cache                         | 400      |
      | table_open_cache                               | 2000     |
      | table_open_cache_instances                     | 24        |
      +------------------------------------------------+----------+
      

      I get those errors almost right away. I insert records from 64 connections using GNU parallels

      Attachments

        Activity

          People

            Unassigned Unassigned
            philip_38 Philip orleans
            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.