PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Note The NDB storage engine uses idempotent execution mode, which suppresses duplicate-key and other errors that otherwise break circular replication of NDB Cluster. In the event of a node failure, errors in replication of NDB tables without primary ... This section discusses known problems or issues when using replication with NDB ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
You can prevent the use of other storage engines by setting the disabled_storage_engines system variable on group members, for example: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Primary Keys. Every table that is to be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
Each row in the index node contains the values of the (user-specified or system-generated) primary key and all the other columns of the table. Secondary indexes in InnoDB tables are also B-trees, containing pairs of values: the index key and a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, must be specified to create an undo tablespace. Also, the physical page size of the compressed table (KEY_BLOCK_SIZE) must be equal to FILE_BLOCK_SIZE/1024. For example, if innodb_page_size=16K, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 29.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-counters.html
A primary-key read counts as one operation, as does a primary-key update. LOCAL_WRITES and LOCAL_READS are primary-key operations using a transaction coordinator in a node that also holds the primary fragment replica of the record. The counters ...
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. However, the row constructor ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
The replication_asynchronous_connection_failover_managed table has these indexes: Primary key on (CHANNEL_NAME, MANAGED_NAME) TRUNCATE TABLE is not permitted for the replication_asynchronous_connection_failover_managed table. This table holds ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to ...