去掉参数thread_stack，增加innodb_spin_wait_delay参数

GreatSQL · GreatSQL · commit 775d2e2e9e73 · 2024-07-10T12:30:23.000+08:00
diff --git a/docs/my.cnf-example b/docs/my.cnf-example
@@ -31,7 +31,6 @@ max_connections = 1024
 max_connect_errors = 1000000
 table_open_cache = 2048
 table_definition_cache = 2048
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -141,6 +140,7 @@ innodb_status_output = 0
 innodb_status_output_locks = 1
 innodb_sort_buffer_size = 64M
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
 
 #innodb monitor settings
 #innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash"
diff --git a/docs/my.cnf-example-greatsql-5.7.36 b/docs/my.cnf-example-greatsql-5.7.36
@@ -24,7 +24,6 @@ max_connections = 512
 max_connect_errors = 1000000
 table_open_cache = 1024
 table_definition_cache = 1024
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -113,3 +112,4 @@ innodb_print_all_deadlocks = 1
 innodb_status_file = 1
 innodb_adaptive_hash_index = 0
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
diff --git a/docs/my.cnf-example-greatsql-8.0.25-15 b/docs/my.cnf-example-greatsql-8.0.25-15
@@ -31,7 +31,6 @@ max_connections = 1024
 max_connect_errors = 1000000
 table_open_cache = 2048
 table_definition_cache = 2048
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -137,6 +136,7 @@ innodb_status_output_locks = 1
 innodb_sort_buffer_size = 64M
 innodb_adaptive_hash_index = 0
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
 
 #innodb monitor settings
 #innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash"
diff --git a/docs/my.cnf-example-greatsql-8.0.25-16 b/docs/my.cnf-example-greatsql-8.0.25-16
@@ -31,7 +31,6 @@ max_connections = 1024
 max_connect_errors = 1000000
 table_open_cache = 2048
 table_definition_cache = 2048
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -145,6 +144,7 @@ innodb_status_output_locks = 1
 innodb_sort_buffer_size = 64M
 innodb_adaptive_hash_index = 0
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
 
 #innodb monitor settings
 #innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash"
diff --git a/docs/my.cnf-example-greatsql-8.0.25-17 b/docs/my.cnf-example-greatsql-8.0.25-17
@@ -31,7 +31,6 @@ max_connections = 1024
 max_connect_errors = 1000000
 table_open_cache = 2048
 table_definition_cache = 2048
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -145,6 +144,7 @@ innodb_status_output_locks = 1
 innodb_sort_buffer_size = 64M
 innodb_adaptive_hash_index = 0
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
 
 #innodb monitor settings
 #innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash"
diff --git a/docs/my.cnf-example-greatsql-8.0.32-24 b/docs/my.cnf-example-greatsql-8.0.32-24
@@ -31,7 +31,6 @@ max_connections = 1024
 max_connect_errors = 1000000
 table_open_cache = 2048
 table_definition_cache = 2048
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -164,6 +163,7 @@ innodb_sort_buffer_size = 64M
 innodb_adaptive_hash_index = 0
 #开启NUMA支持
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
 innodb_print_lock_wait_timeout_info = 1
 #自动杀掉超过5分钟不活跃事务，避免行锁被长时间持有
 kill_idle_transaction = 300
diff --git a/docs/my.cnf-example-greatsql-8.0.32-25 b/docs/my.cnf-example-greatsql-8.0.32-25
@@ -32,7 +32,6 @@ max_connections = 1024
 max_connect_errors = 1000000
 table_open_cache = 2048
 table_definition_cache = 2048
-thread_stack = 512K
 sort_buffer_size = 4M
 join_buffer_size = 4M
 read_buffer_size = 8M
@@ -184,6 +183,7 @@ innodb_sort_buffer_size = 64M
 innodb_adaptive_hash_index = 0
 #开启NUMA支持
 innodb_numa_interleave = ON
+innodb_spin_wait_delay = 20
 innodb_print_lock_wait_timeout_info = 1
 #自动杀掉超过5分钟不活跃事务，避免行锁被长时间持有
 kill_idle_transaction = 300
