This feature speeds up the initialization of the buffer pool, reducing the startup time of the database instance.
This feature is used to speed up the startup of the database instance.
Performance test data collected from eight instances:
|buffer_pool_size||Buffer Pool Initialization Time (Before Optimization)||Buffer Pool Initialization Time (After Optimization)||Increase (%)|
|50 GB||2.55 s||0.13 s||1,962%|
|200 GB||10.28 s||0.52 s||1,977%|
|500 GB||25.72 s||1.32 s||1,948%|
This feature is enabled in the kernel by default.