mysql 如何提高更新速度

CREATE INDEX idx_user_id ON users(user_id);

UPDATE users
SET status = CASE id
    WHEN 1 THEN 'active'
    WHEN 2 THEN 'inactive'
    WHEN 3 THEN 'pending'
END
WHERE id IN (1, 2, 3);

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    status VARCHAR(50)
)
PARTITION BY RANGE (YEAR(created_at)) (
    PARTITION p0 VALUES LESS THAN (2020),
    PARTITION p1 VALUES LESS THAN (2021),
    PARTITION p2 VALUES LESS THAN (2022),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

import redis
import pymysql

r = redis.Redis(host='localhost', port=6379, db=0)
conn = pymysql.connect(host='localhost', user='user', password='password', db='database')

def get_user_status(user_id):
    status = r.get(f'user:{user_id}:status')
    if status is None:
        cursor = conn.cursor()
        cursor.execute("SELECT status FROM users WHERE id = %s", (user_id,))
        status = cursor.fetchone()[0]
        r.setex(f'user:{user_id}:status', 3600, status)  # 缓存1小时
    return status