[MDEV-23492] performance_schema_digests_size changing from default to 5000 when enabling performance_schema - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.3.13
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7
Component/s: Configuration
Labels:
None
Environment:
Production

Description

Hi Team,

On MariaDB version 10.3.13, default value of performance_schema_digests_size is '-1' as per document. However when enabling performance_schema on this the value is getting changed from -1 to 5000

https://mariadb.com/kb/en/performance-schema-system-variables/#performance_schema_digests_size

I did not find any document stating the same. Steps to reproduce

1. Installed MariaDB 10.3.13 on rhel 7 and verify the value of 'performance_schema_digests_size' it will show '-1'.
2. Enable performance_scheme and again see the value, it changes to '5000'
3. Though I can change value between -1 to 200 but not able to understand howcome it is showing 5000 where as the limit is between -1 to 200.

[root@ip-xx.xx.xx.xx ~]# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 10.3.13-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;

+-----------------+

| @@version       |

+-----------------+

| 10.3.13-MariaDB |

+-----------------+

1 row in set (0.000 sec)

+-----------------------------------+

| @@performance_schema_digests_size |

+-----------------------------------+

|                                -1 |

+-----------------------------------+

1 row in set (0.000 sec)

+----------------------+

| @@performance_schema |

+----------------------+

|                    0 |

+----------------------+

1 row in set (0.000 sec)

MariaDB [(none)]>

After enabling performacne_schema on EC2 instance the value changed to 5000

[root@ip-xx.xx.xx.xx my.cnf.d]# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 10.3.13-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;

+-----------------+

| @@version       |

+-----------------+

| 10.3.13-MariaDB |

+-----------------+

1 row in set (0.000 sec)

+-----------------------------------+

| @@performance_schema_digests_size |

+-----------------------------------+

|                              5000 |

+-----------------------------------+

1 row in set (0.000 sec)

+----------------------+

| @@performance_schema |

+----------------------+

|                    1 |

+----------------------+

1 row in set (0.000 sec)

MariaDB [(none)]>

Tried chaning performance_schema_digests_size to 100 and was able to change.

[root@ip-xx.xx.xx.xx my.cnf.d]# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 10.3.13-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;

+-----------------+

| @@version       |

+-----------------+

| 10.3.13-MariaDB |

+-----------------+

1 row in set (0.000 sec)

+-----------------------------------+

| @@performance_schema_digests_size |

+-----------------------------------+

|                               100 |

+-----------------------------------+

1 row in set (0.000 sec)

+----------------------+

| @@performance_schema |

+----------------------+

|                    1 |

+----------------------+

1 row in set (0.000 sec)

MariaDB [(none)]>

Again changed value from 100 to -1 when performance schema is enabled and it changed to 5000

[root@ip-xx.xx.xx.xx my.cnf.d]# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 10.3.13-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;

+-----------------+

| @@version       |

+-----------------+

| 10.3.13-MariaDB |

+-----------------+

1 row in set (0.000 sec)

+-----------------------------------+

| @@performance_schema_digests_size |

+-----------------------------------+

|                              5000 |

+-----------------------------------+

1 row in set (0.000 sec)

+----------------------+

| @@performance_schema |

+----------------------+

|                    1 |

+----------------------+

1 row in set (0.000 sec)

MariaDB [(none)]>

Is this expected behavior?

Attachments

Activity

Ascending order - Click to sort in descending order

Jitender Singh created issue - 2020-08-16 14:34

Sergei Golubchik made changes - 2020-08-30 20:03

Field	Original Value	New Value
Description	Hi Team, On MariaDB version 10.3.13, default value of performance_schema_digests_size is '-1' as per document. However when enabling performance_schema on this the value is getting changed from -1 to 5000 https://mariadb.com/kb/en/performance-schema-system-variables/#performance_schema_digests_size I did not find any document stating the same. Steps to reproduce 1. Installed MariaDB 10.3.13 on rhel 7 and verify the value of 'performance_schema_digests_size' it will show '-1'. 2. Enable performance_scheme and again see the value, it changes to '5000' 3. Though I can change value between -1 to 200 but not able to understand howcome it is showing 5000 where as the limit is between -1 to 200. [root@ip-xx.xx.xx.xx ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| -1 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 0 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> After enabling performacne_schema on EC2 instance the value changed to 5000 [root@ip-xx.xx.xx.xx my.cnf.d]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| 5000 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 1 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> Tried chaning performance_schema_digests_size to 100 and was able to change. [root@ip-xx.xx.xx.xx my.cnf.d]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| 100 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 1 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> Again changed value from 100 to -1 when performance schema is enabled and it changed to 5000 [root@ip-xx.xx.xx.xx my.cnf.d]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| 5000 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 1 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> Is this expected behavior?	Hi Team, On MariaDB version 10.3.13, default value of performance_schema_digests_size is '-1' as per document. However when enabling performance_schema on this the value is getting changed from -1 to 5000 https://mariadb.com/kb/en/performance-schema-system-variables/#performance_schema_digests_size I did not find any document stating the same. Steps to reproduce 1. Installed MariaDB 10.3.13 on rhel 7 and verify the value of 'performance_schema_digests_size' it will show '-1'. 2. Enable performance_scheme and again see the value, it changes to '5000' 3. Though I can change value between -1 to 200 but not able to understand howcome it is showing 5000 where as the limit is between -1 to 200. {noformat} [root@ip-xx.xx.xx.xx ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| -1 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 0 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> After enabling performacne_schema on EC2 instance the value changed to 5000 [root@ip-xx.xx.xx.xx my.cnf.d]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| 5000 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 1 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> Tried chaning performance_schema_digests_size to 100 and was able to change. [root@ip-xx.xx.xx.xx my.cnf.d]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| 100 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 1 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> {noformat} Again changed value from 100 to -1 when performance schema is enabled and it changed to 5000 {noformat} [root@ip-xx.xx.xx.xx my.cnf.d]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema; +-----------------+ \| @@version \| +-----------------+ \| 10.3.13-MariaDB \| +-----------------+ 1 row in set (0.000 sec) +-----------------------------------+ \| @@performance_schema_digests_size \| +-----------------------------------+ \| 5000 \| +-----------------------------------+ 1 row in set (0.000 sec) +----------------------+ \| @@performance_schema \| +----------------------+ \| 1 \| +----------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> {noformat} Is this expected behavior?

Sergei Golubchik made changes - 2020-08-31 07:44

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik added a comment - 2020-08-31 07:45

yes, 5000 is expected behavior (it's the auto-configured value, the help text says "-1 for automated sizing").

The fact that auto value is larger than manually allowed upper threshold is a bug.

Sergei Golubchik added a comment - 2020-08-31 07:45 yes, 5000 is expected behavior (it's the auto-configured value, the help text says "-1 for automated sizing"). The fact that auto value is larger than manually allowed upper threshold is a bug.

Sergei Golubchik made changes - 2020-08-31 09:36

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]

Sergei Golubchik made changes - 2020-08-31 09:36

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2020-08-31 09:36

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2020-10-23 15:02

Fix Version/s		10.2.35 [ 25022 ]
Fix Version/s		10.3.26 [ 25021 ]
Fix Version/s		10.4.16 [ 25020 ]
Fix Version/s		10.5.7 [ 25019 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:52

Workflow

MariaDB v3 [ 112469 ]

MariaDB v4 [ 158251 ]

People

Assignee:: Sergei Golubchik

Reporter:: Jitender Singh

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2020-08-16 14:34

Updated:: 2020-10-23 15:02

Resolved:: 2020-10-23 15:02

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.