TIDB内存溢出循环重启

tidb_allow_remove_auto_inc 0
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 100
tidb_backoff_weight 2
tidb_batch_commit 0
tidb_batch_delete 0
tidb_batch_insert 0
tidb_build_stats_concurrency 4
tidb_capture_plan_baselines off
tidb_check_mb4_value_in_utf8 1
tidb_checksum_table_concurrency 4
tidb_config
tidb_constraint_check_in_place 0
tidb_current_ts 0
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 1
tidb_distsql_scan_concurrency 15
tidb_dml_batch_size 20000
tidb_enable_cascades_planner 0
tidb_enable_chunk_rpc 1
tidb_enable_fast_analyze 0
tidb_enable_index_merge 0
tidb_enable_noop_functions 0
tidb_enable_radix_join 0
tidb_enable_slow_log 1
tidb_enable_stmt_summary 1
tidb_enable_streaming 0
tidb_enable_table_partition on
tidb_enable_vectorized_expression 1
tidb_enable_window_function 1
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_expensive_query_time_threshold 60
tidb_force_priority NO_PRIORITY
tidb_general_log 0
tidb_hash_join_concurrency 5
tidb_hashagg_final_concurrency 4
tidb_hashagg_partial_concurrency 4
tidb_index_join_batch_size 25000
tidb_index_lookup_concurrency 4
tidb_index_lookup_join_concurrency 4
tidb_index_lookup_size 20000
tidb_index_serial_scan_concurrency 1
tidb_init_chunk_size 32
tidb_isolation_read_engines tikv, tiflash, tidb
tidb_low_resolution_tso 0
tidb_max_chunk_size 1024
tidb_max_delta_schema_count 1024
tidb_mem_quota_hashjoin 34359738368
tidb_mem_quota_indexlookupjoin 34359738368
tidb_mem_quota_indexlookupreader 34359738368
tidb_mem_quota_mergejoin 34359738368
tidb_mem_quota_nestedloopapply 34359738368
tidb_mem_quota_query 1073741824
tidb_mem_quota_sort 34359738368
tidb_mem_quota_topn 34359738368
tidb_metric_query_range_duration 60
tidb_metric_query_step 60
tidb_opt_agg_push_down 0
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 0
tidb_opt_insubq_to_join_and_agg 1
tidb_opt_join_reorder_threshold 0
tidb_opt_memory_factor 0.001
tidb_opt_network_factor 1
tidb_opt_scan_factor 1.5
tidb_opt_seek_factor 20
tidb_opt_write_row_id 0
tidb_optimizer_selectivity_level 0
tidb_pprof_sql_cpu 0
tidb_projection_concurrency 4
tidb_query_log_max_len 4096
tidb_record_plan_in_slow_log 1
tidb_replica_read leader
tidb_retry_limit 10
tidb_row_format_version 2
tidb_scatter_region 0
tidb_skip_isolation_level_check 0
tidb_skip_utf8_check 0
tidb_slow_log_threshold 300
tidb_slow_query_file log/tidb_slow_query.log
tidb_snapshot
tidb_stmt_summary_history_size 24
tidb_stmt_summary_internal_query 0
tidb_stmt_summary_max_sql_length 4096
tidb_stmt_summary_max_stmt_count 200
tidb_stmt_summary_refresh_interval 1800
tidb_store_limit 0
tidb_txn_mode pessimistic
tidb_use_plan_baselines on
tidb_wait_split_region_finish 1
tidb_wait_split_region_timeout 300
tidb_window_concurrency 4

