黄东旭解析 TiDB 的核心优势
595
2024-03-22
针对 LTS 版本,PingCAP 会提供最多至 3 年时间的常规版本更新,以解决版本运行过程中遇到的问题,以及安全相关的漏洞修复。而对于已经结束维护周期的版本,官方不会提供支持。那么如果想要跟紧 TiDB 的脚步,可能最多 3 年就要做一次大版本的升级,下面是目前最新的版本支持时间表。
VersionRelease DateMaintenance Support endsExtended Support ends (EOL)v7.12023-05-312026-05-312027-05-31v6.52022-12-292025-12-292026-12-29v6.12022-06-132025-06-132026-06-13v5.42022-02-152025-02-152026-02-15v5.32021-11-302023-11-302024-11-30v5.22021-08-272023-08-272024-08-27v5.12021-06-242023-06-242024-06-24v5.02021-04-072023-04-072024-04-07v4.02020-05-282023-04-022024-04-02v3.02019-06-282022-09-252023-09-25TiDB 虽然有使用 tiup 进行原地升级的方式,但是目前暂不支持版本降级或升级后回退,还要考虑停机时间等问题,风险还是比较高的。而且如果版本跨度较大可能要进行多次升级才能到目标版本,操作也比较复杂。因此,条件允许的话还是建议尽量使用新旧集群之间做实时同步然后割接的方案来达到升级的目的。TiDB 作为分布式数据库有 tidb,pd 和 tikv 等多个组件,每个组件都有自己的参数,每次版本的升级可能都会有参数的变化,比如新增或者废弃的参数,或者参数的默认值可能会发生变化。如果不进行测试直接进行升级可能会由于参数变动发生预期之外的影响。
TiDBA 可以对比 2 个集群之间的参数,来识别新旧版本或者不同参数的变化。
从 toolkit 离线包中可以看到有几个我们平时不常用的压缩包,dba-v1.0.4-linux-amd64.tar.gz 就是其中之一,解压后无需编译可以直接得到 tidba 这个可执行文件,使用非常方便。
[root@cctest tidb-community-toolkit-v7.1.0-linux-amd64]# ls 1535.dmctl.json 3729.prometheus.json dba-v1.0.4-linux-amd64.tar.gz pump-v7.1.0-linux-amd64.tar.gz 1542.dm-worker.json 3752.cdc.json dmctl-v7.1.0-linux-amd64.tar.gz reparo1546.dm-master.json 3.package.json dm-master-v7.1.0-linux-amd64.tar.gz root.json 17.tispark.json 3.PCC.json dm-v1.12.2-linux-amd64.tar.gz server-v1.12.2-linux-amd64.tar.gz 1.dba.json 487.bench.json dm-worker-v7.1.0-linux-amd64.tar.gz snapshot.json 1.index.json 5.alertmanager.json drainer-v7.1.0-linux-amd64.tar.gz spark-v2.4.3-any-any.tar.gz1.root.json 7.blackbox_exporter.json dumpling-v7.1.0-linux-amd64.tar.gz sync_diff_inspector 239.dm.json 7.node_exporter.json errdoc-v4.0.7-linux-amd64.tar.gz tidba 241.server.json 80.tikv-importer.json etcdctl tidb-lightning-ctl 281.tiup.json 9.errdoc.json grafana-v7.1.0-linux-amd64.tar.gz tidb-lightning-v7.1.0-linux-amd64.tar.gz2.spark.json alertmanager-v0.17.0-linux-amd64.tar.gz keys tikv-importer-v4.0.2-linux-amd64.tar.gz 3541.drainer.json arbiter local_install.sh timestamp.json 3562.pump.json bench-v1.12.0-linux-amd64.tar.gz mydumper tispark-v2.4.1-any-any.tar.gz3569.pd-recover.json bin node_exporter-v1.3.1-linux-amd64.tar.gz tiup-linux-amd64.tar.gz 3586.dumpling.json binlogctl package-v0.0.9-linux-amd64.tar.gz tiup-v1.12.2-linux-amd64.tar.gz 3657.tidb-lightning.json blackbox_exporter-v0.21.1-linux-amd64.tar.gz PCC-1.0.1-linux-amd64.tar.gz 3660.br.json br-v7.1.0-linux-amd64.tar.gz pd-recover-v7.1.0-linux-amd64.tar.gz3678.grafana.json cdc-v7.1.0-linux-amd64.tar.gz prometheus-v7.1.0-linux-amd64.tar.gz本次测试仅用于参数对比,因此采用最简单省时的 tiup playground 来创建集群。
准备 2 套集群,源端为 v6.1.6
[root@cctest ~]# tiup playground v6.1.6 tiup is checking updates for component playground ... Starting component`playground`: /root/.tiup/components/playground/v1.12.3/tiup-playground v6.1.6 Start pd instance:v6.1.6 Start tikv instance:v6.1.6 Start tidb instance:v6.1.6 Waiting for t-comments --host 127.0.0.1 --port 42240 -u root TiDB Dashboard: http://127.0.0.1:38754/dashboard Grafana: http://127.0.0.1:3000目标端为 7.1.0
[root@cctest ~]# tiup playground v7.1.0 tiup is checking updates for component playground ... Starting component playground: /root/.tiup/components/playground/v1.12.3/tiup-playground v7.1.0 Start pd instance:v7.1.0 Start tikv instance:v7.1.0 Start tidb instance:v7.1.0 Waiting for tidb instances ready 127.0.0.1:4000 .. TiDB Dashboard: http://127.0.0.1:2379/dashboard Grafana: http://127.0.0.1:43315tidba diff tidb --diff-type variable --base-tidb-addr 127.0.0.1:42240 --base-tidb-user root --new-tidb-addr 127.0.0.1:4000 --new-tidb-user root
[root@cctest tidb-community-toolkit-v7.1.0-linux-amd64]# ./tidba diff tidb --diff-type variable --base-tidb-addr 127.0.0.1:42240 --base-tidb-user root --new-tidb-addr 127.0.0.1:4000 --new-tidb-user root --- 127.0.0.1:42240 +++ 127.0.0.1:4000 { "tidb_allow_batch_cop": "1", "tidb_allow_fallback_to_tikv": "",- "tidb_allow_function_for_expression_index": "lower, md5, reverse, tidb_shard, upper, vitess_hash", +"tidb_allow_function_for_expression_index": "json_array, json_array_append, json_array_insert, json_contains, json_contains_path, json_depth, json_extract, json_insert, json_keys, json_length, json_merge_patch, json_merge_preserve, json_object, json_pretty, json_quote, json_remove, json_replace, json_search, json_set, json_storage_size, json_type, json_unquote, json_valid, lower, md5, reverse, tidb_shard, upper, vitess_hash", "tidb_allow_mpp": "ON", "tidb_allow_remove_auto_inc": "OFF", "tidb_analyze_version": "2", "tidb_auto_analyze_end_time": "23:59 +0000", "tidb_auto_analyze_ratio": "0.5", "tidb_auto_analyze_start_time": "00:00 +0000", "tidb_backoff_lock_fast": "10", "tidb_backoff_weight": "2", "tidb_batch_commit": "OFF", "tidb_batch_delete": "OFF", "tidb_batch_insert": "OFF", "tidb_batch_pending_tiflash_count": "4000", "tidb_broadcast_join_threshold_count": "10240", "tidb_broadcast_join_threshold_size": "104857600", "tidb_build_stats_concurrency": "4", "tidb_capture_plan_baselines": "OFF", "tidb_check_mb4_value_in_utf8": "ON", "tidb_checksum_table_concurrency": "4", "tidb_committer_concurrency": "128", "tidb_constraint_check_in_place": "OFF",- "tidb_current_ts": "442484779120328706", +"tidb_current_ts": "442484779124785154", "tidb_ddl_error_count_limit": "512", "tidb_ddl_reorg_batch_size": "256", "tidb_ddl_reorg_priority": "PRIORITY_LOW", "tidb_ddl_reorg_worker_cnt": "4", "tidb_disable_txn_auto_retry": "ON", "tidb_distsql_scan_concurrency": "15", "tidb_dml_batch_size": "0", "tidb_enable_1pc": "ON",-"tidb_enable_amend_pessimistic_txn": "OFF", "tidb_enable_analyze_snapshot": "OFF", "tidb_enable_async_commit": "ON", "tidb_enable_auto_analyze": "ON", "tidb_enable_auto_increment_in_generated": "OFF", "tidb_enable_batch_dml": "OFF", "tidb_enable_cascades_planner": "OFF",- "tidb_enable_change_multi_schema": "OFF", - "tidb_enable_chunk_rpc": "1", + "tidb_enable_chunk_rpc": "ON", - "tidb_enable_clustered_index": "INT_ONLY", +"tidb_enable_clustered_index": "ON", "tidb_enable_collect_execution_info": "ON", "tidb_enable_column_tracking": "OFF", "tidb_enable_enhanced_security": "OFF",- "tidb_enable_exchange_partition": "OFF", +"tidb_enable_exchange_partition": "ON", "tidb_enable_extended_stats": "OFF", "tidb_enable_fast_analyze": "OFF",- "tidb_enable_historical_stats": "OFF", +"tidb_enable_historical_stats": "ON", "tidb_enable_index_merge": "ON", "tidb_enable_index_merge_join": "OFF", "tidb_enable_inl_join_inner_multi_pattern": "OFF", "tidb_enable_legacy_instance_scope": "ON", "tidb_enable_list_partition": "ON", "tidb_enable_local_txn": "OFF", "tidb_enable_mutation_checker": "ON",- "tidb_enable_new_cost_interface": "OFF", +"tidb_enable_new_cost_interface": "ON", "tidb_enable_new_only_full_group_by_check": "OFF", "tidb_enable_noop_functions": "OFF", "tidb_enable_ordered_result_mode": "OFF",- "tidb_enable_outer_join_reorder": "OFF", + "tidb_enable_outer_join_reorder": "ON", - "tidb_enable_paging": "OFF", +"tidb_enable_paging": "ON", "tidb_enable_parallel_apply": "OFF", "tidb_enable_pipelined_window_function": "ON",- "tidb_enable_point_get_cache": "OFF", "tidb_enable_prepared_plan_cache": "ON", - "tidb_enable_pseudo_for_outdated_stats": "ON", + "tidb_enable_pseudo_for_outdated_stats": "OFF", -"tidb_enable_rate_limit_action": "ON",+"tidb_enable_rate_limit_action": "OFF", "tidb_enable_slow_log": "ON", "tidb_enable_stmt_summary": "ON", "tidb_enable_strict_double_type_check": "ON", "tidb_enable_table_partition": "ON", "tidb_enable_telemetry": "OFF", "tidb_enable_top_sql": "OFF", "tidb_enable_tso_follower_proxy": "OFF", "tidb_enable_vectorized_expression": "ON", "tidb_enable_window_function": "ON", "tidb_enforce_mpp": "OFF", "tidb_evolve_plan_baselines": "OFF", "tidb_evolve_plan_task_end_time": "23:59 +0000", "tidb_evolve_plan_task_max_time": "600", "tidb_evolve_plan_task_start_time": "00:00 +0000", "tidb_executor_concurrency": "5", "tidb_expensive_query_time_threshold": "60", "tidb_force_priority": "NO_PRIORITY", "tidb_gc_concurrency": "-1", "tidb_gc_enable": "ON", "tidb_gc_life_time": "10m0s", "tidb_gc_max_wait_time": "86400", "tidb_gc_run_interval": "10m0s", "tidb_gc_scan_lock_mode": "LEGACY", "tidb_general_log": "OFF", "tidb_guarantee_linearizability": "ON", "tidb_hash_exchange_with_new_collation": "ON", "tidb_hash_join_concurrency": "-1", "tidb_hashagg_final_concurrency": "-1", "tidb_hashagg_partial_concurrency": "-1", "tidb_ignore_prepared_cache_close_stmt": "OFF", "tidb_index_join_batch_size": "25000", "tidb_index_lookup_concurrency": "-1", "tidb_index_lookup_join_concurrency": "-1", "tidb_index_lookup_size": "20000", "tidb_index_serial_scan_concurrency": "1", "tidb_init_chunk_size": "32", "tidb_isolation_read_engines": "tikv,tiflash,tidb", "tidb_last_ddl_info": "{"query":"","seq_num":0}",- "tidb_last_query_info": "{"txn_scope":"global","start_ts":442484779120328706,"for_update_ts":442484779120328706}", +"tidb_last_query_info": "{"txn_scope":"global","start_ts":442484779124785154,"for_update_ts":442484779124785154}", "tidb_last_txn_info": "", "tidb_log_file_max_days": "0", "tidb_low_resolution_tso": "OFF", "tidb_max_auto_analyze_time": "43200", "tidb_max_chunk_size": "1024", "tidb_max_delta_schema_count": "1024", "tidb_max_tiflash_threads": "-1", "tidb_mem_oom_action": "CANCEL", "tidb_mem_quota_analyze": "-1", "tidb_mem_quota_apply_cache": "33554432", "tidb_mem_quota_binding_cache": "67108864", "tidb_mem_quota_query": "1073741824",-"tidb_memory_usage_alarm_ratio": "0.8",+"tidb_memory_usage_alarm_ratio": "0.7", "tidb_merge_join_concurrency": "1", "tidb_metric_query_range_duration": "60", "tidb_metric_query_step": "60", "tidb_mpp_store_fail_ttl": "60s", "tidb_multi_statement_mode": "OFF", "tidb_nontransactional_ignore_error": "OFF", "tidb_opt_agg_push_down": "OFF", "tidb_opt_broadcast_cartesian_join": "1", "tidb_opt_concurrency_factor": "3", "tidb_opt_copcpu_factor": "3", "tidb_opt_correlation_exp_factor": "1", "tidb_opt_correlation_threshold": "0.9", "tidb_opt_cpu_factor": "3", "tidb_opt_desc_factor": "3", "tidb_opt_disk_factor": "1.5", "tidb_opt_distinct_agg_push_down": "OFF", "tidb_opt_enable_correlation_adjustment": "ON", "tidb_opt_insubq_to_join_and_agg": "ON", "tidb_opt_join_reorder_threshold": "0", "tidb_opt_limit_push_down_threshold": "100", "tidb_opt_memory_factor": "0.001", "tidb_opt_mpp_outer_join_fixed_build_side": "OFF", "tidb_opt_network_factor": "1", "tidb_opt_prefer_range_scan": "OFF", "tidb_opt_projection_push_down": "OFF", "tidb_opt_scan_factor": "1.5", "tidb_opt_seek_factor": "20", "tidb_opt_tiflash_concurrency_factor": "24", "tidb_opt_write_row_id": "OFF", "tidb_optimizer_selectivity_level": "0",- "tidb_partition_prune_mode": "static", +"tidb_partition_prune_mode": "dynamic", "tidb_persist_analyze_options": "ON", "tidb_placement_mode": "STRICT", "tidb_pprof_sql_cpu": "0", "tidb_prepared_plan_cache_memory_guard_ratio": "0.1", "tidb_prepared_plan_cache_size": "100", "tidb_projection_concurrency": "-1", "tidb_query_log_max_len": "4096", "tidb_rc_read_check_ts": "OFF", "tidb_read_consistency": "strict", "tidb_read_staleness": "0", "tidb_record_plan_in_slow_log": "ON", "tidb_redact_log": "OFF", "tidb_regard_null_as_point": "ON", "tidb_remove_orderby_in_subquery": "OFF", "tidb_replica_read": "leader", "tidb_restricted_read_only": "OFF", "tidb_retry_limit": "10", "tidb_row_format_version": "2", "tidb_scatter_region": "OFF", "tidb_shard_allocate_step": "9223372036854775807", "tidb_skip_ascii_check": "OFF", "tidb_skip_isolation_level_check": "OFF", "tidb_skip_utf8_check": "OFF", "tidb_slow_log_threshold": "300", "tidb_slow_query_file": "tidb-slow.log", "tidb_snapshot": "", "tidb_stats_cache_mem_quota": "0",- "tidb_stats_load_pseudo_timeout": "false", + "tidb_stats_load_pseudo_timeout": "ON", - "tidb_stats_load_sync_wait": "0", +"tidb_stats_load_sync_wait": "100", "tidb_stmt_summary_history_size": "24", "tidb_stmt_summary_internal_query": "OFF", "tidb_stmt_summary_max_sql_length": "4096", "tidb_stmt_summary_max_stmt_count": "3000", "tidb_stmt_summary_refresh_interval": "1800", "tidb_store_limit": "0", "tidb_streamagg_concurrency": "1", "tidb_super_read_only": "OFF", "tidb_sysdate_is_now": "OFF", "tidb_table_cache_lease": "3", "tidb_tmp_table_max_size": "67108864", "tidb_top_sql_max_meta_count": "5000", "tidb_top_sql_max_time_series_count": "100", "tidb_track_aggregate_memory_usage": "ON", "tidb_tso_client_batch_max_wait_time": "0", "tidb_txn_assertion_level": "FAST", "tidb_txn_commit_batch_size": "16384", "tidb_txn_mode": "pessimistic", "tidb_use_plan_baselines": "ON", "tidb_wait_split_region_finish": "ON", "tidb_wait_split_region_timeout": "300", "tidb_window_concurrency": "-1"+"tidb_adaptive_closest_read_threshold": "4096"+ "tidb_analyze_partition_concurrency": "1" + "tidb_auto_analyze_partition_batch_size": "1" + "tidb_auto_build_stats_concurrency": "1" + "tidb_cdc_write_source": "0" + "tidb_constraint_check_in_place_pessimistic": "ON" + "tidb_cost_model_version": "2" + "tidb_ddl_disk_quota": "107374182400" +"tidb_ddl_enable_fast_reorg": "ON"+ "tidb_ddl_flashback_concurrency": "64" + "tidb_default_string_match_selectivity": "0.8" + "tidb_enable_ddl": "ON" + "tidb_enable_dist_task": "OFF" + "tidb_enable_external_ts_read": "OFF" + "tidb_enable_foreign_key": "ON" + "tidb_enable_gc_aware_memory_track": "OFF" + "tidb_enable_gogc_tuner": "ON" + "tidb_enable_historical_stats_for_capture": "OFF" + "tidb_enable_metadata_lock": "ON" + "tidb_enable_non_prepared_plan_cache": "OFF" + "tidb_enable_non_prepared_plan_cache_for_dml": "OFF" + "tidb_enable_noop_variables": "ON" + "tidb_enable_null_aware_anti_join": "ON" +"tidb_enable_plan_cache_for_param_limit": "ON"+ "tidb_enable_plan_cache_for_subquery": "ON" + "tidb_enable_plan_replayer_capture": "ON" + "tidb_enable_plan_replayer_continuous_capture": "OFF" + "tidb_enable_prepared_plan_cache_memory_monitor": "ON" + "tidb_enable_resource_control": "ON" + "tidb_enable_reuse_chunk": "ON" +"tidb_enable_row_level_checksum": "OFF"+ "tidb_enable_tiflash_read_for_write_stmt": "ON" + "tidb_enable_tmp_storage_on_oom": "ON" + "tidb_enable_unsafe_substitute": "OFF" + "tidb_external_ts": "0" + "tidb_generate_binary_plan": "ON" + "tidb_gogc_tuner_threshold": "0.6" + "tidb_historical_stats_duration": "168h0m0s" +"tidb_index_join_double_read_penalty_cost_rate": "0"+ "tidb_index_merge_intersection_concurrency": "-1" + "tidb_last_plan_replayer_token": "" + "tidb_load_based_replica_read_threshold": "1s" + "tidb_max_bytes_before_tiflash_external_group_by": "-1" + "tidb_max_bytes_before_tiflash_external_join": "-1" +"tidb_max_bytes_before_tiflash_external_sort": "-1"+ "tidb_max_paging_size": "50000" + "tidb_memory_debug_mode_alarm_ratio": "0" + "tidb_memory_debug_mode_min_heap_inuse": "0" + "tidb_memory_usage_alarm_keep_record_num": "5" + "tidb_merge_partition_stats_concurrency": "1" + "tidb_min_paging_size": "128" +"tidb_non_prepared_plan_cache_size": "100"+ "tidb_opt_advanced_join_hint": "ON" + "tidb_opt_derive_topn": "OFF" + "tidb_opt_enable_late_materialization": "ON" + "tidb_opt_enable_three_stage_multi_distinct_agg": "OFF" + "tidb_opt_fix_control": "" + "tidb_opt_force_inline_cte": "OFF" + "tidb_opt_ordering_index_selectivity_threshold": "0" +"tidb_opt_prefix_index_single_scan": "ON"+ "tidb_opt_range_max_size": "67108864" + "tidb_opt_skew_distinct_agg": "OFF" + "tidb_opt_three_stage_distinct_agg": "ON" + "tidb_pessimistic_txn_fair_locking": "ON" + "tidb_plan_cache_invalidation_on_fresh_stats": "ON" + "tidb_plan_cache_max_plan_size": "2097152" +"tidb_prefer_broadcast_join_by_exchange_data_size": "OFF"+ "tidb_rc_write_check_ts": "OFF" + "tidb_server_memory_limit": "80%" + "tidb_server_memory_limit_gc_trigger": "0.7" + "tidb_server_memory_limit_sess_min_size": "134217728" + "tidb_session_plan_cache_size": "100" + "tidb_simplified_metrics": "OFF" +"tidb_slow_txn_log_threshold": "0"+ "tidb_source_id": "1" + "tidb_stmt_summary_enable_persistent": "OFF" + "tidb_stmt_summary_file_max_backups": "0" + "tidb_stmt_summary_file_max_days": "3" + "tidb_stmt_summary_file_max_size": "64" + "tidb_stmt_summary_filename": "tidb-statements.log" + "tidb_store_batch_size": "4" +"tidb_sysproc_scan_concurrency": "1"+ "tidb_ttl_delete_batch_size": "100" + "tidb_ttl_delete_rate_limit": "0" + "tidb_ttl_delete_worker_count": "4" + "tidb_ttl_job_enable": "ON" + "tidb_ttl_job_schedule_window_end_time": "23:59 +0000" + "tidb_ttl_job_schedule_window_start_time": "00:00 +0000" + "tidb_ttl_running_tasks": "-1" +"tidb_ttl_scan_batch_size": "500"+ "tidb_ttl_scan_worker_count": "4" }tidba diff tidb --diff-type config --base-tidb-addr 127.0.0.1:42240 --base-tidb-user root --new-tidb-addr 127.0.0.1:4000 --new-tidb-user root
[root@cctest tidb-community-toolkit-v7.1.0-linux-amd64]# ./tidba diff tidb --diff-type config --base-tidb-addr 127.0.0.1:42240 --base-tidb-user root --new-tidb-addr 127.0.0.1:4000 --new-tidb-user root --- 127.0.0.1:42240 +++ 127.0.0.1:4000 { "advertise-address": "127.0.0.1", "alter-primary-key": false, "ballast-object-size": 0, "binlog": { "binlog-socket": "", "enable": false, "ignore-error": false, "strategy": "range", "write-timeout": "15s" },-"check-mb4-value-in-utf8": true, "compatible-kill-query": false, "cors": "", "delay-clean-table-lock": 0, "deprecate-integer-display-length": false,- "enable-batch-dml": false, -"enable-collect-execution-info": true, "enable-enum-length-limit": true, "enable-forwarding": false, "enable-global-index": false, "enable-global-kill": true, "enable-table-lock": false, "enable-tcp4-only": false, "enable-telemetry": false, "experimental": { "allow-expression-index": false }, "graceful-wait-before-shutdown": 0, "host": "127.0.0.1", "index-limit": 64, "instance": { "ddl_slow_threshold": 300, "plugin_dir": "/data/deploy/plugin", "plugin_load": "", "tidb_check_mb4_value_in_utf8": true, "tidb_enable_collect_execution_info": true, "tidb_enable_slow_log": true, "tidb_expensive_query_time_threshold": 60, "tidb_force_priority": "NO_PRIORITY", "tidb_general_log": false,- "tidb_memory_usage_alarm_ratio": 0.8, "tidb_pprof_sql_cpu": false, "tidb_record_plan_in_slow_log": 1, "tidb_slow_log_threshold": 300 + "max_connections": 0 +"tidb_enable_ddl": true+ "tidb_rc_read_check_ts": false + "tidb_stmt_summary_enable_persistent": false + "tidb_stmt_summary_file_max_backups": 0 + "tidb_stmt_summary_file_max_days": 3 + "tidb_stmt_summary_file_max_size": 64 +"tidb_stmt_summary_filename": "tidb-statements.log" }, "isolation-read": { "engines": [ : "tikv", : "tiflash", : "tidb" ] }, "labels": { }, "lease": "45s", "log": { "disable-error-stack": null, "disable-timestamp": null, "enable-error-stack": null,- "enable-slow-log": true, "enable-timestamp": null, - "expensive-threshold": 10000, "file": { - "filename": "/root/.tiup/data/TiSzfi6/tidb-0/tidb.log", +"filename": "/root/.tiup/data/TiSzmGl/tidb-0/tidb.log", "max-backups": 0, "max-days": 0, "max-size": 300 }, "format": "text", "level": "info",- "query-log-max-len": 4096, -"record-plan-in-slow-log": 1, "slow-query-file": "tidb-slow.log",- "slow-threshold": 300 + "timeout": 0 }, "max-ballast-object-size": 0, "max-index-length": 3072, - "max-server-connections": 0, - "mem-quota-query": 1.073741824e+09, "new_collations_enabled_on_first_bootstrap": true, -"oom-action": "cancel",-"oom-use-tmp-storage": true, "opentracing": { "enable": false, "reporter": { "buffer-flush-interval": 0, "local-agent-host-port": "", "log-spans": false, "queue-size": 0 }, "rpc-metrics": false, "sampler": { "max-operations": 0, "param": 1, "sampling-refresh-interval": 0, "sampling-server-url": "", "type": "const" } },- "path": "127.0.0.1:38754", + "path": "127.0.0.1:2379", "pd-client": { "pd-server-timeout": 3 }, "performance": { "bind-info-lease": "3s", -"committer-concurrency": 128, "cross-join": true, "distinct-agg-push-down": false, "enable-stats-cache-mem-quota": false, "enforce-mpp": false,- "feedback-probability": 0, - "force-priority": "NO_PRIORITY", "gogc": 100, -"max-memory": 0, "max-procs": 0, "max-txn-ttl": 3.6e+06,- "memory-usage-alarm-ratio": 0.8, "plan-replayer-gc-lease": "10m", "projection-push-down": false, "pseudo-estimate-ratio": 0.8, - "query-feedback-limit": 512, -"run-auto-analyze": true, "server-memory-quota": 0, "stats-lease": "3s", "stats-load-concurrency": 5, "stats-load-queue-size": 1000, "stmt-count-limit": 5000, "tcp-keep-alive": true, "tcp-no-delay": true, "txn-entry-size-limit": 6.291456e+06, "txn-total-size-limit": 1.048576e+08+ "analyze-partition-concurrency-quota": 16 + "enable-load-fmsketch": false + "force-init-stats": false + "lite-init-stats": false +"plan-replayer-dump-worker-concurrency": 1 }, "pessimistic-txn": { "deadlock-history-capacity": 10, "deadlock-history-collect-retryable": false, "max-retry-count": 256, "pessimistic-auto-commit": false+ "constraint-check-in-place-pessimistic": true }, "plugin": { - "dir": "/data/deploy/plugin", -"load": "" },- "port": 42240, + "port": 4000, "prepared-plan-cache": { - "capacity": 100, - "enabled": true, - "memory-guard-ratio": 0.1 }, "proxy-protocol": { "header-timeout": 5, "networks": "" +"fallbackable": false }, "repair-mode": false, "repair-table-list": [ ],-版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。