PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/start-replica.html
START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...uuid: ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-sha2-cache-plugin.html
You can use X Plugin to authenticate against such accounts using non-SSL connections with SHA256_MEMORY authentication and SSL connections with PLAIN authentication. Before you can use non-SSL X Protocol connections to authenticate an account that ... X Plugin supports MySQL user accounts created with the caching_sha2_password authentication ...
https://dev.mysql.com/doc/refman/9.7/en/encryption-functions.html
Their return value is a string that has a character set and collation determined by the character_set_connection and collation_connection system variables. Caution Passwords or other sensitive values supplied as arguments to encryption functions are ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-sql-modes.html
Using the statement SET [GLOBAL|SESSION] sql_mode='modes', you can change the settings from within a connection, either locally to the connection, or to take effect globally. Is the mode dependent on the database or connection? A mode is not linked ...What is the default server SQL mode when MySQL 9.7 is installed? ...
https://dev.mysql.com/doc/refman/9.7/en/federated-create.html
Create the table on the local server with an identical table definition, but adding the connection information that links the local table to the remote table. You can either create the local table and specify the connection string (containing the ...
https://dev.mysql.com/doc/refman/9.7/en/federated-usagenotes.html
When using a CONNECTION string, you cannot use an '@' character in the password. You can get round this limitation by using the CREATE SERVER statement to create a server connection. The following items indicate features that the FEDERATED storage ...
https://dev.mysql.com/doc/refman/9.7/en/fips-mode.html
FIPS mode also applies to attempts by clients to connect to the server. FIPS mode also applies to attempts by clients to connect to the server. However, enabling FIPS mode does not require that an encrypted connection must be used, or that user ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-servers.html
To see the values used by a given instance, connect to it and execute a SHOW VARIABLES statement. In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-data-node-memory-management.html
The send buffer reserved size is calculated in two steps: Use the value of the TotalSendBufferMemory configuration parameter (no default value) or the sum of the individual send buffers used by all individual connections to the data node. A data ...