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/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.0 is installed? The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
The LZ4 maximum input size is therefore a practical limit for message compression, and transactions above this size cannot be committed when message compression is enabled. Compression for these messages, which are sent from a donor already in the ... For messages sent between online group members, Group Replication enables message compression by ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”. Use the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction rollback when a deadlock occurs. When deadlock detection is enabled (the default), InnoDB automatically detects ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
Tables stored in individual tablespace data files can save time and improve chances for a successful recovery when data corruption occurs, when backups or binary logs are unavailable, or when the MySQL server instance cannot be restarted. A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several changes to the same table at once, since those changes could all be done with a single rebuild operation for the table. The downside ... Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
When blocks need to be replaced, blocks at the beginning of the list are the least recently used and become the first candidates for eviction. Then it discusses features that improve key cache performance and that enable you to better control cache ... To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
In this case, when the server opens a MyISAM table, it checks whether the table is marked as crashed or whether the open count variable for the table is not 0 and you are running the server with external locking disabled. If the server finds an ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. --safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...