MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 761 to 770 of 779 total results

16.1.6 Replication and Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-options.html

System Variable server_uuid Scope Global Dynamic No Type String When starting, the MySQL server automatically obtains a UUID as follows: Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir is the server's data ...

16.2.1.2 Usage of Row-Based Logging and Replication

https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html

This statement displays an event as a base 64-encoded string, the meaning of which is not evident. MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used impacts the size and ...

16.1.2.5 Setting Up Replicas

https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html

For a full list of options, and information about the maximum permissible length for the string-valued options, see Section 13.4.2.1, “CHANGE MASTER TO Statement”. Before you proceed, ensure that you have: Configured the source with the ...

3.3.4.2 Selecting Particular Rows

https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html

String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, ...

13.7.4.2 SET CHARACTER SET Statement

https://dev.mysql.com/doc/refman/5.7/en/set-character-set.html

SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...

13.7.5.4 SHOW COLLATION Statement

https://dev.mysql.com/doc/refman/5.7/en/show-collation.html

Sortlen This is related to the amount of memory required to sort strings expressed in the character set. SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW ...

13.7.5.5 SHOW COLUMNS Statement

https://dev.mysql.com/doc/refman/5.7/en/show-columns.html

Collation The collation for nonbinary string columns, or NULL for other columns. SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...

6.4.1.11 Socket Peer-Credential Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html

If the names do not match, the plugin checks whether the socket user name matches the name specified in the authentication_string column of the mysql.user system table row. The authentication_string value can be specified using an IDENTIFIED ...AS ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...

13.4.2.5 START SLAVE Statement

https://dev.mysql.com/doc/refman/5.7/en/start-slave.html

The option cannot be set to an empty or null string. START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { ...

5.1.8.3 Structured System Variables

https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html

The variable is not interpreted as a compound name, but as a simple string for a LIKE pattern-matching operation: mysql> SHOW GLOBAL VARIABLES LIKE 'hot_cache.key_buffer_size'; This is the exception to being able to use structured variable names ...

Displaying 761 to 770 of 779 total results