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-parameters.html
innodb_checksum_algorithm Command-Line Format --innodb-checksum-algorithm=value System Variable innodb_checksum_algorithm Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value crc32 Valid Values ... InnoDB Startup Options ...
https://dev.mysql.com/doc/refman/8.0/en/charset-errors.html
Parameters in the message template are replaced with values that apply to a specific error occurrence: Identifiers such as table or column names use UTF-8 internally so they are copied as is. Character Set for Error Message Construction Character ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
Windows MSI package installers create and set up the data directory that the installed server uses, but also create a pristine “template” data directory named data under the installation directory. After an installation has been performed using ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
adaptive flushing An algorithm for InnoDB tables that smooths out the I/O overhead introduced by checkpoints. The adaptive flushing algorithm extends this process by estimating the optimal rate to perform these periodic flushes, based on the rate of ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--compress-output=algorithm Command-Line Format --compress-output=algorithm Type Enumeration Valid Values LZ4ZLIB By default, mysqlpump does not compress output. --compression-algorithms=value Command-Line Format --compression-algorithms=value ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
The algorithm used to carry out this process uses one of the table's indexes to carry out the search as the first choice, and a hash table if there are no suitable indexes. The algorithm first assesses the available indexes in the table definition ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that a failover is required, and a backup taken from the replica cannot be used to restore ...] CHANGE MASTER TO changes the parameters that the replica server uses for connecting to the source and for reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that a failover is required, and a backup taken from the replica cannot be used to restore ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
IGNORE | REPLACE The IGNORE and REPLACE options indicate how to handle rows that duplicate unique key values when copying a table using a SELECT statement. Keep in mind that a table comment used with ALTER TABLE replaces any existing comment which ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
Note ALGORITHM=INSTANT support is available for ADD COLUMN and other operations in MySQL 8.0.12. You can control aspects of a DDL operation using the ALGORITHM and LOCK clauses of the ALTER TABLE statement. For example: ALTER TABLE tbl_name ADD ...