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/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. If either server does not support encrypted connections (because it ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
This means it is the same as the official ISO 8859-1 or IANA (Internet Assigned Numbers Authority) latin1, except that IANA latin1 treats the code points between 0x80 and 0x9f as “undefined,” whereas cp1252, and therefore MySQL's latin1, assign ... Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
GTID assignment distinguishes between client transactions, which are committed on the source, and replicated transactions, which are reproduced on a replica. When a client transaction is committed on the source, it is assigned a new GTID, provided ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
When an out-of-range value is assigned to an integer column, MySQL stores the value representing the corresponding endpoint of the column data type range. When a floating-point or fixed-point column is assigned a value that exceeds the range implied ...If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
The idea of UTF-8 is that various Unicode characters are encoded using byte sequences of different lengths: Basic Latin letters, digits, and punctuation signs use one byte. The Unicode Standard includes characters from the Basic Multilingual Plane ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
NO_UNSIGNED_SUBTRACTION Subtraction between integer values, where one is of type UNSIGNED, produces an unsigned result by default. When NO_UNSIGNED_SUBTRACTION is enabled, the subtraction result is signed, even if any operand is unsigned. The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-auto-increment-columns.html
For example, for a column with a bigint(20) unsigned column type, the data type is just bigint. This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values ...
https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html
This is done by setting the optimizer_trace_offset and optimizer_trace_limit system variables, like this: SET optimizer_trace_offset=offset, optimizer_trace_limit=limit; offset is a signed integer (default -1); limit is a positive integer (default ...Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement is ...
https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html
It is not a good sign if mysqld did die unexpectedly, but in this case, you should not investigate the Checking table... Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
Unquoted win_user_or_group_name and mysql_user_name values can contain anything except equal sign, comma, or space. Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise ...