PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. To detect this condition, you can set up a handler for it (or for a NOT FOUND condition). If a ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
This is the same as CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column of the same type but having fewer fractional digits results in ... MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds ...
https://dev.mysql.com/doc/refman/5.7/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). If there is enough space, it continues as if nothing ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-geometry.html
This value identifies the geometry's associated spatial reference system that describes the coordinate space in which the geometry object is defined. This is the bounding geometry, formed by the minimum and maximum (X,Y) coordinates: ((MINX MINY, ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-single-primary-mode.html
This section explains how to create a replication group with three MySQL Server instances, each running on a different host machine. Figure 17.4 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fault-tolerance.html
This has direct impact on the number of failures the system can tolerate without compromising itself and its overall functionality. In practice this means that to tolerate one failure the group must have three servers in it. MySQL Group Replication ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fine-tuning-the-group-communication-thread.html
By configuring this wait to be a little longer (doing an active wait) before actually going to sleep can prove to be beneficial in some cases. This is because the alternative is for the operating system to switch out the GCT from the processor and ... The group communication thread (GCT) runs in a loop while the Group Replication plugin is ...
https://dev.mysql.com/doc/refman/5.7/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 ...