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/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. Derived tables and common table expressions can also be specified in multiple-table UPDATE and DELETE statements, but can only be ...That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
When the joining member is up to date with all the group's transactions, it is declared online and can participate in the group as a normal member, and distributed recovery is complete. This minimizes the time taken for distributed recovery, and ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
The following list shows the CHANGE REPLICATION FILTER options and how they relate to --replicate-* server options: REPLICATE_DO_DB: Include updates based on database name. Filters set using this statement differ from those set using the server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication.html
For information about performing point-in-time recovery with NDB Cluster and NDB Cluster Replication, see Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”. This section explains how to set up and manage a configuration in ... NDB Cluster supports asynchronous replication, more usually referred to simply as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
It blocks until the replica has read and applied all updates up to the specified position in the source's binary log. If binary log transaction compression is in use and the transaction payload at the specified position is compressed (as a ... The ...The return value is the number of log events the replica had to wait for to advance to the specified ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
The statement can therefore potentially be left in the dump output when you replay the dump files on the replica, and the dump files can be replayed at different times. If the sources in the multi-source replication topology have existing data, it ...The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-general.html
In real life, most character sets have many characters: not just A and B but whole alphabets, sometimes multiple alphabets or eastern writing systems with thousands of characters, along with many special symbols and punctuation marks. A character ...A collation is a set of rules for comparing characters in a character ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...In cases where you have additional software safeguards, ultra-reliable hardware, or an application that can tolerate a small amount of data loss or inconsistency, you can adjust MySQL settings to trade some of the ACID reliability for greater performance or ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Undo logs in the rollback segment are divided into insert and update undo logs. Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the undo tablespace in which it resides. InnoDB ...