PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/session-state-tracking.html
The tracker mechanism provides 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 connector managing a ...A ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/show-replicas.html
{SHOW REPLICAS} Displays a list of replicas currently registered with the source. From MySQL 8.0.22, use SHOW REPLICAS in place of SHOW SLAVE HOSTS, which is deprecated from that release. SHOW REPLICAS should be executed on a server that acts as a ...