Why is there no tidb_enable_paging variable in TiDB?

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

Original topic: tidb没有tidb_enable_paging变量是什么原因?

| username: 额仑小狼

[TiDB Usage Environment] Production Environment
[TiDB Version] 6.1.7
[Reproduction Path] TiDB cluster set up using tidb-operator, mostly referring to the official documentation’s manifest
[Encountered Problem: Problem Phenomenon and Impact]
show variables like ‘%paging%’;
No variables are displayed, not sure what the reason is? Do I need to upgrade to 6.5.x?

| username: Kongdom | Original post link

According to the documentation, this was introduced in v5.4.0.

Could it be related to the way tidb-operator works?

| username: 额仑小狼 | Original post link

The tidb-operator is version v1.4.7, and it was deployed according to the official steps.

| username: zhanggame1 | Original post link

The official documentation for version 6.1 has this.

| username: 大飞哥online | Original post link

show variables like ‘tidb_enable%’; What does it have?

| username: heiwandou | Original post link

Check the variables.

| username: 人如其名 | Original post link

6.1 This field is still in a hidden state, but it will be visible after 6.2.
Variables in a hidden state can be set, but you cannot see them.

Hidden: true

{Scope: ScopeGlobal | ScopeSession, Name: TiDBEnablePaging, Value: BoolToOnOff(DefTiDBEnablePaging), Type: TypeBool, Hidden: true, SetSession: func(s *SessionVars, val string) error {
		s.EnablePaging = TiDBOptOn(val)
		return nil
	}

This PR removes the Hidden keyword, so this situation no longer exists.

	// Deprecated: Hidden previously meant that the variable still responds to SET but doesn't show up in SHOW VARIABLES
	// However, this feature is no longer used. All variables are visible.
| username: Fly-bird | Original post link

It should be a version issue.

| username: Kongdom | Original post link

In the future, strange issues will have to be directly sourced~ :+1:

| username: system | Original post link

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