PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-permissions.html
Beginning with MySQL 8.0.22, the system variable group_replication_ip_allowlist is used to specify the allowlist, and for releases before MySQL 8.0.22, the system variable group_replication_ip_whitelist is used. Note When the MySQL communication ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
These functions can be used only when all group members are running MySQL 8.0.13 or later. In MySQL 8.0.14 and later, you can also use the group_replication_consistency system variable to set the group's level of transaction consistency to prevent ... In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. The file name includes the file path, which may be relative to the MySQL data directory (the value of the datadir system variable). As of MySQL 8.0.21, ...In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
Both files should be readable only by the appropriate user that runs the server, typically mysql. The manifest file must be named mysqld.my and added to the same directory where mysqld is installed. It contains the path to the file where the server ... The component_keyring_file keyring component stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/option-file-options.html
Most MySQL programs that support option files handle the following options. Exceptions: Even with --defaults-file, mysqld reads mysqld-auto.cnf and client programs read .mylogin.cnf. For example, the mysql client normally reads the [client] and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. In the syntax just shown, column_list is a list of one or more columns (sometimes called a ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
For another MySQL extension to standard SQL—that either inserts or updates—see Section 15.2.7.2, “INSERT ... In MySQL 8.0.19 and later, you can specify the column values that REPLACE attempts to insert using VALUES ROW(). If you are using the ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. This enables the ; delimiter used in the procedure ... Each stored program contains a body that consists of an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-encrypted-connections.html
To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables used with MySQL Server. For example, X Plugin can have SSL key, certificate, and ... This section explains how to configure X Plugin to use encrypted ...