PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 { ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...