Description:
Add an option to sort dumped InnoDB buffer pool pages by MRU.
Currently when dumping pages MySQL is sorting InnoDB buffer pool pages in order to reduce the number of seeks when the pages are loaded again.
We have an Enterprise Edition client where it is taking an exceptionally long time to reload the InnoDB buffer pool pages when MySQL is restarted. The most important pages (the ones that were most recently used) might not be loaded for many hours following a restart.
We are requesting an option so that DBAs can decide if they want these pages to be sorted by MRU instead.
That way the most important pages can be loaded first so that users can start using the system almost immediately while the LRU pages are still loading.
How to repeat:
Load a huge number of pages into the InnoDB buffer pool pages.
Perform queries which would take a long time to perform when the pages have not already been loaded into the InnoDB buffer pool pages.
Restart MySQL.
Repeat those same queries that you were doing right before restarting MySQL.
Suggested fix:
Add an option so that DBAs can decide if they want these pages to be sorted by MRU instead.
