mysql 应用缓存清理

-- 示例：设置查询缓存过期时间
SET GLOBAL query_cache_size = 64 * 1024 * 1024; -- 设置查询缓存大小
SET GLOBAL query_cache_type = ON; -- 开启查询缓存

# 示例：使用Redis的分布式锁
import redis
import time

r = redis.Redis()

def acquire_lock(lock_name, acquire_timeout=10):
    identifier = str(uuid.uuid4())
    end = time.time() + acquire_timeout
    while time.time() < end:
        if r.setnx(lock_name, identifier):
            return identifier
        time.sleep(0.001)
    return False

def release_lock(lock_name, identifier):
    with r.pipeline() as pipe:
        while True:
            try:
                pipe.watch(lock_name)
                if pipe.get(lock_name) == identifier:
                    pipe.multi()
                    pipe.delete(lock_name)
                    pipe.execute()
                    return True
                pipe.unwatch()
                break
            except redis.WatchError:
                pass
    return False

# 示例：使用布隆过滤器
from bloom_filter import BloomFilter

bf = BloomFilter(capacity=1000000, error_rate=0.001)

def is_exist(key):
    return bf.contains(key)

def add_to_bloom(key):
    bf.add(key)