PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-basics.html
There are as many data nodes as there are fragment replicas, times the number of fragments (see Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”). NDBCLUSTER (also known as NDB) is an in-memory storage engine ...NDB Cluster's NDB storage engine contains a complete set of data, dependent only on other data within the cluster ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior of such tables, and could easily lead to corruption or loss of data. Reads from such tables are relatively unaffected; ... This section discusses current restrictions and limitations on MySQL partitioning ...The following constructs are not permitted in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
--config-cache Command-Line Format --config-cache[=TRUE|FALSE] Type Boolean Default Value TRUE This option, whose default value is 1 (or TRUE, or ON), can be used to disable the management server's configuration cache, so that it reads its ... The ...All options that can be used with ndb_mgmd are shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Also, the ...Benefits of BKA include improved join performance due to more efficient table ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
Seconds_Behind_Source This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
Restore backup of s2 onto the host for s3: s3> mysqlbackup --defaults-file=/etc/my.cnf \ --datadir=/var/lib/mysql \ --backup-image=/backups/my.mbi_2206_1429 \ --backup-dir=/tmp/restore_`date +%d%m_%H%M` copy-back-and-apply-log Note The command above ...This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is not needed for account management statements such as GRANT or REVOKE, which take effect ...Note ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. It can hold multiple tables, and supports all table row formats. One data file is created and added to the tablespace using this statement. This means that each Disk Data object ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. For queries that execute and thus recurse slowly or ...Common Table Expressions Recursive Common Table Expressions Limiting Common Table Expression Recursion Recursive Common Table Expression Examples Common Table Expressions Compared to Similar Constructs For information about CTE optimization, see Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or ...