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

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