Shared Memory Buffer Pool

The SHM buffer pool patch, which provided the ability to use a shared memory segment for the buffer pool to enable faster server restarts, has been removed. Instead, we recommend using the LRU Dump/Restore patch which provides similar improvements in restart performance.

Replacement is due to SHM buffer pool both being very invasive and not widely used. Improved restart times are better provided by the much safer LRU D/R patch which has the advantage of also persisting across machine restarts.

The configuration variables for my.cnf have been kept for compatibility and warnings will be printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used.

Instructions for disabling the SHM buffer pool can be found here.

Instructions on setting up LRU dump/restore can be found here.

Version Specific Information

  • 5.5.8-20.0: First Percona Server 5.5 release, also included Shared Memory Buffer Pool.
  • 5.5.13-20.4: Feature removed, as LRU Dump/Restore is less invasive, more reliable and a better solution.

System Variables

variable innodb_buffer_pool_shm_key
Command Line:Yes
Config File:Yes
Scope:Global
Dynamic:No
Variable Type:Boolean
Default Value:OFF
Range:ON/OFF
variable innodb_buffer_pool_shm_checksum
Command Line:Yes
Config File:Yes
Scope:Global
Dynamic:No
Variable Type:Boolean
Default Value:ON
Range:ON/OFF
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Thread Based Profiling

Next topic

Multiple Rollback Segments

This Page



© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>