InnoDB Prefetch Pages

The prefetch_pages command may be use to prefetch (retrieve from disk) index and data pages into the buffer pool. The command synchronously waits for pages to be read and returns the number of pages read. The goal of prefetching is to simulate an initial warm-up period to populate the buffer pool and other structures.

mysql> SELECT ENGINE_CONTROL(InnoDB, prefetch_pages, 0, 1);

In the future this command might be changed to be part of statements that manipulate tablespaces.