Delete Redis Keys matching a pattern Laravel 5.7

Question

I have been searching and tried multiple solution but could got any helping results, I want to clear/delete all keys matching pattern products:*.

Following are the things i have tried.

Redis::del('products:*');
Redis::del('*products:*');
Redis::del('*products*');

But nothing worked.

It is deleting key if i provide exact key name like : Redis::del('products:2:3:45');

Key are being generated like this: products:1:4:45

I have read documentation but could find anything regarding my query.

Please help.

See https://stackoverflow.com/questions/32295488/how-to-delete-multiple-redis-keys-with-the-same-pattern-in-php-using-phpredis. This may solve your problem — Ali Khalili, Oct 22 '19 at 14:09

score 23 · Accepted Answer · answered Oct 22 '19 at 14:08

23

You can't delete by pattern. But you can get all the keys by this pattern and then delete them:

Redis::del(Redis::keys('products:*'));

See more here.

answered Oct 22 '19 at 14:08

freeek

985
7
22

2

Working like a charm with `Laravel Framework 9.3.0`. – Lounis Sep 16 '22 at 14:04

score 4 · Answer 2 · answered Oct 22 '19 at 14:18

4

I read somewhere that you cannot delete based on wildcard, you need to give the keys explicitly.

There is still a way to grab all keys and then run delete on those keys. I do it using cli like this:

redis-cli KEYS "products:*" | xargs redis-cli DEL

It fetches all the keys that match the query and run DEL on them. You can execute this command from Laravel.

In Laravel, fetch all keys and run delete on them using

Redis::del(Redis::keys('products:*'));

answered Oct 22 '19 at 14:18

Danyal Sandeelo

12,196
10
47
78

of course, update your prefix accordingly to support prefixes as well. @MarufAlom – Danyal Sandeelo Dec 25 '20 at 05:38

score 3 · Answer 3 · answered Nov 26 '20 at 21:53

3

With Laravel 8 it wasn't deleting cause the key has a prefix so what I did is remove the prefix before passing it to del()

$keys = Redis::keys( 'products:*' );

if ( !empty( $keys ) ){
    $keys = array_map(function ($k){
        return str_replace('_prefix_database', '', $k);
    }, $keys);

    Redis::del( $keys );
}

i hope this will be helpful for someone

answered Nov 26 '20 at 21:53

Moode Osman

1,715
18
17

This worked well in Laravel 7 also. Thanks! – Christine Treacy Jan 04 '23 at 18:32

Nick · Answer 4 · 2019-10-22T15:49:20.777

0

We can use the array_map function to go over all the keys in redis and do delete.

$redis = new Redis;
$prefix = $redis->getOption(Redis::OPT_PREFIX);
$redis->delete(array_map(
    function ($key) use ($prefix) {
        return str_replace($prefix, '', $key);
    }, $redis->keys('*'))
);

edited Oct 22 '19 at 15:49

answered Oct 22 '19 at 14:13

Nick

536
2
8

3

Please share the source when you copy paste from another source – Danyal Sandeelo Oct 22 '19 at 14:13
Please add some explanation to your answer such that others can learn from it – Nico Haase Oct 22 '19 at 15:44

score 0 · Answer 5 · answered Jan 14 '21 at 17:41

With Laravel8 I use:

    public function handle()
    {
        $this->call('queue:flush');

        $arrayFailed        = Redis::connection('horizon')->keys('failed:*');
        $arrayFailedJobs    = Redis::connection('horizon')->keys('failed_jobs');
        $arrayToRemove      = array_merge($arrayFailed, $arrayFailedJobs);

        $arrayMap = array_map(function ($k) {
            return str_replace(config('horizon.prefix'), '', $k);
        }, $arrayToRemove);
        Redis::connection('horizon')->del($arrayMap);

        $this->line('');
    }

Delete Redis Keys matching a pattern Laravel 5.7

5 Answers5