Bug #111720 recv_n_pool_free_frames are not maintained correctly

• Submitted: 11 Jul 2023 13:43
• Modified: 11 Jul 2023 14:17
• Reporter: alex xing (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S5 (Performance)
• Version: 8.0.33
• OS: Any
• CPU Architecture: Any

[11 Jul 2023 13:43] alex xing

Description:
from source code :
/** This many frames must be left free in the buffer pool when we scan
the log and store the scanned log records in the buffer pool: we will
use these free frames to read in pages when we start applying the
log records to the database.
This is the default value. If the actual size of the buffer pool is
larger than 10 MB we'll set this value to 512. */
ulint recv_n_pool_free_frames;

The comment says that the recv_n_pool_free_frames value could be 512, but in reality it can only be 256

How to repeat:
just read the code

Suggested fix:
Re-maintain recv_n_pool_free_frames or modify comments

[11 Jul 2023 14:17] MySQL Verification Team

Hello Alex Xing,

Thank you for the report and feedback.

regards,
umesh