PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. This condition does not apply if the WITHOUT VALIDATION ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.21.3, “Expression Handling”, and Section 12.21.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
Running ALTER TABLE tbl_name ENGINE=INNODB on an existing InnoDB table performs a “null” ALTER TABLE operation, which can be used to defragment an InnoDB table, as described in Section 14.12.4, “Defragmenting a Table”. The outcome of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
An SQL NULL value reserves one or two bytes in the record directory. An SQL NULL value reserves zero bytes in the data part of the record if stored in a variable-length column. Reserving fixed space for NULL values permits columns to be updated in ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
(To associate an LDAP user DN with a MySQL account, include a BY clause that specifies an authentication string in the CREATE USER statement that creates the account.) If the MySQL account names no LDAP user DN, LDAP authentication uses the user ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed System Variable gtid_executed Scope Global Dynamic No Type String Unit set of GTIDs When used with global scope, this variable contains a representation of the set of all transactions executed on the server and GTIDs that have been set ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... RESET ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
If you set a TLS version parameter to the empty string, encrypted connections cannot be established: tls_version: The server does not permit encrypted incoming connections. MySQL supports multiple TLS protocols and ciphers, and enables configuring ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time ...