Search Results
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
STRICT_TRANS_TABLES If a value could not be inserted as given into a transactional table, abort the statement. For a nontransactional table, abort the statement if the value occurs in a single-row statement or the first row of a multiple-row ... The ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Index Condition Pushdown Flags index_condition_pushdown (default on) Controls index condition pushdown. Index Extensions Flags use_index_extensions (default on) Controls use of index extensions. Index Merge Flags index_merge (default on) Controls ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
“Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or ... 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/partitioning-limitations.html
As with nonpartitioned tables, proper use of indexes can speed up queries on partitioned tables significantly. More specifically, this means that the following two statements are true: No definition of an InnoDB table employing user-defined ... This ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.16.2. What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. If an ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Statements acquire metadata locks one by one, not simultaneously, and perform deadlock detection in the process. DML statements normally acquire locks in the order in which tables are mentioned in the statement. DDL statements, LOCK TABLES, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. Transaction Boundaries In MySQL Server, transactions start explicitly with these statements: START ...These ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
This is what I'd call a "distinguishing characteristic" because in all the major DBMSs (like IBM DB2, Microsoft SQL Server, and Oracle), the main or default or classic structure is the heap-and-index. To put it another way: InnoDB keeps the rows in ... The InnoDB source files are the best place to look for information about internals of the file structure that MySQLers can optionally use for transaction ...