Search Results
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. In the following array, this is the element in the fourth row down, third value from the end. Warning User-defined collations are ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
MySQL supports an additional, alternative syntax for this modifier, as shown in Section 15.2.13, “SELECT Statement”. In this case, each time there is a change in value in any but the last grouping column, the query produces an extra ... The ...
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 ...