PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-max-allowed-packet.html
Row-based replication sends all columns and column values for updated rows from the source to the replica, including values of columns that were not actually changed by the update. max_allowed_packet sets an upper limit on the size of any single ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
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 need multibyte character support, it is simple. For example, greek and swe7 ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...Replicas are configured to read the binary log from the source and to execute the events in the binary log on the replica's local ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. This is ...For a supplementary character, utf16 has a special sequence for representing the character using 32 ...
https://dev.mysql.com/doc/refman/8.0/en/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. For information about character set and collation names, see Chapter 12, Character Sets, Collations, Unicode. To see the available character sets and collations, use the ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
When an operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY clause. Omitting ON DELETE and ON ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. What types of operations modify secondary indexes and result in change buffering? A.16.2. What is ...How much space does InnoDB use for the change buffer? ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
Warning Only set innodb_force_recovery to a value greater than 0 in an emergency situation, so that you can start InnoDB and dump your tables. When forcing InnoDB recovery, you should always start with innodb_force_recovery=1 and only increase the ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
Therefore this information should be used for testing purposes and it should not be used in a production environments. This means that three data directories are needed, one per server instance, and that you need to configure each instance ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. The COLUMN_TYPE value contains the type name and possibly other information such as the precision or length. The COLUMN_TYPE value ...