TencentDB for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Database Architecture
- Database Instance
- Kernel Features
- Kernel Version Release Notes
- Functionality Features
- Performance Features
- Parallel Query
- Security Features
- Stability Features
- Purchase Guide
- Getting Started
- Connecting to MySQL Instance
- Database Audit
- Audit Rule Template
- MySQL Cluster Edition
- Maintenance Management Instance
- Operation Guide
- Instance Management and Maintenance
- Instance Upgrade
- CPU Elastic Expansion
- Read-Only/Disaster Recovery Instances
- Database Proxy
- Database Proxy Kernel Features
- Database Proxy Management
- Automatic Read/Write Separation Feature
- Connection Pool Feature
- Other Features
- Account Management
- Database Management Center (DMC)
- Parameter Configuration
- Network and Security
- Backup and Rollback
- Restoring Database from Backup File
- Monitoring and Alarms
- Operation Logs
- Practical Tutorial
- Calling MySQL APIs in Python
- White Paper
- Performance White Paper
- Performance Test Report
- Troubleshooting
- Connections
- API Documentation
- Data Import APIs
- Rollback APIs
- Parameter APIs
- Making API Requests
- Instance APIs
- Database Proxy APIs
- Database Audit APIs
- Security APIs
- Account APIs
- Backup APIs
- Database APIs
- Monitoring APIs
- Log-related API
- FAQs
- Backup
- Connection and Login
- Instance Upgrade
- Performance and Memory
- Service Agreement
- Reference
Buffer Pool Initialization
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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No