Release Notes and Announcements
- Release Notes
- Product Announcements
User Tutorial
Product Introduction
- Overview
- Strengths
- Use Cases
- Database Architecture
- Resource Isolation Policy
- Economical Instance
- Feature List
- Database Instance
- High Availability (Multi-AZ)
- Regions and AZs
- Service Regions and Service Providers
Kernel Features
- Overview
- Kernel Version Release Notes
- Functionality Features
- Performance Features
- Security Features
- Stability Features
- TXRocks Engine
- LibraDB Engine
- Checking and Fixing Kernel Issues
Purchase Guide
Getting Started
- Overview
- Creating MySQL Instance
- Connecting to MySQL Instance
SQL Insight (Database Audit)
MySQL Cluster Edition
Operation Guide
- Use Limits
- Operation Overview
- Instance Management and Maintenance
- Instance Upgrade
- CPU Elastic Expansion
- Read-Only/Disaster Recovery Instances
- Database Proxy
- Database Management Center (DMC)
- Account Management
- Parameter Configuration
- Backup and Rollback
- Data Migration
- Network and Security
- Monitoring and Alarms
- Log Center
- Read-Only Analysis Engine
- Tag
Practical Tutorial
White Paper
- Performance White Paper
- Security White Paper
Troubleshooting
- Connections
- Performance
- Instance Data Sync Delay
- Failure to Enable Case Insensitivity
- Failure to Obtain slow_query_log_file via a Command
API Documentation
- History
- Introduction
- API Category
- Instance APIs
- Making API Requests
- Data Import APIs
- Database Proxy APIs
- Database Audit APIs
- Security APIs
- Task APIs
- Backup APIs
- Account APIs
- Rollback APIs
- Parameter APIs
- Database APIs
- Monitoring APIs
- Log-related API
- Data Types
- Error Codes
FAQs
- Related to Selection
- Billing
- Backup
- Rollback
- Connection and Login
- Parameter Modifications
- Instance Upgrade
- Account Permissions
- Performance and Memory
- Ops
- Data Migration
- Features
- Console Operations
- Logs
- Event
- Database audit
- Instance Switch Impact
- API 2.0 to 3.0 Switch Guide
Service Agreement
- Service Level Agreement
- Terms of Service
Reference
- Standards and Certifications
Contact Us
Glossary

Buffer Pool Initialization

Focus Mode

Font Size

Last updated: 2024-07-22 12:36:19

Overview
This feature speeds up the initialization of the buffer pool, reducing the startup time of the database instance.
Supported versions
Kernel version: MySQL 5.6 20200915 and above.
Kernel version: MySQL 5.7 20200630 and above.
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)
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%
Instructions
This feature is enabled in the kernel by default.

Help and Support

Was this page helpful?

You can also Contact sales or Submit a Ticket for help.

Help us improve! Rate your documentation experience in 5 mins.

Feedback

tencent cloud

TencentDB for MySQL

Buffer Pool Initialization

Overview

Supported versions

Use Cases

Performance Test Data

Instructions

Help and Support

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%