PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-argument-handling.html
This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. Spatial values, or geometries, have the properties described in Section 11.4.2.2, “Geometry Class”. Specific ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
(See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have no effect in a given user session on the server's statement counts such as Com_select and ...Some ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ON, produce ... Creates a report of the current server status for diagnostic ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
Configuration Options format_statement() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): statement_truncate_len, ... Given a string ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reset-to-default.html
row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND USER = '%' AND ROLE = '%') *************************** 1. Parameters in_verbose BOOLEAN: Whether to display ...