mysql 千万级别分页

SELECT * FROM table_name
WHERE id > last_seen_id
ORDER BY id ASC
LIMIT page_size;

SELECT * FROM table_name
WHERE id > last_seen_id
ORDER BY id ASC
LIMIT page_size;

import redis
import pymysql

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

# 连接 MySQL
mysql_conn = pymysql.connect(host='localhost', user='user', password='password', db='database')
mysql_cursor = mysql_conn.cursor()

def get_page_data(page, page_size):
    cache_key = f'page_{page}_{page_size}'
    cached_data = redis_client.get(cache_key)
    if cached_data:
        return json.loads(cached_data)
    
    offset = (page - 1) * page_size
    query = f"SELECT * FROM table_name LIMIT {offset}, {page_size}"
    mysql_cursor.execute(query)
    data = mysql_cursor.fetchall()
    
    redis_client.setex(cache_key, 3600, json.dumps(data))
    return data