TiDB检查错误解决办法

数据库 admin 2个月前 (07-27) 47次浏览 0个评论

===============================================================================

TiDB集群磁盘随机读取IOPS不到10000的错误

  • vim tidb-ansible/roles/machine_benchmark/defaults/main.yml

 

Tidb集群出现SSD硬盘IOPS不到40000的错误

  • vim tidb-ansible/roles/machine_benchmark/defaults/main.yml

 

TiDB集群安装内存不足16000M错误和CPU不足8核的错误

  • vim tidb-ansible/roles/check_system_optional/defaults/main.yml

 

注释监控主机检测

  • vim tidb-ansible/deploy.yml

23 # – check_config_static

 

  • vim tidb-ansible/bootstrap.yml

21 #- check_config_static

 

  • vim tidb-ansible/start.yml

23 #- check_config_static

 

  • vim tidb-ansible/stop.yml

23 # – check_config_static

 

注释掉磁盘检查

  • vim tidb-ansible/roles/machine_benchmark/tasks/fio_randread.yml

3 #- name: fio randread benchmark on tikv_data_dir disk
4 # shell: “cd {{ fio_deploy_dir }} && ./fio -ioengine=psync -bs=32k -fdatasync=1 -thread -rw=randread -size={{ benchmark _size }} -filename=fio_randread_test.txt -name=’fio randread test’ -iodepth=4 -runtime=60 -numjobs=4 -group_reporting — output-format=json –output=fio_randread_result.json”
5 # register: fio_randread

12 #- name: get fio randread iops
13 # shell: “python parse_fio_output.py –target=’fio_randread_result.json’ –read-iops”
14 # register: disk_randread_iops
15 # args:
16 # chdir: “{{ fio_deploy_dir }}/”
17 #
18 #- name: get fio randread summary
19 # shell: “python parse_fio_output.py –target=’fio_randread_result.json’ –summary”
20 # register: disk_randread_smmary
21 # args:
22 # chdir: “{{ fio_deploy_dir }}/”

33 #- name: Preflight check – Does fio randread iops of tikv_data_dir disk meet requirement
34 # fail:
35 # msg: ‘fio: randread iops of tikv_data_dir disk is too low: {{ disk_randread_iops.stdout }} < {{ min_ssd_randread_io ps }}, it is strongly recommended to use SSD disks for TiKV and PD, or there might be performance issues.’
36 # when: disk_randread_iops.stdout|int < min_ssd_randread_iops|int

 

注释掉磁盘转数检查

  • vim tidb-ansible/roles/machine_benchmark/tasks/fio_randread_write_latency.yml

39 #- name: Preflight check – Does fio mixed randread and sequential write latency of tikv_data_dir disk meet requirement – randread
40 # fail:
41 # msg: ‘fio mixed randread and sequential write test: randread latency of tikv_data_dir disk is too low: {{ disk_mix _randread_lat.stdout }} ns > {{ max_ssd_mix_randread_lat }} ns, it is strongly recommended to use SSD disks for TiKV and PD, or there might be performance issues.’
42 # when: disk_mix_randread_lat.stdout|int > max_ssd_mix_randread_lat|int
43 #
44 #- name: Preflight check – Does fio mixed randread and sequential write latency of tikv_data_dir disk meet requirement – sequential write
45 # fail:
46 # msg: ‘fio mixed randread and sequential write test: sequential write latency of tikv_data_dir disk is too low: {{ d isk_mix_write_lat.stdout }} ns > {{ max_ssd_mix_write_lat }} ns, it is strongly recommended to use SSD disks for TiKV an d PD, or there might be performance issues.’
47 # when: disk_mix_write_lat.stdout|int > max_ssd_mix_write_lat|int

 

  • vim tidb-ansible/bootstrap.yml

42 # – { role: machine_benchmark, when: not dev_mode|default(false) }


转载请注明原文链接:TiDB检查错误解决办法
喜欢 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址