针对大数据量(大于3000万)
后台启动核对sql
nohup ./batch_md5.sh ac05 > ac05.log &
由于存在时间差,需要二次核对
针对小于3000万的:
多线程启用核对sql
./result_batch_md5.sh ac01
./diff_batch_md5.sh ac01
查询当前线程
watch ‘ps -ef|grep mysql|grep -v grep|wc -l’
批量删除进程
ps -ef|grep mysql|awk ‘{print $2}’|xargs kill -9
批量替换-换行符替换成逗号
cat ac01_*.diff|awk ‘{print KaTeX parse error: Expected 'EOF', got '}' at position 2: 2}̲'|sort|uniq|sed…!ba;s/\n/,/g’
– 解压
find . -name “.log.gz"|xargs gzip -d
– 压缩
find . -name "row_.log”|xargs gzip
– 查询单个关键字
find . -name “row_.log"|xargs grep 34082204100039316163
– 查询多个关键字
find . -name "row_.log”|xargs grep -E “34012205100101469680|34012205100108510996|34012205100150500771|34042205100120493013|34102205100143654494”