Not the answer you need?
Register and ask your own question!

Can buffer pool load times be improved by some setting?

_ck__ck_ EntrantCurrent User Role Beginner
The buffer pool save/load that Percona first introduced and then was put into the general MySQL 5.6 codebase is a great idea.

I am not sure where to look in the 5.6 code but is there a disk buffer that can be increased to improve buffer pool load times?

This is for a 90GB cache, it takes roughly 40 to 50 minutes, which is "only" 30-40MB/sec

04:22:05 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
05:29:10 InnoDB: Buffer pool(s) load completed at 5:29:10

03:54:34 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
04:39:54 InnoDB: Buffer pool(s) load completed at 4:39:54

04:49:01 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
05:26:59 InnoDB: Buffer pool(s) load completed at 5:26:59

03:32:01 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
04:50:49 InnoDB: Buffer pool(s) load completed at 4:50:49

02:32:04 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
03:41:20 InnoDB: Buffer pool(s) load completed at 3:41:20
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.