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/start-group-replication.html
If super_read_only=ON and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. Otherwise, the server is not allowed to join a group as a secondary. A server that participates in a group in ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
Table-condition generator: If the subquery is a join of several tables, the triggered condition is checked as soon as possible. For multiple-table subqueries, execution of NULL IN (SELECT ...) is particularly slow because the join optimizer does not ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
For example, for 200 concurrent running connections, specify a table cache size of at least 200 * N, where N is the maximum number of tables per join in any of the queries which you execute. This means the table needs to be opened twice if two ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. For information about restrictions on view use, see Section 23.9, “Restrictions on Views”. The ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
Those types of information may then be joined within a bank or other card-issuing financial institution with client personal data, such as: Full client name (either person or company). Note MySQL Enterprise Data Masking and De-Identification is an ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
Joins are not directly supported; conditions involving multiple tables are pushed separately where possible. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is ...