[MDEV-25220] performance_schema_session_connect_attrs_size set to 512 by default Created: 2021-03-22  Updated: 2021-03-23  Resolved: 2021-03-23

Status: Closed
Project: MariaDB Server
Component/s: Performance Schema
Affects Version/s: 10.5.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Christopher E Bowen Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: performance
Environment:

5 node mariadb cluster running 10.5.9, rhel 8, 24G memory, 4 cpus vmware vhosts



 Description   

As of the upgrade to 10.5.9 (autoupdate) I was seeing a large number of warnings in my mariadb logs saying attribute lengths of 569/570 were truncated. When I looked at global variables performance_schema_session_connect_attrs_size was at 512. This is a variable I did not define specifically and the default is supposed to be -1. When I set this setting specifically and restarted mariadb on the nodes the errors went away.

2021-03-22 10:31:54 142120 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:31:58 335410 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:31:58 335420 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:31:58 240646 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:31:59 335410 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:03 408238 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:06 335407 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:07 335412 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:07 142120 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:08 335418 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:10 335407 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:10 429847 [Warning] Connection attributes of length 569 were truncated
2021-03-22 10:32:11 335412 [Warning] Connection attributes of length 569 were truncated



 Comments   
Comment by Sergei Golubchik [ 2021-03-23 ]

The help text for this variable says "... Use 0 to disable, -1 for automated sizing".
In other words, -1 means not the value that this setting will have at run-time, but that the server will automatically assign some value to it. And currently "automatic sizing" for performance_schema_session_connect_attrs_size means the value of 512.

Generated at Thu Feb 08 09:36:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.