PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-choosing-id.html
To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
This means that each Disk Data object must be uniquely named (and not merely each Disk Data object of a given type). ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
Histograms cannot be generated for columns that are covered by single-column unique indexes. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The AUTO_INCREMENT column can have either a unique or nonunique index. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The operation is either committed, with applicable changes persisted to ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
For example, InnoDB tables can each be in a separate file, or share file storage with other InnoDB tables; each MyISAM table corresponds uniquely to a set of files. This section describes the characteristics of different types of backups. Physical ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
For servers that are used in a replication topology, you must specify a unique nonzero server ID for each server. The session values of the following system variables are written to the binary log and honored by the replica when parsing the binary ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting values into the column that differ only in number of trailing pad bytes results in a duplicate-key ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
The source and each replica must be configured with a unique ID (using the server_id system variable). This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the ...