PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/replication-options-binary-log.html
For more information, see Section 15.7.6.1, “SET Syntax for Variable Assignment”. When set to MINIMAL, the default, only metadata related to SIGNED flags, column character set and geometry types are logged. Setting this variable to OFF prevents ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
REAL is also treated as floating point, but UNSIGNED FLOAT and UNSIGNED DOUBLE are deprecated in MySQL, and are not supported by MLE. The same argument identifier can be used to set the value using the JavaScript assignment (=) operator. Most MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/server-system-variables.html
This means that when you assign a value to a system variable that controls a buffer size, the amount of space actually available might differ from the value assigned. In some cases, the amount might be less than the value assigned. For example, if ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/9.7/en/disk-issues.html
NFS Version 2 clients can only access the lowest 2GB of a file (signed 32 bit offset). This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. For information about ...
https://dev.mysql.com/doc/refman/9.7/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. However, it is possible for the data on the source and ...
https://dev.mysql.com/doc/refman/9.7/en/kerberos-pluggable-authentication.html
SSPI, while being compatible with GSSAPI at the wire level, only supports the Windows single sign-on scenario and specifically refers to the logged-on user. Note Kerberos pluggable authentication is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/9.7/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations on JSON values to ...
https://dev.mysql.com/doc/refman/9.7/en/identifier-mapping.html
The same is true for any use of $ (dollar sign) in a schema or table name; it is replaced with @0024 on the filesystem. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/glossary.html
The use of the term B-tree is intended as a reference to the general class of index design. B-tree structures used by MySQL storage engines may be regarded as variants due to sophistications not present in a classic B-tree design. InnoDB does not ...