[MDEV-6504] very slow shutdown when using 100,000 MyISAM tables with delay_key_write Created: 2014-07-29  Updated: 2014-07-30  Resolved: 2014-07-30

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.38, 10.0.12
Fix Version/s: 10.0.13

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Michael Widenius
Resolution: Fixed Votes: 0
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



 Comments   
Comment by Sergei Golubchik [ 2014-07-29 ]

ok to push

Comment by Michael Widenius [ 2014-07-30 ]

Pushed into 10.0 tree

Generated at Thu Feb 08 07:12:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.