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/innodb-compression-internals.html
LZ77 compression works by finding sequences of data that are repeated within the data to be compressed. If innodb_strict_mode is ON, MySQL checks the maximum row size during CREATE TABLE or CREATE INDEX. If you create a table when innodb_strict_mode ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or reset the sequence value for an existing table, respectively. When you create an ARCHIVE table, the ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
The default setting (which is the maximum permitted sequence number for a transaction in a GTID) means that state transfer from a donor's binary log is virtually always attempted rather than cloning. Group members that are still online can ... This ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.0, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
Keep GCI = current_gci oldest restorable GCI = old_gci The local checkpoint having sequence ID lcp has been started on node node_id. LocalCheckpointStarted Checkpoint 7 INFO Node node_id: Local checkpoint lcp completed The local checkpoint having ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Are stored procedures and functions created on a replication source server replicated to a replica? A.4.24. You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
The following procedure briefly summarizes the process of setting up keyring_okv for use with Oracle Key Vault: Create the configuration directory for the keyring_okv plugin to use. Create the configuration directory that contains the Oracle Key ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
Important The caching_sha2_password authentication plugin is the default for new users created from MySQL 8.0 (for details, see Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”). When REQUIRE_ROW_FORMAT is set for a replication channel, ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...