循环重启日志
Aug 10 08:56:29 ecs-d3f7-0001 kernel: lowmem_reserve[]: 0 0 0 0
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Node 0 DMA: 14kB (U) 08kB 016kB 132kB (U) 264kB (U) 1128kB (U) 1256kB (U) 0512kB 11024kB (U) 12048kB (M) 34096kB (M) = 15908kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Node 0 DMA32: 1453
4kB (UEM) 7828kB (UEM) 33016kB (UE) 13132kB (UE) 5864kB (UE) 22128kB (U) 7256kB (U) 9512kB (UM) 861024kB (UM) 02048kB 04096kB = 122532kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Node 0 Normal: 26894kB (UEM) 6768kB (UEM) 52416kB (UEM) 19032kB (UEM) 5664kB (UEM) 35128kB (UEM) 11256kB (U) 2512kB (U) 201024kB (M) 02048kB 0*4096kB = 63012kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=1048576kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: 2860 total pagecache pages
Aug 10 08:56:29 ecs-d3f7-0001 kernel: 0 pages in swap cache
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Swap cache stats: add 0, delete 0, find 0/0
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Free swap = 0kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Total swap = 0kB
Aug 10 08:56:29 ecs-d3f7-0001 kernel: 8388382 pages RAM
Aug 10 08:56:29 ecs-d3f7-0001 kernel: 0 pages HighMem/MovableOnly
Aug 10 08:56:29 ecs-d3f7-0001 kernel: 193862 pages reserved
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ pid ] uid tgid total_vm rss nr_ptes swapents oom_score_adj name
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 984] 0 984 26254 2464 29 0 0 systemd-journal
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1017] 0 1017 11184 140 24 0 -1000 systemd-udevd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1051] 0 1051 13882 112 28 0 -1000 auditd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1711] 81 1711 14692 273 34 0 -900 dbus-daemon
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1715] 0 1715 699273 4802 101 0 0 uniagent
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1716] 999 1716 153061 2411 62 0 0 polkitd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1717] 0 1717 5419 76 16 0 0 irqbalance
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1718] 0 1718 6595 74 18 0 0 systemd-logind
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1720] 0 1720 136959 1027 84 0 0 NetworkManager
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1722] 998 1722 29451 109 30 0 0 chronyd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1745] 0 1745 143558 2896 97 0 0 tuned
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1746] 0 1746 46403 6939 28 0 0 node_exporter
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1749] 0 1749 33012 7866 56 0 0 blackbox_export
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1750] 0 1750 3349767 218394 634 0 0 pd-server
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1752] 0 1752 28296 47 11 0 0 run_blackbox_ex
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1753] 0 1753 28296 46 11 0 0 run_node_export
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1755] 0 1755 26989 26 10 0 0 tee
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1756] 0 1756 26989 26 9 0 0 tee
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1808] 0 1808 25724 513 51 0 0 dhclient
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 1856] 0 1856 54637 1247 40 0 0 rsyslogd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2169] 0 2169 30522 152 11 0 0 wrapper
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2398] 0 2398 22425 259 42 0 0 master
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2403] 89 2403 22468 252 45 0 0 qmgr
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2493] 0 2493 3135972 40789 171 0 0 java
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2730] 0 2730 28230 256 57 0 -1000 sshd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2733] 0 2733 31573 155 18 0 0 crond
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2735] 0 2735 6477 52 17 0 0 atd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2742] 0 2742 27527 33 10 0 0 agetty
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2743] 0 2743 27527 34 9 0 0 agetty
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2799] 0 2799 12261 155 26 0 0 hostguard
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2801] 0 2801 311790 1865 70 0 0 hostguard
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 2945] 0 2945 455062 5898 68 0 0 telescope
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 3266] 0 3266 39329 348 79 0 0 sshd
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [ 3268] 0 3268 28862 101 13 0 0 bash
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [11347] 89 11347 22451 251 45 0 0 pickup
Aug 10 08:56:29 ecs-d3f7-0001 kernel: [11698] 0 11698 8175881 7730983 15297 0 0 tidb-server
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Out of memory: Kill process 11698 (tidb-server) score 916 or sacrifice child
Aug 10 08:56:29 ecs-d3f7-0001 kernel: Killed process 11698 (tidb-server), UID 0, total-vm:32703524kB, anon-rss:30923932kB, file-rss:0kB, shmem-rss:0kB
Aug 10 08:56:30 ecs-d3f7-0001 systemd: tidb-4000.service: main process exited, code=killed, status=9/KILL
Aug 10 08:56:30 ecs-d3f7-0001 systemd: Unit tidb-4000.service entered failed state.
Aug 10 08:56:30 ecs-d3f7-0001 systemd: tidb-4000.service failed.
Aug 10 08:56:45 ecs-d3f7-0001 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 10 08:56:45 ecs-d3f7-0001 systemd: Stopped tidb service.
Aug 10 08:56:45 ecs-d3f7-0001 systemd: Started tidb service.
Aug 10 09:00:41 ecs-d3f7-0001 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 10 09:00:41 ecs-d3f7-0001 systemd: Unit tidb-4000.service entered failed state.
Aug 10 09:00:41 ecs-d3f7-0001 systemd: tidb-4000.service failed.
Aug 10 09:00:56 ecs-d3f7-0001 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 10 09:00:56 ecs-d3f7-0001 systemd: Stopped tidb service.
Aug 10 09:00:56 ecs-d3f7-0001 systemd: Started tidb service.
Aug 10 09:01:01 ecs-d3f7-0001 systemd: Started Session 15 of user root.
Aug 10 09:04:36 ecs-d3f7-0001 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 10 09:04:36 ecs-d3f7-0001 systemd: Unit tidb-4000.service entered failed state.
Aug 10 09:04:36 ecs-d3f7-0001 systemd: tidb-4000.service failed.
Aug 10 09:04:51 ecs-d3f7-0001 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 10 09:04:51 ecs-d3f7-0001 systemd: Stopped tidb service.
Aug 10 09:04:51 ecs-d3f7-0001 systemd: Started tidb service.

这是所有的配置信息,请高人指点下,感激:pray::pray::pray: