mysql缓存怎么开启

sudo apt update
sudo apt install redis-server

sudo systemctl start redis-server
sudo systemctl enable redis-server

import redis
import mysql.connector

# 连接到Redis
redis_client = redis.StrictRedis(host='localhost', port=6379, db=0)

# 连接到MySQL
mysql_conn = mysql.connector.connect(
    host='localhost',
    user='your_username',
    password='your_password',
    database='your_database'
)
mysql_cursor = mysql_conn.cursor()

def get_data(query):
    # 尝试从Redis缓存中获取数据
    cached_data = redis_client.get(query)
    if cached_data:
        return cached_data.decode('utf-8')
    
    # 如果缓存中没有数据，则从MySQL中查询
    mysql_cursor.execute(query)
    data = mysql_cursor.fetchall()
    
    # 将查询结果存入Redis缓存
    redis_client.setex(query, 3600, str(data))  # 缓存1小时
    
    return data

# 示例查询
query = "SELECT * FROM your_table"
result = get_data(query)
print(result)

# 关闭连接
mysql_cursor.close()
mysql_conn.close()