Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. A 6-byte DB_ROW_ID field contains a row ID that ...It ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. SELECT statements that insert zero or NULL values into an ...
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
When you want to add new records one at a time, the INSERT statement is useful. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT INTO pet VALUES ...Suppose that ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
You can use SELECT, DELETE, UPDATE, and INSERT on MERGE tables. You can optionally specify an INSERT_METHOD option to control how inserts into the MERGE table take place. Use a value of FIRST or LAST to cause inserts to be made in the first or last ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
When rows are inserted in sorted order (as when you are using an AUTO_INCREMENT column), the index tree is split so that the high node only contains one key. Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
Now the Performance Schema determines how to set the INSTRUMENTED and HISTORY values for new connection threads as follows: If joe connects from the local host, the connection matches the first inserted row. If joe connects from hosta.example.com, ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
However, the result of the DML INSERT statement is different depending on the binary logging format: If row-based binary logging format is in use on the source (binlog_format=ROW), the replica evaluates the INSERT operation using the database where ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
These statements are subject to rewriting: SELECT, INSERT, REPLACE, UPDATE, and DELETE. The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, ... To ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Delayed_errors This status variable is deprecated (because DELAYED inserts are not supported); expect it to be removed in a future release. Delayed_insert_threads This status variable is deprecated (because DELAYED inserts are not supported); expect ... The MySQL server maintains many status variables that provide information about its ...