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/server-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. Handler_external_lock The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
It can be an SQLSTATE value (a 5-character string literal) or a condition_name that refers to a named condition previously defined with DECLARE ... Valid simple_value_specification designators can be specified using stored procedure or function ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
For information about time zone settings in replication setups, see Section 16.4.1.15, “Replication and System Functions” and Section 16.4.1.31, “Replication and Time Zones”. Note If set to SYSTEM, every MySQL function call that requires a ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
However, certain nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered unsafe, later in this section). In addition, statements using results from floating-point math functions—which are ... The ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. For descriptions of functions that operate on temporal values, see Section 12.7, “Date and Time Functions”. However, with dates such as these, ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
In addition, query strings that are identical may be treated as different for other reasons. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
The following is an example of a function that takes a parameter, performs an operation using an SQL function, and returns the result. Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
When validate_password_check_user_name is enabled, it has these effects: Checking occurs in all contexts for which validate_password is invoked, which includes use of statements such as ALTER USER or SET PASSWORD to change the current user's ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
To remove it, execute the following statements: DROP TABLE IF EXISTS mysql.audit_log_user; DROP TABLE IF EXISTS mysql.audit_log_filter; UNINSTALL PLUGIN audit_log; DROP FUNCTION audit_log_filter_set_filter; DROP FUNCTION ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
To set or get an encryption password at runtime, use these audit log functions: To set the current encryption password, invoke audit_log_encryption_password_set(). For additional information about audit log encryption functions, see Audit Log ...