Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
All --include-* and --exclude-* options are evaluated in the order passed to ndb_restore, from right to left. --rebuild-indexes Command-Line Format --rebuild-indexes Enable multithreaded rebuilding of the ordered indexes while restoring a native NDB ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
The elements in the partitioning column list and in the value list defining each partition must occur in the same order. However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the source. This occurs because the order in which the rows are numbered depends on the specific storage engine used for ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
With ORDER BY, the server issues a first-key request followed by several next-key requests, whereas with ORDER BY DESC, the server issues a last-key request followed by several previous-key requests. Handler_read_next The number of requests to read ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
If all columns in ORDER BY and GROUP BY clauses come from the same table, that table is preferred first when joining. If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
If the recursive part has multiple query blocks, iterations of each query block are scheduled in unspecified order, and each query block operates on rows that have been produced either by its previous iteration or by other query blocks since that ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
InnoDB: Dropping a primary key, and then adding a new AUTO_INCREMENT column as a primary key in descending order using the INPLACE algorithm failed. (Bug #84358, Bug #25330090) Group Replication: Removed a potential race condition between the ...
https://dev.mysql.com/doc/internals/en/implementing-index-read-last-method.html
The [custom-engine.html#custom-engine-api-reference-index_read_last index_read_last()] method works like [custom-engine.html#custom-engine-index-read index_read()] but finds the last row with the current key value or prefix: int ...
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-preparation.html
Therefore, in order to call the parser and allocate memory in the statement memory root we perform several save-restore steps with THD::mem_root and THD::free_list (the active arena of THD). In order to parse a statement, we save the currently ...
https://dev.mysql.com/doc/internals/en/select-union.html
Call mysql_select on temporary table with global ORDER BY and LIMIT parameters after collecting results from all SELECTs. A special fake_select_lex (SELECT_LEX) which is created for every UNION will be passed for this procedure (this SELECT_LEX also ...We will need this object to store in every JOIN structure link on it, but we have not (yet) temporary table ...