Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Expirement to choose the best value for page size (or self-adapting) #36328

Closed
Tracked by #35633
tiancaiamao opened this issue Jul 19, 2022 · 1 comment · Fixed by #36331 or #36599
Closed
Tracked by #35633

Expirement to choose the best value for page size (or self-adapting) #36328

tiancaiamao opened this issue Jul 19, 2022 · 1 comment · Fixed by #36331 or #36599
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@tiancaiamao
Copy link
Contributor

In the past, we use default value min paging size = 64
max paging size = 8192 (64 << 7)

We need to figure out whether this setting is reasonable.
@tiancaiamao tiancaiamao mentioned this issue Jul 19, 2022
Closed
24 tasks
@tiancaiamao
Copy link
Contributor Author

image

@tiancaiamao tiancaiamao mentioned this issue Jul 19, 2022
Merged
12 tasks
@tiancaiamao tiancaiamao added the type/enhancement The issue or PR belongs to an enhancement. label Jul 19, 2022
ti-chi-bot pushed a commit that referenced this issue Jul 19, 2022
@tiancaiamao
util/paging: choose min paging size default value as 128, and max val…
0cecfc8 
…ue as 8192 (#36331)

close #36328
@tiancaiamao tiancaiamao reopened this Jul 27, 2022
@tiancaiamao tiancaiamao mentioned this issue Jul 27, 2022
Merged
12 tasks
ti-chi-bot pushed a commit that referenced this issue Jul 29, 2022
@tiancaiamao
*: introduce @@tidb_max_paging_size system variable for tuning (#36599)
8e77ce2 
close #36328
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
1 participant
@tiancaiamao