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-multi-primary-mode.html
While traffic is flowing, transactions can be externalized on some members before the others, especially if some members have less write throughput than others, creating the possibility of stale reads. If a transaction executes against a table that ... In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-adaptive-hash.html
If a table fits almost entirely in main memory, a hash index speeds up queries by enabling direct lookup of any element, turning the index value into a sort of pointer. If there are numerous threads waiting on rw-latches created in btr0sea.c, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction on ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
The keyring_file keyring plugin stores keyring data in a file local to the server host. As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. Instead, consider using the component_keyring_file component ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-parallel-data-nodes.html
If you are using large Disk Data tables, you may also need to increase DiskPageBufferMemory. To force creation of a single-threaded backup that can easily be imported by ndb_restore from an NDB release prior to 8.0, you can set ... It is possible in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-initial-start.html
Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the cluster. Important An NDB Cluster management ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-performance.html
Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-two-channels.html
Running multiple replication channels simultaneously can result in unwanted duplicate records being created on the replicas. In a more complete example scenario, we envision two replication channels to provide redundancy and thereby guard against ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-start-phases.html
These start phases are also reported in the start_phase column of the ndbinfo.nodes table. NDB Cluster connections are set up, inter-block communications are established, and heartbeats are started. For an initial start or initial node restart, the ... This section provides a simplified outline of the steps involved when NDB Cluster data nodes are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-setup.html
Start the management server with either --initial or --reload to cause it to read the updated configuration file. Perform a rolling initial start (or restart) of all the data nodes (see Section 25.6.5, “Performing a Rolling Restart of an NDB ...