mirror of
https://github.com/MariaDB/server.git
synced 2025-04-20 22:25:30 +02:00
ba81009f63
innodb_buffer_pool_size_auto_min: A minimum innodb_buffer_pool_size that a Linux memory pressure event can lead to shrinking the buffer pool to. On a memory pressure event, we will attempt to shrink innodb_buffer_pool_size halfway between its current value and innodb_buffer_pool_size_auto_min. If innodb_buffer_pool_size_auto_min is specified as 0 or not specified on startup, its default value will be adjusted to innodb_buffer_pool_size_max, that is, memory pressure events will be disregarded by default. buf_pool_t::garbage_collect(): For up to 15 seconds, attempt to shrink the buffer pool in response to a memory pressure event. Reviewed by: Debarun Banerjee
11 lines
485 B
Text
11 lines
485 B
Text
--- mem_pressure.result
|
|
+++ mem_pressure,32bit.result
|
|
@@ -11,7 +11,7 @@
|
|
@@GLOBAL.innodb_buffer_pool_size_auto_min,
|
|
@@GLOBAL.innodb_buffer_pool_size_max;
|
|
@@GLOBAL.innodb_buffer_pool_size @@GLOBAL.innodb_buffer_pool_size_auto_min @@GLOBAL.innodb_buffer_pool_size_max
|
|
-17825792 16777216 25165824
|
|
+17825792 16777216 18874368
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
|
|
SET GLOBAL innodb_limit_optimistic_insert_debug=2;
|
|
SET STATEMENT unique_checks=0, foreign_key_checks=0 FOR
|