PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/populating-spatial-columns.html
In a C program, you can escape a binary value using mysql_real_escape_string_quote() and include the result in a query string that is sent to the server. After you have created spatial columns, you can populate them with spatial data. Values should ...
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 ...