https://dev.mysql.com/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information ...
https://dev.mysql.com/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/session-state-tracking.html
One use for the tracker mechanism is to provide a means for MySQL connectors and client applications to determine whether any session context is available to permit session migration from one server to another. For example, a load-balancing ...A ...
https://dev.mysql.com/set-character-set.html
SET CHARACTER SET sets three session system variables: character_set_client and character_set_results are set to the given character set, and character_set_connection to the value of character_set_database. SET {CHARACTER SET | CHARSET} ...
https://dev.mysql.com/set-default-role.html
For each user named immediately after the TO keyword, this statement defines which roles become active when the user connects to the server and authenticates, or when the user executes the SET ROLE DEFAULT statement during a session. SET DEFAULT ...
https://dev.mysql.com/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...The optional ...
https://dev.mysql.com/set-role.html
When a user connects to the server and authenticates successfully, the server determines which roles to activate as the default roles. SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... } SET ROLE modifies the current user's effective ...
https://dev.mysql.com/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. Descriptions for those forms that are not associated with a specific server capability appear in subsections ...
https://dev.mysql.com/set-variable.html
However, the change affects the corresponding session value only for clients that connect after the change. qualifier: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; This SET syntax enables you to make configuration ...
https://dev.mysql.com/setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...
