Skip to content

InnoDB Startup Options

darnaut edited this page Nov 15, 2012 · 2 revisions

InnoDB-related startup command options. Boolean options can be enabled at server startup by naming them, or disabled by using a --skip- prefix.

Name Cmd-Line Option file System Var Status Var Var Scope Dynamic
innodb_buffer_pool_populate Yes Yes Yes No Global No

innodb_buffer_pool_populate

Preallocate (pre-fault) the page frames required for the mapping established by the buffer pool memory region.

Command-Line Format --innodb_buffer_pool_populate
Option-File Format innodb_buffer_pool_populate
Option Sets Variable Yes, innodb_buffer_pool_populate
Variable Name innodb_buffer_pool_populate
Variable Scope Global
Dynamic Variable No
Type boolean
Default OFF
Valid Values ON