PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
The group_replication_components_stop_timeout system variable specifies the time for which Group Replication waits for each of its modules to complete ongoing processes after this statement is issued. STOP GROUP_REPLICATION does not complete until ...This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
In MySQL 8.0.22 and later, a user variable referenced by a statement in a stored procedure has its type determined the first time the procedure is invoked, and retains this type each time the procedure is invoked thereafter. A stored routine is ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is needed, MySQL refers again to the temporary table. If materialization is not used, the optimizer sometimes rewrites ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
FROM t...) AS dt ...); Here the result from the derived table is materialized as a temporary table, so the relevant rows in t have already been selected by the time the update to t takes place. In MySQL, it can produce nondeterministic results ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the host. 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 ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/sys-user-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the user. 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.
https://dev.mysql.com/doc/refman/8.0/en/thread-information.html
row *************************** Id: 5 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. row *************************** Id: 20 User: me Host: ... To ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
Each matching row is updated once, even if it matches the conditions multiple times. The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. UPDATE is a DML ...