关于shell的keys的处理脚本

朴灿烈づ我的快乐病毒、 2022-10-07 05:54 133阅读 0赞

1、分批次删除redis key的shell脚本

#!/bin/sh
    host=172.63.3.87
    port=6379
    
    db_ip=172.63.3.87
    db_port=6379
    #password=abc123
    cursor=0
    cnt=10000
    new_cursor=0
    
    redis-cli -h $db_ip -p $db_port  scan $cursor match JWT:token:user:* count $cnt > scan_tmp_key
    new_cursor=`sed -n '1p' scan_tmp_key`
    sed -n '2,$p' scan_tmp_key > scan_key
    cat scan_key |while read line
    do
        ttl_result=`redis-cli -h $db_ip -p $db_port del $line`
        if [[ $ttl_result == ok ]];then
            echo $line delete successed >> new-key.log
        fi
    done
    
    
    while [ $cursor -ne $new_cursor ]
    do
        redis-cli -h $db_ip -p $db_port  scan $new_cursor match JWT:token:user:* count $cnt > scan_tmp_key
        new_cursor=`sed -n '1p' scan_tmp_key`
        sed -n '2,$p' scan_tmp_key > scan_key
        cat scan_key |while read line
        do
            ttl_result=`redis-cli -h $db_ip -p $db_port del $line`
            if [[ $ttl_result == ok ]];then
                echo $line delete successed >> new-key.log
            fi
        done
    done
    rm -rf scan_tmp_key
    rm -rf scan_key

2、分批次查询key的过期时间

#!/bin/sh
    host=172.63.3.87
    port=6379
    
    db_ip=172.63.3.87
    db_port=6379
    #password=abc123
    cursor=0
    cnt=10000
    new_cursor=0
    
    redis-cli -h $db_ip -p $db_port  scan $cursor count $cnt > scan_tmp_result
    new_cursor=`sed -n '1p' scan_tmp_result`
    sed -n '2,$p' scan_tmp_result > scan_result
    cat scan_result |while read line
    do
        ttl_result=`redis-cli -h $db_ip -p $db_port ttl $line`
        if [[ $ttl_result == -1 ]];then
            echo $line >> no_ttl.log
        fi
    done
    
    
    while [ $cursor -ne $new_cursor ]
    do
        redis-cli -h $db_ip -p $db_port  scan $new_cursor count $cnt > scan_tmp_result
        new_cursor=`sed -n '1p' scan_tmp_result`
        sed -n '2,$p' scan_tmp_result > scan_result
        cat scan_result |while read line
        do
            ttl_result=`redis-cli -h $db_ip -p $db_port ttl $line`
            if [[ $ttl_result == -1 ]];then
                echo $line >> no_ttl.log
            fi
        done
    done
    rm -rf scan_tmp_result
    rm -rf scan_result

或者我们也可以按条件筛选key

cat redisttl.sh 
    #!/bin/sh
    
    db_ip=172.63.3.87
    db_port=6379
    #password=abc123
    cursor=0
    cnt=10000
    new_cursor=0
    
    for i in Valid: JWT:token:user: SMS:forgetMobile SMS:forgetCountry
    do
        redis-cli -h $db_ip -p $db_port  scan $cursor match $i* count $cnt > scan_tmp_result
        new_cursor=`sed -n '1p' scan_tmp_result`
        sed -n '2,$p' scan_tmp_result > scan_result
        cat scan_result |while read line
        do
            ttl_result=`redis-cli -h $db_ip -p $db_port ttl $line`
            if [[ $ttl_result == -1 ]];then
                echo $line >> no_ttl.log
            fi
        done
        
        
        while [ $cursor -ne $new_cursor ]
        do
            redis-cli -h $db_ip -p $db_port  scan $new_cursor match $i* count $cnt > scan_tmp_result
            new_cursor=`sed -n '1p' scan_tmp_result`
            sed -n '2,$p' scan_tmp_result > scan_result
            cat scan_result |while read line
            do
                ttl_result=`redis-cli -h $db_ip -p $db_port ttl $line`
                if [[ $ttl_result == -1 ]];then
                    echo $line >> no_ttl.log
                fi
            done
        done
        rm -rf scan_tmp_result
        rm -rf scan_result
    done