PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
(This does not occur for other types such as DATETIME.) By default, the current time zone for each connection is the server's time. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, ...
https://dev.mysql.com/doc/refman/8.0/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
These functions are connection-specific, so their return values are not affected by another connection which is also performing inserts. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
Plan isn't ready yet (JSON property: none) This value occurs with EXPLAIN FOR CONNECTION when the optimizer has not finished creating the execution plan for the statement executing in the named connection. The EXPLAIN statement provides information ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
It refers to Windows Firewall and controls whether Windows blocks the TCP/IP port on which the MySQL server listens for client connections.) Important There is an issue for MySQL 8.0.19 installed using MySQL Installer that prevents the server from ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-multipolygon.html
A MultiPolygon that has more than one Polygon has an interior that is not connected. The number of connected components of the interior of a MultiPolygon is equal to the number of Polygon values in the MultiPolygon. A MultiPolygon is a MultiSurface ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
When the timeout expires, for any transactions that did not yet reach their commit phase, the client session is disconnected so that the transaction does not proceed. Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are ... This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
If you do not want the credentials transferred to new joiners and recorded there, ensure that you unset them before remote cloning operations take place, as described in Section 20.6.3, “Securing Distributed Recovery Connections”, and use START ...If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-reduce.html
Having a very low group_replication_message_cache_size setting is not recommended if the host is on an unstable network, because a smaller message cache makes it harder for group members to reconnect after a transient loss of connectivity. If a ...