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/mysql-cluster-replication-issues.html
If this occurs, it is entirely possible for new data to be inserted into the source cluster without being recorded in the source SQL node's binary log. This section discusses known problems or issues when using replication with NDB Cluster. A loss ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
If there is an authentication factor with a pending registration, a connection is placed into pending registration mode when attempting to connect to the server. mysql supports the following options, which can be specified on the command line or in ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
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/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
Pruning can also be applied to short ranges, which the optimizer can convert into equivalent lists of values. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For the Performance Schema to monitor a thread, these things must be true: The ...
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/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...