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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.38, 10.0.12
    • Fix Version/s: 10.0.13
    • Component/s: None
    • Labels:
      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

            • Assignee:
              monty Michael Widenius
              Reporter:
              serg Sergei Golubchik
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: