mysql 大数据翻页很慢

CREATE INDEX idx_column_name ON table_name(column_name);

SELECT id, name FROM table_name WHERE condition LIMIT 10 OFFSET 20;

CREATE INDEX idx_cover ON table_name(column1, column2);

CREATE TABLE table_name (
    id INT PRIMARY KEY,
    name VARCHAR(255)
) PARTITION BY RANGE (id) (
    PARTITION p0 VALUES LESS THAN (1000),
    PARTITION p1 VALUES LESS THAN (2000),
    PARTITION p2 VALUES LESS THAN MAXVALUE
);

import redis

r = redis.Redis(host='localhost', port=6379, db=0)

def get_data(page):
    cache_key = f'data_page_{page}'
    data = r.get(cache_key)
    if data is None:
        data = fetch_data_from_db(page)
        r.setex(cache_key, 3600, data)  # 缓存1小时
    return data