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/mysqlbinlog-server-id.html
When invoked with the --read-from-remote-server option, mysqlbinlog connects to a MySQL server, specifies a server ID to identify itself, and requests binary log files from the server. Specify the beginning file and --to-last-log: mysqlbinlog ...It ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
With these options set, the group member does not persist file names and file positions in the replication metadata repositories for these channels. The alternative UUID must be different from the server UUIDs of the members. It must also be ...The ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/changing-mysql-user.html
If directories or files within the MySQL data directory are symbolic links, chown -R might not follow symbolic links for you. If it does not, you must also follow those links and change the directories and files they point to. To start the server as ...To change mysqld to run as a normal unprivileged Unix user user_name, you must do the following: Stop the server if it is running (use mysqladmin ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
If a large number of such statements were executed on the source, this could lead to excessively large error log files. When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-virtualization.html
Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? A.18.1. Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? MySQL is ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
However, MySQL must be able to evaluate the expression's return value as part of a LESS THAN (<) comparison. Rather than splitting up the table data according to store number, you can use an expression based on one of the two DATE columns instead.
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-plugin.html
Instead, consider using the component_keyring_oci component for storing keyring data (see Section 8.4.4.11, “Using the Oracle Cloud Infrastructure Vault Keyring Component”). As indicated by the preceding table, several plugin-related system ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-status-table.html
BINLOG_FILE The name of the binary log file up to which data is cloned. BINLOG_POSITION The binary log file offset up to which data is cloned. The table only ever contains one row of data, or is empty. Note The Performance Schema table described ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
With this setting, the contents of the InnoDB redo log buffer are written out to the log file at each transaction commit and the log file is flushed to disk. However, the replica notices the network outage only after receiving no data from the ...