GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Can buffer pool load times be improved by some setting?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can buffer pool load times be improved by some setting?

    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


Working...
X