PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/change-master-to.html
If you want to use the function, this replication channel must also be set up on all the secondary servers in the replication group, and on any new joining members. ] CHANGE MASTER TO changes the parameters that the replica server uses for ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
If you want to use the function, this replication channel must also be set up on all the secondary servers in the replication group, and on any new joining members. ] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
The group_replication_recovery_compression_algorithms and group_replication_recovery_zstd_compression_level system variables configure permitted compression algorithms and zstd compression level for Group Replication recovery connections when a new ... Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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 27.9, “Restrictions on Views”. The ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/execution-plan-information.html
A query on a huge table can be performed without reading all the rows; a join involving several tables can be performed without comparing every combination of rows. Depending on the details of your tables, columns, indexes, and the conditions in ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
See Section 10.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations”. The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW ...