InnoDB Monitoring buffer Pool Load Progress

You can use the relevant information in the performance schema to monitor the buffer pool state loading process.

1. Enable Stage/innodb/buffer Pool load instrument:

2. Enable the stage event consumer related tables, including Events_stages_current,events_stages_history and Events_stages_history_long.

3. With Innodb_buffer_pool_dump_now=on, save the current state of the buffer pool and view its status:

4. Load the "restore" buffer pool status information via Innodb_buffer_pool_load_now=on and view

5 Check the current state of the buffer pool being restored by querying the Performance_schema.events_stages_current table. Returns NULL if the restore is complete.

If you are finished, you can query the Events_stages_history table.

InnoDB Monitoring buffer Pool Load Progress