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/added-deprecated-removed.html
group_replication_allow_local_disjoint_gtids_join: Allow current server to join group even if it has transactions not present in group. group_replication_allow_local_lower_version_join: Allow current server to join group even if it has lower plugin ... Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
MySQL uses the stored key distribution to decide the table join order for joins on something other than a constant. If a join is not optimized in the right way, try running ANALYZE TABLE. ANALYZE TABLE performs a key distribution analysis and stores ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Support for LEFT OUTER JOIN and RIGHT OUTER JOIN with both standard SQL and ODBC syntax. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
To rejoin the replication group, the restored member must have the same server_uuid it used to join the group before. Rebuild the Failed Member to Rejoin as a New Member Sometimes, the steps outlined above in Restoring a Failed Member cannot be ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Once the donor is selected, the server joining the group establishes an asynchronous replication connection. However, a user that requires an SSL connection must have been created before the server joining the group connects to the donor. Typically, ... Group communication connections as well as recovery connections, are secured using ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
For performance reasons, and to minimize the chance of misleading joins between the transaction and locking tables, InnoDB collects the required transaction and locking information into an intermediate buffer whenever a SELECT on any of the tables ... The data exposed by the transaction and locking tables (INNODB_TRX, INNODB_LOCKS, and INNODB_LOCK_WAITS) represents a glimpse into fast-changing ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
MRR enables batch processing of requests for key access for operations that require access to data rows through index tuples, such as range index scans and equi-joins that use an index for the join attribute. The following scenarios illustrate when ... Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
HostName1: Name or IP address of first of two computers joined by TCP connection. HostName2: Name or IP address of second of two computers joined by TCP connection. HostName1: Name or IP address of first of two computers joined by SHM connection.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 5.7. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-operator-functions.html
These arguments are byte string values produced by the ST_Buffer_Strategy() function, to be used for point, join, and end strategies: Point strategies apply to Point and MultiPoint geometries. If no join strategy is specified, the default is ...