[MDEV-9768] Fix MySQL bug #80784: Parallelize buffer pool initialization Created: 2016-03-21  Updated: 2016-11-01  Resolved: 2016-11-01

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 10.0, 10.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: upstream


 Description   

Buffer pool initialization is single-threaded and may take minutes on
systems with large buffer pools. Startup time of often precious in
production systems, so any ways to decrease it can have considerable
effect.

One low-hanging fruit to optimize it would be to initialize buffer pool
instances in parallel threads. Which would result in roughly 8 times
speedup for the default innodb_buffer_pool_instances value.

 Comments   
Comment by Jan Lindström (Inactive) [ 2016-11-01 ]

Idea is good but actual implementation proved to be bad. While this can be parallelized it is bad for performance.

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