PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/get-diagnostics.html
The keyword STACKED means to retrieve information from the second diagnostics area, which is available only if the current context is a condition handler. It does not apply to the second diagnostics area because GET STACKED DIAGNOSTICS is permitted ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/9.7/en/glossary.html
It performs the search twice, where the search phrase for the second search is the original search phrase concatenated with the few most highly relevant documents from the first search. change buffer A special data structure that records changes to ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/9.7/en/information-functions.html
Execute the query with LIMIT, and then a second query with COUNT(*) and without LIMIT to determine whether there are additional rows. The value of LAST_INSERT_ID() remains stable in the second statement; its value for the second and later rows is ...
https://dev.mysql.com/doc/refman/9.7/en/ldap-pluggable-authentication.html
Second, the MySQL server sends an LDAP binding request over the connection to the LDAP server and waits for a reply before authenticating the account. Table 8.21 System variables for SASL-based and simple LDAP Authentication System Variable Name ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
SLEEP(duration) Sleeps (pauses) for the number of seconds given by the duration argument, then returns 0. The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ...
https://dev.mysql.com/doc/refman/9.7/en/multifactor-authentication.html
Authentication involves one party establishing its identity to the satisfaction of a second party. The default authentication_policy value is '*,,' (an asterisk and two empty elements), which requires a first factor, and optionally permits second ...Multifactor authentication (MFA) is the use of multiple authentication values (or “factors”) during the authentication ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-mgmd.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. This is one of the following values: LEGACY: The ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. --connect-retry-delay Command-Line Format ...By default, ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
If you do replay a further dump file on the target server that contains the same GTIDs (for example, another partial dump from the same origin server), any SET @@GLOBAL.gtid_purged statement in the second dump file fails. The mysqldump client ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-hints.html
Conflicting hints: For a hint such as /*+ MRR(idx1) NO_MRR(idx1) */, MySQL uses the first hint and issues a warning about the second conflicting hint. Examples: /*+ JOIN_PREFIX(t1) JOIN_PREFIX(t2) */ The second JOIN_PREFIX hint is ignored with a ...