tencent cloud
Promotions
Products
Solutions
Pricing
Partner Network
CloudApp
Explore
Prev
Next
Help us improve! Rate your documentation experience in 5 mins. |Start Now
Parallel Initialization of InnoDB Buffer Pool
Download PDF
Last updated: 2024-06-17 16:31:45
Parallel Initialization of InnoDB Buffer Pool
Last updated: 2024-06-17 16:31:45
Download PDF
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