tencent cloud

Parallel Initialization of InnoDB Buffer Pool
Last updated: 2024-06-17 16:31:45
Parallel Initialization of InnoDB Buffer Pool
Last updated: 2024-06-17 16:31:45

Overview

This feature speeds up the initialization of the buffer pool, reducing the startup time of the database instance.

Supported Versions

TDSQL-C for MySQL 5.7 (kernel version 2.0.23/2.1.9) or later.

Use Cases

This feature is used to speed up the startup of the database instance.

Performance Test Data

Performance test data collected from eight instances:
buffer_pool_size
Buffer Pool Initialization Time (Before Optimization)
Buffer Pool Initialization Time (After Optimization)
Speed Enhancement
50GB
2.55s
0.13s
1962%
200GB
10.28s
0.52s
1977%
500GB
25.72s
1.32s
1948%

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback