Re: Is there any command to flush innodb buffer pool manually?

[shruti nimbalkar]

is there any parameters that can be set to flush the buffer pool continuosly.
The below link suggest some to specific mysql version.
I wanted to know for mysql 8

https://stackoverflow.com/questions/10542853/how-to-clear-flush-mysql-innodb-buffer-pool

=============================================================
WARNING : The following only works for MySQL 5.5 and MySQL 5.1.41+ (InnoDB Plugin)

Tweek the duration of entries in the InnoDB Buffer Pool with these settings:

SET GLOBAL innodb_old_blocks_time=250; // This is 0.25 seconds
SET GLOBAL innodb_old_blocks_pct=5;
SET GLOBAL innodb_max_dirty_pages_pct=0;
When you are done testing, setting them back to the defaults:

SET GLOBAL innodb_old_blocks_time=0;
SET GLOBAL innodb_old_blocks_pct=37;
SET GLOBAL innodb_max_dirty_pages_pct=90; // 75 for MySQL 5.5/MySQL 5.1 InnoDB Plugin

=========================================================