PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
Note When performing schema changes on NDB tables, applications should wait until the ALTER TABLE statement has returned in the MySQL client connection that issued the statement before attempting to use the updated definition of the table.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-starting.html
Note You can also start the source with --binlog-format=MIXED, in which case row-based replication is used automatically when replicating between clusters. Note Unless you want replication to begin immediately, delay the start of the replication ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as my.ini. Advanced configuration options are related to the following MySQL log files: Error Log General Log Slow Query Log Bin Log Note The binary ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer.html
Note MySQL Installer cannot install both Community and Commercial releases of MySQL server on the same host. Note The connectors were bundled before MySQL Installer 1.6.7 (MySQL Server 8.0.34), and MySQL Installer could install each connector up to ... MySQL Installer is a standalone application designed to ease the complexity of installing and configuring MySQL products that run on Microsoft ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
(See Bug #42849.) Note It is also possible in MySQL 8.0 to use UNIX_TIMESTAMP(timestamp_column) as a partitioning expression for tables that are partitioned by LIST. A table that is partitioned by range is partitioned in such a way that each ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Note Although it is possible to “reset” an expired password by setting it to its current value, it is preferable, as a matter of good policy, to choose a different password. Note The empty password does not count in the password history and is ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
It is important to note that the replica sets gtid_next in a session context. Note that after you set gtid_next to a specific GTID, and the transaction has been committed or rolled back, an explicit SET @@SESSION.gtid_next statement must be issued ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
Note that although you can change the server ID dynamically to a nonzero value, doing so does not enable replication to start immediately. Note The presence of the server_uuid system variable does not change the requirement for setting a unique ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
Note By default, if GTIDs are in use on the source (gtid_mode=ON), mysqldump includes the GTIDs from the gtid_executed set on the source in the dump output to add them to the gtid_purged set on the replica. If the source database contains existing ...