RDS for MySQL
RDS for MySQL
RDS for MySQL
Document
What's new
Announcement
Product introduction
Product billing
Billing method
Kernel functions
Feature
Stability
Performance
Quick start
User guide
Managing instances
Changing an instance configuration
Upgrading kernel versions
Managing tags
Managing disaster instances
Managing blue-green deployment
Migrating data
Managing connections
Database proxy
Connecting to an instance
Managing connection endpoints
Diagnosing connections
Managing connection pool modes
Managing access addresses and ports
Managing databases
Account and access authorization
Backup recovery
Backup data
Data recovery
Service availability
Managing logs
Managing data security
Managing allowlists
Configuring SSL encryption
Managing parameters
Monitoring and alerts
Task center
Operation and maintenance events
Backups of deleted instances
Managing cross-regional backups
API reference
V2（2022-01-01）
Global management
Managing instances
Managing connections
Managing accounts
Managing databases
Security encryption
Backup and recovery
Managing parameters
Managing tasks
Event management
Managing logs
Resource plan management
Appendix
SDK reference
Developer tools
Best practice
Performance document
Troubleshooting
- Documentation
RDS for MySQLKernel functionsPerformanceBuffer pool initialization process performance optimization
Copy page
Download PDFPerformance
Buffer pool initialization process performance optimization
Copy pageDownload PDFBuffer pool initialization process performance optimization
This topic describes the buffer pool initialization process performance optimization feature of RDS for MySQL.
Background
A restart is required when upgrading MySQL or modifying certain parameters. When MySQL restarts, it runs a series of processes, such as buffer pool initialization. MySQL becomes available for service only after these processes are complete. Therefore, the performance of the buffer pool initialization process is crucial to the availability of the MySQL instance. This feature speeds up the buffer pool initialization process, reduces MySQL startup time, and enhances the availability of MySQL instances.
Supported version
- MySQL 5.7 version, and the kernel version is MySQL 5.7.32_20250415 and above.
- MySQL 8.0 version, and the kernel version is MySQL 8.0.32_20250415 and above.
- MySQL 8.4, with a kernel minor version of MySQL 8.4.7_20260415 or later.
tip
You can view the kernel minor version of an instance by Viewing instance information. If the kernel minor version of your instance is not within the supported kernel minor version range, you can Manually upgrading the instance kernel minor version.
Prerequisites
An instance has been created and the state of the instance is Running.
Instructions
Modify the running value of the loose_buffer_pool_lazy_block_locks_init parameter to ON to enable performance optimization for the buffer pool initialization process.
Parameter name | Default value | Does it need instance restart to take effect? | Value range | Scope | Parameter description |
loose_buffer_pool_lazy_block_locks_init | OFF | Yes | [ON|OFF] | Global | Enables or disables performance optimization for the buffer pool initialization process. |
tip
This parameter is not open for modification. To modify it, submit a ticket to contact technical support.
Performance test
The test environment is a MySQL 5.7 instance. For instances of different specifications, the elapsed time of the buffer pool initialization process before and after this feature is enabled is as follows:
Last updated: 2026.05.28 15:17:49
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
