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/non-typed-operators.html
/ Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) = Equal operator ^ Bitwise XOR AND, && Logical AND BETWEEN ... ->> Return value from JSON column after ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...(Bug #11754117, Bug #45670) This issue does not affect tables using the InnoDB storage engine, since an InnoDB table with an AUTO_INCREMENT column requires at least one key where the auto-increment column is the only or leftmost ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
The account can also be safely used by an administrator to apply or reapply transactions from mysqlbinlog output, for example to recover from a replication error on the channel. After setting up the user account, use the GRANT statement to grant ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
This applies to mixed-format replication as well, since this enables some updates to be replicated using the statement-based format. However, it should be safe to use --replicate-do-db for this purpose if you are using row-based replication only, ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
(This is a condition likely to exist on a replica if you have issued a STOP REPLICA statement or if the replica is highly loaded.) For a server where GTIDs are in use (gtid_mode is ON), issuing RESET REPLICA has no effect on the GTID execution ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
For example, to ensure safe startup and shutdown of MySQL you could use the following commands to add the right links: $> ln /etc/init.d/mysql /etc/rc3.d/S91mysql $> ln /etc/init.d/mysql /etc/rc0.d/K02mysql To remove MySQL, the installed package ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data. Storage engines are MySQL components that handle the SQL operations for different table types.
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
The events_transactions_current table displays the current status of the most recent monitored transaction event on the thread, and does not update this status when the thread is idle. If two XA transactions committed in parallel on the source are ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-disable-gtids.html
However, if you have the possibility to take the servers offline when disabling GTIDs mode that process is easier. You cannot disable GTID transactions if this option is set together with the --log-slave-updates option (which is the default) and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html
MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position 8.0.26 SOURCE_POS_WAIT() Block until the replica has read and applied all updates up to the specified position 8.0.26 ... The functions described ...