PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-checking.html
In that case, the trace will be shown as empty and the INSUFFICIENT_PRIVILEGES column will show "1". In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of ...
https://dev.mysql.com/doc/refman/8.0/en/query-attribute-components.html
Purpose: Implements the mysql_query_attribute_string() function that takes an attribute name argument and returns the attribute value as a string, or NULL if the attribute does not exist. As of MySQL 8.0.23, a component service provides access to ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for ... These thread states occur on a replica server but are associated with connection threads, not with the I/O or SQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration.html
This section describes how to check the status of replication, how to pause a replica, and how to skip a failed transaction on a replica. Once replication has been started it executes without requiring much regular administration. Tip To deploy ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-json.html
If a replication source has this variable set, partial updates received from that source are handled and applied by a replica regardless of the replica's own setting for the variable. Before MySQL 8.0, an update to a JSON column was always written ...The logging behavior depends on the format used, as described here: Statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online.html
This section describes how to change the mode of replication from and to GTID mode without having to take the server offline.
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-stop-replica.html
The STOP REPLICA statement can be used to stop a multi-source replica. By default, if you use the STOP REPLICA statement on a multi-source replica all channels are stopped. Optionally, use the FOR CHANNEL channel clause to stop only a specific ...
https://dev.mysql.com/doc/refman/8.0/en/reserved-accounts.html
This account has all privileges, is a system account, and can perform any operation. One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory ...
https://dev.mysql.com/doc/refman/8.0/en/return.html
RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a stored function. There may be more than one if the function has multiple ...