InnoDB System Variables ib_buffer_pool  and is located in the  InnoDB data directory. A non-default location must be specified relative to the data directory. A file name can be specified at runtime, using a  SET  statement: You can also specify a file name at startup, in a startup string or MySQL configuration file. When specifying a file name at startup, the file must exist or  InnoDB  returns a startup error indicating that there is no such file or directory. For more information, see Section 15.8.3.6, “Saving and Restoring the Buffer Pool State” . Disabling the  innodb_buffer_pool_in_core_file  variable reduces the size of core files by excluding  InnoDB buffer pool pages. To use this variable, the  core_file  variable must be enabled and the operating system must support the  MADV_DONTDUMP  non-POSIX extension to  madvise() , which is supported in Linux 3.4 and later. For more information, see Section 15.8.3.7, “Excluding Buffer Pool Pages from Core Files” . The number of regions that the  InnoDB  buffer pool is divided into. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency, by reducing contention as different threads read and write to cached pages. Each page that is stored in or read from the buffer pool is assigned to one of the buffer pool instances randomly, using a hashing 3224 SET GLOBAL innodb_buffer_pool_filename= ’file_name’ ; • innodb_buffer_pool_in_core_file • innodb_buffer_pool_instances Command-Line Format --innodb-buffer-pool-in-core- file[={OFF|ON}] Introduced 8.0.14 System Variable innodb_buffer_pool_in_core_file Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value ON Command-Line Format --innodb-buffer-pool-instances=# System Variable innodb_buffer_pool_instances Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value (Windows, 32-bit platforms) (autosized) Default Value (Other) 8 (or 1 if innodb_buffer_pool_size < 1GB) Minimum Value 1 Maximum Value 64