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/replication-rules-channel-based-filters.html
Before MySQL 8.0, all replication filters were global, so filters were applied to all replication channels. From MySQL 8.0, replication filters can be global or channel specific, enabling you to configure multi-source replicas with replication ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html
As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-restrictions.html
MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. It is possible to use MySQL Enterprise Audit with MySQL NDB Cluster, subject to the following conditions: All changes to be logged must be done using ...Changes made by no-SQL APIs, such as memcached, Node.JS, and the NDB API, are not ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to replica. You can cause MySQL to use mixed logging explicitly by ...You can cause this format to be used by starting the server with ...
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 ...The information in the binary log is stored in different logging formats according to the database changes being ...
https://dev.mysql.com/doc/refman/8.0/en/channels-commands-single-channel.html
The requester must wait while the transaction is completed and the rotation takes place. This behavior prevents transactions from being split, which is not permitted for Group Replication.
https://dev.mysql.com/doc/refman/8.0/en/char.html
MySQL collations have a pad attribute of PAD SPACE, other than Unicode collations based on UCA 9.0.0 and higher, which have a pad attribute of NO PAD. Note For more information about MySQL character sets and collations, see Chapter 12, Character ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
If you use a binary column to store information in multiple character sets, MySQL has no way to know which values use which character set and cannot convert the data properly. A special case occurs if you have old tables from before MySQL 4.1 where ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. These problems stem from the following factors: MySQL automatically converts ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
For example, bit operations permit numeric or binary string arguments in MySQL 8.0 and higher, but treat hexadecimal and bit literals as numbers by default. MySQL determines the character set and collation of a character string literal, hexadecimal ... A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE collation_name] The _charset_name expression is formally called an ...