PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
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/stored-routines-syntax.html
A stored routine is either a procedure or a function. Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 15.1.22, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A procedure is invoked using a ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply ...
https://dev.mysql.com/doc/refman/9.7/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-file-io.html
By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io 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/9.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-file-io.html
By default, rows are sorted by descending total file I/O latency. The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-logs-configuration.html
For information on the configured loggers, see Section 29.12.21.1, “The setup_loggers Table”. Server Configuration System Variables Server Configuration Status Variables Server Configuration Command Line Server Configuration System Variables The ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-format.html
The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/refman/9.7/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 5 User: ...