Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
While its value can be increased using a rolling restart (see Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”), decreasing it in this way is not considered safe due to the possibility of a node failure occurring during the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-networking-issues.html
This network setup is safest because no packets can reach the cluster's management or data nodes from outside the network—and none of the cluster's internal communications can reach the outside—without going through the SQL nodes, as long as the ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
Pushdown joins between queries featuring very large and possibly overlapping IN() and NOT IN() lists are now handled in a correct and safe manner. What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise.html
Like MySQL Community Edition, MySQL Enterprise Edition includes MySQL Server, a fully integrated transaction-safe, ACID-compliant database with full commit, rollback, crash-recovery, and row-level locking capabilities. In addition, MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
For example, to set the size for the server to 128MB, add the following lines in an option file: [mysqld] max_allowed_packet=128M It is safe to increase the value of this variable because the extra memory is allocated only when needed. If you ... A ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching values”. By limiting the search, it is possible to expend much less time and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or replication. Statement-based replication of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
The account can also be safely used by an administrator to apply or reapply transactions from mysqlbinlog output, for example to recover from a replication error on the channel. By default, MySQL replication (including Group Replication) does not ...