content_image/771988.jpg content_image/771989.jpg
• performance_schema_session_connect_attrs_size 

<img src='content_image/771988.jpg'>

The amount of preallocated memory per thread reserved to hold connection attribute key- value pairs. If the aggregate size of connection attribute data sent by a client is larger than this amount, the Performance Schema truncates the attribute data, increments the Performance_schema_session_connect_attrs_lost  status variable, and writes a message to the error log indicating that truncation occurred if the log_error_verbosity  system variable is greater than 1. A _truncated  attribute is also added to the session attributes with a value indicating how many bytes were lost, if the attribute buffer has sufficient space. This enables the Performance Schema to expose per-connection truncation information in the connection attribute tables. This information can be examined without having to check the error log. 

The default value of performance_schema_session_connect_attrs_size is autosized at server startup. This value may be small, so if truncation occurs ( Performance_schema_session_connect_attrs_lost  becomes nonzero), you may wish to set performance_schema_session_connect_attrs_size  explicitly to a larger value. 

Although the maximum permitted performance_schema_session_connect_attrs_size  value is 1MB, the effective maximum is 64KB because the server imposes a limit of 64KB on the aggregate size of connection attribute data it accepts. If a client attempts to send more than 64KB of attribute data, the server rejects the connection. For more information, see Section 27.12.9, “Performance Schema Connection Attribute Tables” . 

• performance_schema_setup_actors_size 

<img src='content_image/771989.jpg'>

The number of rows in the setup_actors  table. 

