PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
You must therefore upgrade all of the replicas in a replication topology to the target MySQL Server release, before you upgrade the source server to the target release. If you need to downgrade the servers in a replication topology, the source must ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/refman/8.0/en/xa.html
Support for XA transactions is available for the InnoDB storage engine. MySQL client programs must be able to send SQL statements and to understand the semantics of the XA statement interface. A global transaction involves several actions that are ...The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA ...In essence, this extends ACID properties “up a level” so that ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
This setting has no effect on tables created using any other storage engine than InnoDB. (You are not required to name the column or key my_row_id in such cases.) my_row_id is an invisible column, which means it is not shown in the output of SELECT ... Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary ...When ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
This file is located in the directory named by the character_sets_dir system variable. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; ... To add ...Choose a collation ID, as shown in Section 12.14.2, “Choosing a Collation ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-security.html
Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? Yes, the binaries have SSL enabled for client/server ...Where can I find documentation that addresses security issues for MySQL? The best place to start is Chapter 8, ...
https://dev.mysql.com/doc/refman/8.0/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. The number of columns retrieved by the SELECT statement must match the number of output ...If a ...To detect this condition, you can set up a handler for it (or for a NOT FOUND ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-membership.html
Group members must agree not only on transaction commits, but also on which is the current view. In this situation, the rejoining member forgets its previous state, but if other members send it messages that are intended for its pre-crash state, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
Without an index, MySQL must begin with the first document and then read through the entire collection to find the relevant fields. Each field definition must include the full document path to the field, and specify the type of the field. Further ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
Without an index, MySQL must begin with the first document and then read through the entire collection to find the relevant fields. Each field definition must include the full document path to the field, and specify the type of the field. Further ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
Block Nested-Loop Join Algorithm A Block Nested-Loop (BNL) join algorithm uses buffering of rows read in outer loops to reduce the number of times that tables in inner loops must be read. This reduces by an order of magnitude the number of times the ...Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing each row to a nested loop that processes the next table in the ...