Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
For details of how to select IP addresses and ports as distributed recovery endpoints, and how joining members use them, see Section 20.5.4.1.1, “Selecting addresses for distributed recovery endpoints”. Adding an interval avoids the selection of ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks: mysql> CREATE TABLE "test" ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
The following statements are equivalent: SELECT EVENT_SCHEMA, EVENT_NAME, DEFINER, TIME_ZONE, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STARTS, ENDS, STATUS, ORIGINATOR, CHARACTER_SET_CLIENT, COLLATION_CONNECTION, DATABASE_COLLATION ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
SELECT FILE_ID, FILE_NAME, FILE_TYPE, TABLESPACE_NAME, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE, DATA_FREE, STATUS FROM INFORMATION_SCHEMA.FILES WHERE ENGINE='InnoDB'\G NDB Notes The FILES table provides ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-keywords-table.html
The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. Reserved keywords may require special treatment in some contexts, such as special quoting when used as identifiers (see Section ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Selecting columns or using retrieval conditions for dynamic metadata along with static metadata adds overhead to process the dynamic metadata. Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Session 3: mysql> SELECT * FROM t1; The SELECT statement issued in ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
The following query retrieves data from all of the table's columns: SELECT FILE_ID, START_LSN, END_LSN, SIZE_IN_BYTES, IS_FULL, CONSUMER_LEVEL FROM performance_schema.innodb_redo_log_files; Automatic Redo Log Capacity Configuration When the server ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_kerberos'; +-------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... Note Kerberos pluggable ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%ldap%'; +----------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------------+---------------+ | ...