Skip to content

Commit 775d2e2

Browse files
committed
去掉参数thread_stack,增加innodb_spin_wait_delay参数
1 parent 3addc19 commit 775d2e2

7 files changed

Lines changed: 7 additions & 7 deletions

docs/my.cnf-example

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,6 @@ max_connections = 1024
3131
max_connect_errors = 1000000
3232
table_open_cache = 2048
3333
table_definition_cache = 2048
34-
thread_stack = 512K
3534
sort_buffer_size = 4M
3635
join_buffer_size = 4M
3736
read_buffer_size = 8M
@@ -141,6 +140,7 @@ innodb_status_output = 0
141140
innodb_status_output_locks = 1
142141
innodb_sort_buffer_size = 64M
143142
innodb_numa_interleave = ON
143+
innodb_spin_wait_delay = 20
144144

145145
#innodb monitor settings
146146
#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"

docs/my.cnf-example-greatsql-5.7.36

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -24,7 +24,6 @@ max_connections = 512
2424
max_connect_errors = 1000000
2525
table_open_cache = 1024
2626
table_definition_cache = 1024
27-
thread_stack = 512K
2827
sort_buffer_size = 4M
2928
join_buffer_size = 4M
3029
read_buffer_size = 8M
@@ -113,3 +112,4 @@ innodb_print_all_deadlocks = 1
113112
innodb_status_file = 1
114113
innodb_adaptive_hash_index = 0
115114
innodb_numa_interleave = ON
115+
innodb_spin_wait_delay = 20

docs/my.cnf-example-greatsql-8.0.25-15

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,6 @@ max_connections = 1024
3131
max_connect_errors = 1000000
3232
table_open_cache = 2048
3333
table_definition_cache = 2048
34-
thread_stack = 512K
3534
sort_buffer_size = 4M
3635
join_buffer_size = 4M
3736
read_buffer_size = 8M
@@ -137,6 +136,7 @@ innodb_status_output_locks = 1
137136
innodb_sort_buffer_size = 64M
138137
innodb_adaptive_hash_index = 0
139138
innodb_numa_interleave = ON
139+
innodb_spin_wait_delay = 20
140140

141141
#innodb monitor settings
142142
#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"

docs/my.cnf-example-greatsql-8.0.25-16

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,6 @@ max_connections = 1024
3131
max_connect_errors = 1000000
3232
table_open_cache = 2048
3333
table_definition_cache = 2048
34-
thread_stack = 512K
3534
sort_buffer_size = 4M
3635
join_buffer_size = 4M
3736
read_buffer_size = 8M
@@ -145,6 +144,7 @@ innodb_status_output_locks = 1
145144
innodb_sort_buffer_size = 64M
146145
innodb_adaptive_hash_index = 0
147146
innodb_numa_interleave = ON
147+
innodb_spin_wait_delay = 20
148148

149149
#innodb monitor settings
150150
#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"

docs/my.cnf-example-greatsql-8.0.25-17

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,6 @@ max_connections = 1024
3131
max_connect_errors = 1000000
3232
table_open_cache = 2048
3333
table_definition_cache = 2048
34-
thread_stack = 512K
3534
sort_buffer_size = 4M
3635
join_buffer_size = 4M
3736
read_buffer_size = 8M
@@ -145,6 +144,7 @@ innodb_status_output_locks = 1
145144
innodb_sort_buffer_size = 64M
146145
innodb_adaptive_hash_index = 0
147146
innodb_numa_interleave = ON
147+
innodb_spin_wait_delay = 20
148148

149149
#innodb monitor settings
150150
#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"

docs/my.cnf-example-greatsql-8.0.32-24

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,6 @@ max_connections = 1024
3131
max_connect_errors = 1000000
3232
table_open_cache = 2048
3333
table_definition_cache = 2048
34-
thread_stack = 512K
3534
sort_buffer_size = 4M
3635
join_buffer_size = 4M
3736
read_buffer_size = 8M
@@ -164,6 +163,7 @@ innodb_sort_buffer_size = 64M
164163
innodb_adaptive_hash_index = 0
165164
#开启NUMA支持
166165
innodb_numa_interleave = ON
166+
innodb_spin_wait_delay = 20
167167
innodb_print_lock_wait_timeout_info = 1
168168
#自动杀掉超过5分钟不活跃事务,避免行锁被长时间持有
169169
kill_idle_transaction = 300

docs/my.cnf-example-greatsql-8.0.32-25

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -32,7 +32,6 @@ max_connections = 1024
3232
max_connect_errors = 1000000
3333
table_open_cache = 2048
3434
table_definition_cache = 2048
35-
thread_stack = 512K
3635
sort_buffer_size = 4M
3736
join_buffer_size = 4M
3837
read_buffer_size = 8M
@@ -184,6 +183,7 @@ innodb_sort_buffer_size = 64M
184183
innodb_adaptive_hash_index = 0
185184
#开启NUMA支持
186185
innodb_numa_interleave = ON
186+
innodb_spin_wait_delay = 20
187187
innodb_print_lock_wait_timeout_info = 1
188188
#自动杀掉超过5分钟不活跃事务,避免行锁被长时间持有
189189
kill_idle_transaction = 300

0 commit comments

Comments
 (0)