Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.0(EOL), 10.1(EOL)
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.