How to Optimize Pagination with TiDB auto_random

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb auto_random分页如何优化

| username: TiDBer_pkQ5q1l0

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.2.1
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
Added a table with 800 million records, need to perform pagination queries based on a certain time field, the primary key id is auto_random, how can this be optimized?
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: tidb菜鸟一只 | Original post link

Take a look at Article 14 to see if it helps you.

| username: TiDBer_pkQ5q1l0 | Original post link

Okay, thank you!

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.