PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
utf8mb4_turkish_ci and utf8mb4_hungarian_ci are similar but based on a less recent version of the Unicode Collation Algorithm. Collation names for Unicode character sets may include a version number to indicate the version of the Unicode Collation ... MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
These protocol versions are old, released in 1996 and 2006, respectively, and the algorithms used are weak and outdated. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...
https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html
For example, if FIPS mode is enabled, stronger cryptographic algorithms are required. MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. FIPS mode on the server side applies to ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
Relevancy Rankings for InnoDB Boolean Mode Search InnoDB full-text search is modeled on the Sphinx full-text search engine, and the algorithms used are based on BM25 and TF-IDF ranking algorithms. MySQL can perform boolean full-text searches using ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. NAME The name of the table, preceded by ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
TRX_SCHEDULE_WEIGHT The transaction schedule weight assigned by the Contention-Aware Transaction Scheduling (CATS) algorithm to transactions waiting for a lock. The TRX_SCHEDULE_WEIGHT value is different from the TRX_WEIGHT value, which is computed ... The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the techniques from Section 17.17, “InnoDB Monitors”, setting up InnoDB monitors ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage engine. A LOCK clause specifies a low ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-read_ahead.html
InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a technique that predicts what pages might be needed soon based on pages in the buffer pool being accessed sequentially. The SHOW ENGINE INNODB STATUS command ...