github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/deploy/apecloud-mysql/config/mysql8-config-effect-scope.yaml (about) 1 ## staticParameters, list of StaticParameter, modifications of them trigger a process restart. 2 ## dynamicParameters, list of DynamicParameter, modifications of them trigger a config dynamic reload without process restart. 3 ## staticParameters and dynamicParameters determine the behavior of parameter changes: 4 ## if any of the modified parameters is in the staticParameters list, this operation will trigger a process restart. 5 ## if all the changed parameters are in the dynamicParameters list, this change executes reload without process restart. 6 ## if the above two conditions are not met, by default, parameter change operation follow the rule for using staticParameters. 7 staticParameters: 8 - xengine 9 - smartengine 10 - loose_smartengine 11 - allow-suspicious-udfs 12 - auto_generate_certs 13 - back_log 14 - basedir 15 - bind_address 16 - binlog_gtid_simple_recovery 17 - caching_sha2_password_auto_generate_rsa_keys 18 - caching_sha2_password_private_key_path 19 - caching_sha2_password_public_key_path 20 - character-set-client-handshake 21 - character_sets_dir 22 - core-file 23 - datadir 24 - default_authentication_plugin 25 - default_time_zone 26 - disabled_storage_engines 27 - disconnect_on_expired_password 28 - enforce_gtid_consistency 29 - explicit_defaults_for_timestamp 30 - ft_max_word_len 31 - ft_min_word_len 32 - ft_query_expansion_limit 33 - ft_stopword_file 34 - gtid-mode 35 - gtid_owned 36 - init_file 37 - innodb_adaptive_hash_index_parts 38 - innodb_autoinc_lock_mode 39 - innodb_buffer_pool_chunk_size 40 - innodb_buffer_pool_instances 41 - innodb_buffer_pool_load_at_startup 42 - innodb_commit_concurrency 43 - innodb_data_file_path 44 - innodb_data_home_dir 45 - innodb_dedicated_server 46 - innodb_directories 47 - innodb_doublewrite 48 - innodb_doublewrite_files 49 - innodb_doublewrite_pages 50 - innodb_flush_method 51 - innodb_force_load_corrupted 52 - innodb_force_recovery 53 - innodb_ft_cache_size 54 - innodb_ft_max_token_size 55 - innodb_ft_min_token_size 56 - innodb_ft_sort_pll_degree 57 - innodb_ft_total_cache_size 58 - innodb_log_files_in_group 59 - innodb_log_file_size 60 - innodb_log_group_home_dir 61 - innodb_open_files 62 - innodb_page_cleaners 63 - innodb_page_size 64 - innodb_purge_threads 65 - innodb_read_io_threads 66 - innodb_read_only 67 - innodb_rollback_on_timeout 68 - innodb_scan_directories 69 - innodb_sort_buffer_size 70 - innodb_stats_include_delete_marked 71 - innodb_sync_array_size 72 - innodb_temp_data_file_path 73 - innodb_undo_directory 74 - innodb_undo_tablespaces 75 - innodb_use_native_aio 76 - innodb_write_io_threads 77 - large_pages 78 - log_bin 79 - log-bin 80 - log_bin_basename 81 - log_bin_index 82 - log_bin_use_v1_row_events 83 - log_error 84 - log_slave_updates 85 - lower_case_file_system 86 - lower_case_table_names 87 - master-info-repository 88 - max_digest_length 89 - mecab_rc_file 90 - myisam_mmap_size 91 - mysqlx_bind_address 92 - mysqlx_port 93 - mysqlx_port_open_timeout 94 - mysqlx_socket 95 - mysqlx_ssl_ca 96 - mysqlx_ssl_capath 97 - mysqlx_ssl_cert 98 - mysqlx_ssl_crl 99 - mysqlx_ssl_crlpath 100 - mysqlx_ssl_key 101 - ngram_token_size 102 - old-style-user-limits 103 - open_files_limit 104 - performance_schema 105 - performance_schema_accounts_size 106 - performance_schema_digests_size 107 - performance_schema_error_size 108 - performance_schema_events_stages_history_long_size 109 - performance_schema_events_stages_history_size 110 - performance_schema_events_statements_history_long_size 111 - performance_schema_events_statements_history_size 112 - performance_schema_events_transactions_history_long_size 113 - performance_schema_events_transactions_history_size 114 - performance_schema_events_waits_history_long_size 115 - performance_schema_events_waits_history_size 116 - performance_schema_hosts_size 117 - performance_schema_max_cond_classes 118 - performance_schema_max_cond_instances 119 - performance_schema_max_digest_length 120 - performance_schema_max_file_classes 121 - performance_schema_max_file_handles 122 - performance_schema_max_file_instances 123 - performance_schema_max_index_stat 124 - performance_schema_max_memory_classes 125 - performance_schema_max_metadata_locks 126 - performance_schema_max_mutex_classes 127 - performance_schema_max_mutex_instances 128 - performance_schema_max_prepared_statements_instances 129 - performance_schema_max_program_instances 130 - performance_schema_max_rwlock_classes 131 - performance_schema_max_rwlock_instances 132 - performance_schema_max_socket_classes 133 - performance_schema_max_socket_instances 134 - performance_schema_max_sql_text_length 135 - performance_schema_max_stage_classes 136 - performance_schema_max_statement_classes 137 - performance_schema_max_statement_stack 138 - performance_schema_max_table_handles 139 - performance_schema_max_table_instances 140 - performance_schema_max_table_lock_stat 141 - performance_schema_max_thread_classes 142 - performance_schema_max_thread_instances 143 - performance_schema_session_connect_attrs_size 144 - performance_schema_setup_actors_size 145 - performance_schema_setup_objects_size 146 - performance_schema_users_size 147 - persisted_globals_load 148 - pid_file 149 - plugin_dir 150 - port 151 - protocol_version 152 - rds.optimized_writes 153 - relay_log 154 - relay-log 155 - relay_log_basename 156 - relay_log_index 157 - relay_log_info_file 158 - relay_log_info_repository 159 - relay_log_space_limit 160 - report_host 161 - report_password 162 - report_port 163 - report_user 164 - safe-user-create 165 - secure_file_priv 166 - sha256_password_auto_generate_rsa_keys 167 - sha256_password_private_key_path 168 - sha256_password_public_key_path 169 - skip-character-set-client-handshake 170 - skip_external_locking 171 - skip_name_resolve 172 - skip_show_database 173 - skip-slave-start 174 - slave_load_tmpdir 175 - slave_parallel_type 176 - slave_type_conversions 177 - socket 178 - ssl_ca 179 - ssl_capath 180 - ssl_cert 181 - ssl_cipher 182 - ssl_crl 183 - ssl_crlpath 184 - ssl_key 185 - sysdate-is-now 186 - system_time_zone 187 - table_open_cache_instances 188 - temptable_max_mmap 189 - thread_handling 190 - thread_stack 191 - tls_version 192 - tmpdir 193 - validate-password 194 - validate_password_dictionary_file 195 - version_comment 196 - version_compile_machine 197 - version_compile_os 198 - version_compile_zlib 199 200 dynamicParameters: 201 - activate_all_roles_on_login 202 - autocommit 203 - auto_increment_increment 204 - auto_increment_offset 205 - automatic_sp_privileges 206 - avoid_temporal_upgrade 207 - big_tables 208 - binlog_cache_size 209 - binlog_checksum 210 - binlog_direct_non_transactional_updates 211 - binlog_error_action 212 - binlog_expire_logs_seconds 213 - binlog_format 214 - binlog_group_commit_sync_delay 215 - binlog_group_commit_sync_no_delay_count 216 - binlog_max_flush_queue_time 217 - binlog_order_commits 218 - binlog_row_image 219 - binlog_row_metadata 220 - binlog_rows_query_log_events 221 - binlog_row_value_options 222 - binlog_stmt_cache_size 223 - binlog_transaction_dependency_history_size 224 - binlog_transaction_dependency_tracking 225 - block_encryption_mode 226 - bulk_insert_buffer_size 227 - character_set_client 228 - character_set_connection 229 - character_set_database 230 - character_set_filesystem 231 - character_set_results 232 - character_set_server 233 - check_proxy_users 234 - collation_connection 235 - collation_database 236 - collation_server 237 - completion_type 238 - concurrent_insert 239 - connect_timeout 240 - cte_max_recursion_depth 241 - default_collation_for_utf8mb4 242 - default_password_lifetime 243 - default_storage_engine 244 - default_tmp_storage_engine 245 - default_week_format 246 - delayed_insert_limit 247 - delayed_insert_timeout 248 - delayed_queue_size 249 - delay_key_write 250 - div_precision_increment 251 - end_markers_in_json 252 - eq_range_index_dive_limit 253 - event_scheduler 254 - expire_logs_days 255 - flush 256 - flush_time 257 - foreign_key_checks 258 - ft_boolean_syntax 259 - general_log 260 - general_log_file 261 - group_concat_max_len 262 - gtid_executed_compression_period 263 - gtid_mode 264 - gtid_purged 265 - histogram_generation_max_mem_size 266 - host_cache_size 267 - information_schema_stats_expiry 268 - init_connect 269 - init_slave 270 - innodb_adaptive_flushing 271 - innodb_adaptive_flushing_lwm 272 - innodb_adaptive_hash_index 273 - innodb_adaptive_max_sleep_delay 274 - innodb_autoextend_increment 275 - innodb_buffer_pool_dump_at_shutdown 276 - innodb_buffer_pool_dump_now 277 - innodb_buffer_pool_dump_pct 278 - innodb_buffer_pool_filename 279 - innodb_buffer_pool_load_abort 280 - innodb_buffer_pool_load_now 281 - innodb_buffer_pool_size 282 - innodb_change_buffering 283 - innodb_change_buffer_max_size 284 - innodb_checkpoint_disabled 285 - innodb_checksum_algorithm 286 - innodb_cmp_per_index_enabled 287 - innodb_compression_failure_threshold_pct 288 - innodb_compression_level 289 - innodb_compression_pad_pct_max 290 - innodb_concurrency_tickets 291 - innodb_ddl_log_crash_reset_debug 292 - innodb_deadlock_detect 293 - innodb_default_row_format 294 - innodb_disable_sort_file_cache 295 - innodb_doublewrite_batch_size 296 - innodb_fast_shutdown 297 - innodb_file_per_table 298 - innodb_fill_factor 299 - innodb_flushing_avg_loops 300 - innodb_flush_log_at_timeout 301 - innodb_flush_log_at_trx_commit 302 - innodb_flush_neighbors 303 - innodb_flush_sync 304 - innodb_ft_aux_table 305 - innodb_ft_enable_diag_print 306 - innodb_ft_enable_stopword 307 - innodb_ft_num_word_optimize 308 - innodb_ft_result_cache_limit 309 - innodb_ft_server_stopword_table 310 - innodb_ft_user_stopword_table 311 - innodb_io_capacity 312 - innodb_io_capacity_max 313 - innodb_lock_wait_timeout 314 - innodb_log_buffer_size 315 - innodb_log_checksums 316 - innodb_log_compressed_pages 317 - innodb_log_spin_cpu_abs_lwm 318 - innodb_log_spin_cpu_pct_hwm 319 - innodb_log_wait_for_flush_spin_hwm 320 - innodb_log_write_ahead_size 321 - innodb_lru_scan_depth 322 - innodb_max_dirty_pages_pct 323 - innodb_max_dirty_pages_pct_lwm 324 - innodb_max_purge_lag 325 - innodb_max_purge_lag_delay 326 - innodb_max_undo_log_size 327 - innodb_monitor_disable 328 - innodb_monitor_enable 329 - innodb_monitor_reset 330 - innodb_monitor_reset_all 331 - innodb_old_blocks_pct 332 - innodb_old_blocks_time 333 - innodb_online_alter_log_max_size 334 - innodb_optimize_fulltext_only 335 - innodb_parallel_read_threads 336 - innodb_print_all_deadlocks 337 - innodb_print_ddl_logs 338 - innodb_purge_batch_size 339 - innodb_purge_rseg_truncate_frequency 340 - innodb_random_read_ahead 341 - innodb_read_ahead_threshold 342 - innodb_redo_log_encrypt 343 - innodb_replication_delay 344 - innodb_rollback_segments 345 - innodb_segment_reserve_factor 346 - innodb_spin_wait_delay 347 - innodb_stats_auto_recalc 348 - innodb_stats_method 349 - innodb_stats_on_metadata 350 - innodb_stats_persistent 351 - innodb_stats_persistent_sample_pages 352 - innodb_stats_transient_sample_pages 353 - innodb_status_output 354 - innodb_status_output_locks 355 - innodb_strict_mode 356 - innodb_sync_spin_loops 357 - innodb_table_locks 358 - innodb_thread_concurrency 359 - innodb_thread_sleep_delay 360 - innodb_tmpdir 361 - innodb_undo_log_encrypt 362 - innodb_undo_log_truncate 363 - interactive_timeout 364 - internal_tmp_mem_storage_engine 365 - join_buffer_size 366 - keep_files_on_create 367 - key_buffer_size 368 - key_cache_age_threshold 369 - key_cache_block_size 370 - key_cache_division_limit 371 - keyring_operations 372 - lc_messages 373 - lc_messages_dir 374 - lc_time_names 375 - local_infile 376 - lock_wait_timeout 377 - log_bin_trust_function_creators 378 - log_error_services 379 - log_error_verbosity 380 - log_output 381 - log_queries_not_using_indexes 382 - log_slow_admin_statements 383 - log_slow_extra 384 - log_slow_slave_statements 385 - log_statements_unsafe_for_binlog 386 - log_syslog 387 - log_throttle_queries_not_using_indexes 388 - log_timestamps 389 - long_query_time 390 - low_priority_updates 391 - mandatory_roles 392 - master_info_repository 393 - master_verify_checksum 394 - max_allowed_packet 395 - max_binlog_cache_size 396 - max_binlog_size 397 - max_binlog_stmt_cache_size 398 - max_connect_errors 399 - max_connections 400 - max_delayed_threads 401 - max_error_count 402 - max_execution_time 403 - max_heap_table_size 404 - max_insert_delayed_threads 405 - max_join_size 406 - max_length_for_sort_data 407 - max_points_in_geometry 408 - max_prepared_stmt_count 409 - max_relay_log_size 410 - max_seeks_for_key 411 - max_sort_length 412 - max_sp_recursion_depth 413 - max_user_connections 414 - max_write_lock_count 415 - min_examined_row_limit 416 - myisam_data_pointer_size 417 - myisam_max_sort_file_size 418 - myisam_repair_threads 419 - myisam_sort_buffer_size 420 - myisam_stats_method 421 - myisam_use_mmap 422 - mysql_native_password_proxy_users 423 - mysqlx_connect_timeout 424 - mysqlx_document_id_unique_prefix 425 - mysqlx_idle_worker_thread_timeout 426 - mysqlx_interactive_timeout 427 - mysqlx_max_allowed_packet 428 - mysqlx_max_connections 429 - mysqlx_min_worker_threads 430 - mysqlx_read_timeout 431 - mysqlx_wait_timeout 432 - mysqlx_write_timeout 433 - net_buffer_length 434 - net_read_timeout 435 - net_retry_count 436 - net_write_timeout 437 - new 438 - offline_mode 439 - old_alter_table 440 - optimizer_prune_level 441 - optimizer_search_depth 442 - optimizer_switch 443 - optimizer_trace 444 - optimizer_trace_features 445 - optimizer_trace_limit 446 - optimizer_trace_max_mem_size 447 - optimizer_trace_offset 448 - original_commit_timestamp 449 - parser_max_mem_size 450 - password_history 451 - password_reuse_interval 452 - performance_schema_max_digest_sample_age 453 - preload_buffer_size 454 - profiling_history_size 455 - query_alloc_block_size 456 - query_prealloc_size 457 - range_alloc_block_size 458 - range_optimizer_max_mem_size 459 - rbr_exec_mode 460 - read_buffer_size 461 - read_only 462 - read_rnd_buffer_size 463 - regexp_stack_limit 464 - regexp_time_limit 465 - relay_log_purge 466 - relay_log_recovery 467 - replicate-do-db 468 - replicate-do-table 469 - replicate-ignore-db 470 - replicate-ignore-table 471 - replicate-wild-do-table 472 - replicate-wild-ignore-table 473 - require_secure_transport 474 - resultset_metadata 475 - rpl_read_size 476 - rpl_semi_sync_master_wait_for_slave_count 477 - rpl_semi_sync_master_wait_point 478 - rpl_stop_slave_timeout 479 - schema_definition_cache 480 - server_id 481 - session_track_gtids 482 - session_track_schema 483 - session_track_state_change 484 - session_track_system_variables 485 - session_track_transaction_info 486 - sha256_password_proxy_users 487 - show_create_table_verbosity 488 - show_old_temporals 489 - slave_allow_batching 490 - slave_checkpoint_group 491 - slave_checkpoint_period 492 - slave_compressed_protocol 493 - slave_exec_mode 494 - slave_net_timeout 495 - slave_parallel_workers 496 - slave_pending_jobs_size_max 497 - slave_preserve_commit_order 498 - slave_rows_search_algorithms 499 - slave_sql_verify_checksum 500 - slave_transaction_retries 501 - slow_launch_time 502 - slow_query_log 503 - slow_query_log_file 504 - sort_buffer_size 505 - sql_auto_is_null 506 - sql_big_selects 507 - sql_buffer_result 508 - sql_log_off 509 - sql_mode 510 - sql_notes 511 - sql_quote_show_create 512 - sql_require_primary_key 513 - sql_safe_updates 514 - sql_select_limit 515 - sql_slave_skip_counter 516 - sql_warnings 517 - ssl_fips_mode 518 - stored_program_cache 519 - stored_program_definition_cache 520 - super_read_only 521 - sync_binlog 522 - sync_master_info 523 - sync_relay_log 524 - sync_relay_log_info 525 - table_definition_cache 526 - table_open_cache 527 - tablespace_definition_cache 528 - temptable_max_ram 529 - thread_cache_size 530 - time_zone 531 - tls_ciphersuites 532 - tmp_table_size 533 - transaction_alloc_block_size 534 - transaction_isolation 535 - transaction_prealloc_size 536 - transaction_write_set_extraction 537 - unique_checks 538 - updatable_views_with_limit 539 - validate_password_length 540 - validate_password_mixed_case_count 541 - validate_password_number_count 542 - validate_password_policy 543 - validate_password_special_char_count 544 - wait_timeout 545 - windowing_use_high_precision 546 547 immutableParameters: 548 - allow-suspicious-udfs 549 - auto_generate_certs 550 - basedir 551 - bind_address 552 - binlog_direct_non_transactional_updates 553 - caching_sha2_password_auto_generate_rsa_keys 554 - caching_sha2_password_private_key_path 555 - caching_sha2_password_public_key_path 556 - character_sets_dir 557 - core-file 558 - datadir 559 - default_authentication_plugin 560 - default_time_zone 561 - disabled_storage_engines 562 - gtid_mode 563 - gtid_owned 564 - gtid_purged 565 - init_file 566 - innodb_data_file_path 567 - innodb_data_home_dir 568 - innodb_directories 569 - innodb_doublewrite 570 - innodb_force_load_corrupted 571 - innodb_force_recovery 572 - innodb_log_files_in_group 573 - innodb_log_group_home_dir 574 - innodb_page_size 575 - innodb_read_only 576 - innodb_scan_directories 577 - innodb_temp_data_file_path 578 - innodb_undo_tablespaces 579 - large_pages 580 - log_bin 581 - log-bin 582 - log_bin_basename 583 - log_bin_index 584 - log_slave_updates 585 - lower_case_file_system 586 - mecab_rc_file 587 - mysqlx_bind_address 588 - mysqlx_port 589 - mysqlx_port_open_timeout 590 - mysqlx_socket 591 - mysqlx_ssl_ca 592 - mysqlx_ssl_capath 593 - mysqlx_ssl_cert 594 - mysqlx_ssl_crl 595 - mysqlx_ssl_crlpath 596 - mysqlx_ssl_key 597 - open_files_limit 598 - persisted_globals_load 599 - pid_file 600 - plugin_dir 601 - port 602 - protocol_version 603 - relay_log 604 - relay-log 605 - relay_log_basename 606 - relay_log_index 607 - relay_log_info_file 608 - relay_log_space_limit 609 - report_host 610 - report_password 611 - report_port 612 - report_user 613 - secure_file_priv 614 - server_id 615 - sha256_password_auto_generate_rsa_keys 616 - sha256_password_private_key_path 617 - sha256_password_public_key_path 618 - skip_external_locking 619 - skip-slave-start 620 - slave_load_tmpdir 621 - socket 622 - ssl_key 623 - system_time_zone 624 - thread_handling 625 - tmpdir 626 - validate_password_dictionary_file 627 - version_comment 628 - version_compile_machine 629 - version_compile_os 630 - version_compile_zlib