innodb_buffer_pool_restore_at_startup
- Description: Time in seconds between automatic buffer pool dumps. If set to a non-zero value,
XtraDB will also perform an automatic restore of the buffer pool at
startup. If set to
0
, automatic dumps are not performed, nor automatic restores on startup.
Replaced by innodb_buffer_pool_load_at_startup in MariaDB 10.0.
- Commandline:
innodb-buffer-pool-restore-at-startup
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
0
- Range - 32 bit:
0
to 4294967295
- Range - 64 bit:
0
to 18446744073709547520
- Removed: MariaDB 10.0 - replaced by innodb_buffer_pool_load_at_startup
myisam_mmap_size
- Description: Maximum memory in bytes that can be used for memory mapping compressed MyISAM
files. Too high a value may result in swapping if there are many compressed MyISAM tables.
- Commandline:
--myisam-mmap-size=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value - 32 bit:
4294967295
- Default Value - 64 bit:
18446744073709547520
- Range - 32-bit:
7
to 4294967295
- Range - 64-bit:
7
to 18446744073709547520