PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
This state occurs after the table with the new structure has been created but before rows are copied into it. The following list describes thread State values that are associated with general query processing and not more specialized activities ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
The column is also indexed and the optimizer can take that index into account during execution plan construction. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
Syntactic well-formedness is also checked for attempts to store geometries into tables. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or ...
https://dev.mysql.com/doc/refman/5.7/en/gis-polygon-property-functions.html
Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid computation. Functions in this section return properties of Polygon or MultiPolygon values. Area() is deprecated; expect it to be removed ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The server reads the contents of the grant tables into memory when it starts. The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-definition-statements.html
Consequently, the lack of atomicity does not fit directly into the optimistic replication paradigm that Group Replication is based on. In a Group Replication topology, care needs to be taken when executing data definition statements also commonly ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
This - procedure assumes that MySQL Server was downloaded and unpacked - into the directory named mysql-5.7. The most common way to deploy Group Replication is using multiple server instances, to provide high availability. It is also possible to ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
Supply the old server UUID by copying the auto.cnf file preserved in step 2 above into the data directory of the restored member. MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...