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/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html
MySQL ignores the SELECT list in such a subquery, so it makes no difference. If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. For ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If a table-full error occurs, it may be that the disk is full or that the table has reached its ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Due to the computational expense, MySQL does not check explicitly for geometric validity. Spatial import functions that parse WKT or ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html
Prior to MySQL 8.0, these functions also accepted geometry objects as returned by the functions in Section 14.16.5, “MySQL-Specific Functions That Create Geometry Values”. These functions take as arguments a BLOB containing a Well-Known Binary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
In MySQL 8.0.13 and later, you can use the group_replication_switch_to_single_primary_mode() and group_replication_switch_to_multi_primary_mode() functions to move a group from one mode to another while Group Replication is still running. That must ... Group Replication operates either in single-primary mode or in multi-primary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
The available member actions are as follows: mysql_disable_super_read_only_if_primary This member action is available from MySQL 8.0.26. Example: SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", ... The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-technologies.html
Before getting into the details of MySQL Group Replication, this section introduces some background concepts and an overview of how things work. This provides some context to help understand what is required for Group Replication and what the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
You can use the system variable group_replication_unreachable_majority_timeout to set a number of seconds for a member to wait after losing contact with the majority of group members, and then exit the group. Setting a timeout means you do not need ... By default, members that find themselves in a minority due to a network partition do not automatically leave the ...