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/audit-log-reference.html
To check the status of the component: SHOW VARIABLES LIKE 'component_scheduler%'; +-----------------------------+-------+ | Variable_name | Value | +-----------------------------+-------| | component_scheduler.enabled | On | ...Unless those objects ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable is disabled. If ...option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds ...This ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/information-functions.html
As a replacement, considering executing your 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The maximum expire time is defined as INT_MAX32 or 2147483647 seconds (approximately 68 years). Using the primary key avoids a lookup that is performed when using a secondary index. You cannot make a covering index for memcached lookups; InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The second instance of $[1].b[1] matches nothing: That element has already been removed, the path no longer exists, and has no effect. If the two values have the same JSON type, a second level of comparison occurs using type-specific rules. The JSON ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...