Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
They also work with multi-table DELETE statements, but not with single-table DELETE, as shown later in this section. These index-level optimizer hints are supported with both single-table and multi-table DELETE statements. row ... Index hints give ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
Deleted rows are put in a linked list and are reused when you insert new data into the table. MEMORY tables also have none of the problems commonly associated with deletes plus inserts in hashed tables. If a MEMORY table hash index has a high degree ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
DELETE: Logged as a DELETE_ROW event with all columns logged in the before image; the after image is not logged. DELETE: Logged as a DELETE_ROW event with primary key columns incuded in the before image; the after image is not logged. DELETE: Logged ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. To use REPLACE, you must have both the INSERT and ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
This statement is meant to be used for a clean start; it clears the replication metadata repositories, deletes all the relay log files, and starts a new relay log file. Note All relay log files are deleted, even if they have not been completely ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/internals/en/layout-record-storage-frame.html
MI_MIN_BLOCK_LENGTH 20 /* 20 bytes are required for the biggest frame type: Deleted block. In deleted blocks next_filepos and prev_filepos make a doubly linked list over all deleted blocks. In non-deleted blocks next_filepos points to the next part ...*/ MI_MAX_BLOCK_LENGTH 16777212 /* 16MB - 4, max 3 bytes for length available, 4-byte ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
To start with, use one of updateTuple(), writeTuple(), or deleteTuple() to define the operation as an operation of a given type (update, write, or delete). NdbOperation::deleteTuple() Description This method defines the NdbOperation as a DELETE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
The following sections in this topic describe how to update a vector store: Before You Begin Load Data Incrementally into the Vector Store Table Delete and Recreate the Vector Store What's Next Before You Begin Complete the steps to set up a vector ... To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular ...