Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
If we know a person's zipcode value but are not sure about the last name, we can search like this: SELECT * FROM people WHERE zipcode='95054' AND lastname LIKE '%etrunia%' AND address LIKE '%Main Street%'; MySQL can use the index to scan through ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
This includes values such as database and table names, table types, and storage engines. Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM ... Applications that monitor databases ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. Because checksum mismatches cause InnoDB to deliberately ...It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
In this case, the table must be searched to ensure that the new counter value is not less than or equal to the actual current maximum counter value. This section describes the AUTO_INCREMENT lock modes, usage implications of different AUTO_INCREMENT ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-detection.html
If the LATEST DETECTED DEADLOCK section of InnoDB Monitor output includes a message stating TOO DEEP OR LONG SEARCH IN THE LOCK TABLE WAITS-FOR GRAPH, WE WILL ROLL BACK FOLLOWING TRANSACTION, this indicates that the number of transactions on the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. InnoDB performs row-level locking ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. The Transportable Tablespaces ...