首页 发现 帮助
注册 登录
gyfl
/
xyzshop
2
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: f3d5e6d3f5
分支列表 标签列表
xyzshop
/
util
/
ennodb-home-xyzshop.sh

ennodb-home-xyzshop.sh 7.5 KB
文件历史 原始文件

12345678910111213141516171819202122232425 
  1. #!/bin/bash
    2. 

  2. 

  3. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_bonus_ranklist    --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    4. 

  4. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_bonus_share       --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    5. 

  5. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_circle_threply    --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    6. 

  6. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea_area         --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    7. 

  7. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea_class_index  --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    8. 

  8. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea_class        --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    9. 

  9. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea_consult      --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    10. 

  10. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea_favorites    --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    11. 

  11. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea              --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    12. 

  12. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_flea_upload       --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    13. 

  13. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_link              --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    14. 

  14. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_merchant_evidence --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    15. 

  15. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_merchant_info     --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    16. 

  16. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_provider_evidence --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    17. 

  17. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_provider_info     --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    18. 

  18. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_sms_template      --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    19. 

  19. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_cats           --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    20. 

  20. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_cpid_attrid    --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    21. 

  21. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_goods          --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    22. 

  22. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_props          --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    23. 

  23. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_prop_values    --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    24. 

  24. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_spvid_tpvid    --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    25. 

  25. pt-online-schema-change --alter="engine innodb;" --execute D=xyzshop,t=lrlz_tm_tvid_attrvid   --channel=master-xyzshop --no-check-replication-filters --max-load="Threads_running=100"  --critical-load="Threads_running=120" --host=127.0.0.1 --user=root --password=55668899  --charset=utf8 --progress=time,2 --host=127.0.0.1 --port=3306
    26.