Setting Innodb Buffer Pool Size Dynamically
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.2.2
The InnoDB Buffer Pool size can now be set dynamically.
Resizing the buffer pool is performed in chunks determined by the size of the innodb_buffer_pool_chunk_size variable.
- The resize operation waits until all active transactions and operations are completed.
- New transactions and operations that need to access the buffer pool must wait until the resize is complete (although the defragment stage, and the page withdrawal stage, do permit access).
- Nested transactions may fail if started after the buffer pool resize has begun.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
