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/group-replication-summary.html
MySQL Group Replication builds on top of such properties and abstractions and implements a multi-source update everywhere replication protocol. When a read/write transaction is ready to commit at the originating server, the server atomically ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ...Servers can leave and join the group and the view is updated ... This chapter explains MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html
Errors for invalid values can be suppressed in strict mode if you use INSERT IGNORE or UPDATE IGNORE. Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. How AUTO_INCREMENT behaves depending on the NO_AUTO_VALUE_ON_ZERO SQL mode: Section 7.1.11, “Server SQL Modes”.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, ... Full-text searches are supported for InnoDB and MyISAM tables ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly read-only operations ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-events.html
Table 25.61 Events relating to NDB Cluster schema operations Event Priority Severity Level Description CreateSchemaObject 8 INFO Schema objected created AlterSchemaObject 8 INFO Schema object updated DropSchemaObject 8 INFO Schema object dropped ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
Each time the management server updates its configuration data, it writes a new cache file. --interactive Command-Line Format --interactive Starts ndb_mgmd in interactive mode; that is, an ndb_mgm client session is started as soon as the management ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. With strict mode enabled, the warnings would become errors and terminate the INSERT. The ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
To update cached values at any time for a given table, use ANALYZE TABLE. Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. For ...The ...