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/change-replication-source-to.html
CHANGE REPLICATION SOURCE TO causes the previous values for SOURCE_HOST, SOURCE_PORT, SOURCE_LOG_FILE, and SOURCE_LOG_POS to be written to the error log, along with other information about the replica's state prior to execution. GTID_ONLY = {0|1} ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
With --upgrade=NONE, the server upgrades nothing (skips steps 1 and 2), but also exits with an error if the data dictionary must be upgraded. If both versions indicate an upgrade is needed, the data dictionary upgrade must occur first. If the server ...System tables (that is, the remaining non-data dictionary tables), which are used for other operational ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
CHANGE MASTER TO causes the previous values for MASTER_HOST, MASTER_PORT, MASTER_LOG_FILE, and MASTER_LOG_POS to be written to the error log, along with other information about the replica's state prior to execution. GTID_ONLY = {0|1} Stops the ...] ...CHANGE MASTER TO requires the REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER ...From MySQL 8.0.23, use ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-monitoring.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. In order of occurrence, cloning operation stage events include: stage/innodb/clone (file copy): Indicates progress of the file ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ...Data_length For MyISAM, Data_length is the length of the data file, in ...See Chapter ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption when backing up InnoDB data files; mysqldump provides online logical backup. It was assumed ...A ...This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
Install the okvclient.jar file using the following command (you must have JDK 1.4 or higher): java -jar okvclient.jar -d dir_name [-v] The directory name following the -d option is the location in which to install extracted files. The plugin works ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...Some pertinent information sources: Oracle Key Vault site Oracle Key Vault documentation In Oracle Key Vault ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-rolling-restart.html
This can be done in any of three ways: Start each data node process (ndbd or possibly ndbmtd) with the --initial option, which forces the data node to clear its file system and to reload all NDB Cluster data and metadata from the other data nodes.