Search Results
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
ApiFailureHandlingTimeout: Maximum time for API node failure handling before escalating. Arbitration: How arbitration should be performed to avoid split-brain issues in event of node failure. Note that string '/BACKUP' is always appended to this ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-prepare-for-migration.html
The next step in the import process is to prepare the wild cluster for migration. This requires, among other things, removing cluster processes from control by any system service management facility, and making sure all management nodes are running ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-set-trace.html
MySQL Router supports tracing of statements as they are processed by MySQL Router from client to server and the response to the client. Configuration To configure ROUTER SET trace you must add the following to your MySQL Router configuration file: ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-tagging.html
A configurable tag framework is available to allow the metadata of InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet to be marked with additional information. Tags make it possible to associate custom key-value pairs to a Cluster, ReplicaSet, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-remove.html
To remove a cluster from the InnoDB ClusterSet, use clusterSet.removeCluster() command. A force option is available if the cluster cannot be contacted at all. clusterSet.removeCluster() has the following syntax: ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-binlogs.html
This utility dumps binary logs generated since a specific point in time to the given local or remote directory. The starting point can be automatically determined from a previous dump, either by reusing the same output directory or by using the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/rescan-cluster.html
If you make configuration changes to a cluster outside of the AdminAPI commands, for example by changing an instance's configuration manually to resolve configuration issues or after the loss of an instance, you need to update the InnoDB Cluster ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data sorted by primary key. Use a second session to monitor bulk load progress: If the data is sorted, there is a single stage: ...