逍遥阁

php实现redis大键扫描的脚本

关键词: redis

php实现redis大键扫描的脚本

```
<?php
function report($redis, $dbname, $maxLength)
{
    $file = '/data/temp/redisReport.csv';
    $redis->setOption(Redis::OPT_SCAN, Redis::SCAN_RETRY);
    $it = NULL;
    while($keys = $redis->scan($it, '', 10000)){
        foreach($keys as $key){
            $info = checkKey($redis, $dbname, $key);
            if($info['ttl'] == -1 || $info['length'] >= $maxLength){
                $content = "{$info['dbname']},{$key},{$info['ttl']},{$info['type']},{$info['length']}";
                file_put_contents($file, $content . PHP_EOL, FILE_APPEND);
            }
        }
    }
}

function checkKey($redis, $dbname, $key)
{
    $ttl = $redis->ttl($key);
    $type = $redis->type($key);
    $length = 0;
    if($type == Redis::REDIS_STRING){
        $length = $redis->strlen($key);
    }
    else if($type == Redis::REDIS_HASH){
        $length = $redis->hlen($key);
    }
    else if($type == Redis::REDIS_LIST){
        $length = $redis->llen($key);
    }
    else if($type == Redis::REDIS_SET){
        $length = $redis->scard($key);
    }
    else if($type == Redis::REDIS_ZSET){
        $length = $redis->zcard($key);
    }
    return [
        'dbname' => $dbname,
        'ttl' => $ttl,
        'type' => $type,
        'length' => $length
    ];
}
//
$host = '192.168.1.20';
$port = 6379;
$timeout = 5;
$password = '';
$maxLength = 10240;
//
$redis = new Redis();
$redis->connect($host, $port, $timeout);
$redis->auth($password);
for($i = 0; $i <= 15; $i++){
    $redis->select($i);
    report($redis, $i, $maxLength);
}
?>
```

admin
2018-09-03 23:20:25
php