Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
(NDB 8.4.0) For queries that are translated into full table scans or range scans on indexes, it is important for best performance to fetch records in properly sized batches. Time elapsed during node connection attempts is not taken into account when ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/8.4/en/nested-join-optimization.html
The result row is passed to the final check for the output or into the next nested loop, but only if the row satisfies the join condition of all embedded outer joins. The following discussion refers to the join syntax described in Section 15.2.13.2, ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
This section describes an authentication issue that protocol implementors should take into account. If the plugin is built into libmysqlclient, it is available by default. This enables the connector to support connections though accounts that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A range of GTIDs originating from the same server can be collapsed into a single expression, as shown here: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 The above example represents the first through fifth transactions originating on the MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
This method can also be used if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new source, the data is ...Before ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. partition_clause: A PARTITION BY ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
All InnoDB data modified after the LSN (specified directly or indirectly by the options you use) is copied into the incremental backup. By default, all non-InnoDB files are included into the incremental backup and in their fullness. Note No binary ... For an overview of incremental backups and usage examples for these options, see Section 4.3.3, “Making a Differential or Incremental Backup” and Section 5.1.3, “Restoring an Incremental ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
The backup repository options are divided into two groups: the first one determines the structure of the backup, and the second one provides information on the original structure of the data on the backed-up server for future operations on the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
MySQL Enterprise Backup does not include the .pem files from the server into the backup. To avoid the problem, the server administrator should not put into the same directory the system tablespace and a general tablespace of the same basename; if ...