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
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                ok to push

                Show
                serg Sergei Golubchik added a comment - ok to push
                Hide
                Permalink
                monty Michael Widenius added a comment -

                Pushed into 10.0 tree

                Show
                monty Michael Widenius added a comment - Pushed into 10.0 tree

                  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:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 2 hours
                      2h