Search Results
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
This is the session time_zone value that is initialized from the server's global time_zone value when the session begins but may be changed during the session. The session time zone that is current when a CREATE EVENT or ALTER EVENT statement ... To ...
https://dev.mysql.com/doc/refman/8.4/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. For frequently executed ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column values. Omitting ON DELETE and ON UPDATE clauses (as in the current child table ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Usually there is no memory allocation at all after query initialization. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | mysql_firewall_mode | ON | ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
(Internal format is like WKB but with an initial 4 bytes to indicate the SRID.) There are functions available to convert between different data formats; see Section 14.16.6, “Geometry Format Conversion Functions”. Two standard spatial data ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
The server that starts the group does not make use of this option, since it is the initial server and as such, it is in charge of bootstrapping the group. This section explains the configuration settings required for MySQL Server instances that you ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ipv6.html
When a server joins such a mixed group, it must make the initial contact with the seed member using the protocol that the seed member advertises in the group_replication_group_seeds option, whether that is IPv4 or IPv6. Group Replication group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache.html
The length of this period is controlled by the group_replication_member_expel_timeout system variable, which determines the waiting period (up to an hour) that is allowed in addition to the initial 5-second detection period for members to return to ... The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus ...