shell--redis，mysql数据删除

#!/bin/bash
arr_uids=(3941050469 3941036508 3941040724 3941036509 3941040725 3941046627 3941040727 634781553051 3941040728 3941046628 3941036511 3941050467 297365208 3941036512 3941046629 3941050470 3941040731 3941036513 3941050471 3941040732 3941036514 3941036516 3941050472 3941046630 3941046631 3941050474 3941040733 3941046634 3941050475 3941050476 3941046635 3941046636)
for((i=0;i<${#arr_uids[@]};i++))
do
redis-cli -h 10.155.120.18 -p 2040 -c del lf-sns-default_welfaregiftnum_${arr_uids[i]};
redis-cli -h 10.155.120.18 -p 2040 -c del lf-sns-default_isshare_${arr_uids[i]};
redis-cli -h 10.155.120.18 -p 2040 -c del lf-sns-default_points_${arr_uids[i]};
echo 'del-redis'
num=$((${arr_uids[i]}%64))
echo $num
mysql -h10.99.41.60 -P4444 -uchunlei  -pMhxzKhl is_chunlei_netdisk $test --default-character-set=utf8 -e "delete from user_overspeed_count_$num where uid = ${arr_uids[i]} and activity_id in(246811552634,634781553051)"
echo 'del-mysql'
done;

 

本脚本支持批量删除

后来大量数据验证发现此脚本存在数据库访问不安全的情况，于是修改脚本如下：

#!/bin/bash
export MYSQL_PWD=MhxzKhl
#arr_uids=(3941050469 3941036508 3941040724 3941036509 3941040725 3941046627 3941040727 634781553051 3941040728 3941046628 3941036511 3941050467 297365208 3941036512 3941046629 3941050470 3941040731 3941036513 3941050471 3941040732 3941036514 3941036516 3941050472 3941046630 3941046631 3941050474 3941040733 3941046634 3941050475 3941050476 3941046635 3941046636 1705039053)
for((i=0;i<${#arr_uids[@]};i++))
do
redis-cli -h 10.155.120.18 -p 2040 -c del lf-sns-default_welfaregiftnum_${arr_uids[i]};
redis-cli -h 10.155.120.18 -p 2040 -c del lf-sns-default_isshare_${arr_uids[i]};
redis-cli -h 10.155.120.18 -p 2040 -c del lf-sns-default_points_${arr_uids[i]};
echo 'del-redis'
num=$((${arr_uids[i]}%64))
echo $num
mysql -h10.99.41.60 -P4444 -uchunlei is_chunlei_netdisk $test --default-character-set=utf8 -e "delete from user_overspeed_count_$num where uid = ${arr_uids[i]} and activity_id in (246811552634,634781553051)"
echo 'del-mysql'
done;

修改的地方已做标注