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

very slow shutdown when using 100,000 MyISAM tables with delay_key_write

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.1.67, 5.2.14, 5.3.12, 5.5.38, 10.0.12
    • 10.0.13
    • None
    • None

    Description

      Changeset:

      Committer: Michael Widenius
      Date: 2014-07-19 14:46:08 UTC
      Revision ID: monty@askmonty.org-20140719144608-0zhpsl5v9oubpxzv
       
      Fixed problem with very slow shutdown when using 100,000 MyISAM tables
      with delay_key_write
       
      Reason for the problem was that the hash of changed files in the key
      cache was too small (was 128). Fixed by making the hash size larger
      and changeable.
       
      - Introduced key-cache-file-hash-size (default 512) for MyISAM and
        aria_pagecache_file_hash_size (default 512) for Aria.
      - Added new status variable "Feature_delay_key_write" which counts
        number of tables opened that are using delay_key_write

      Attachments

        Activity

          People

            monty Michael Widenius
            serg Sergei Golubchik
            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.