Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. An NDB ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
A fragment can have any number of fixed-size pages; when the last row on a fixed-size page is deleted, the page is released to the DataMemory page pool. Since not all schemas or rows have a variable-sized part, var_elem_count can be less than ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
This can be used to redistribute NDB Cluster data among new data nodes that have been added to the cluster online. The table to be altered must have an explicit primary key; the hidden primary key created by the NDB storage engine is not sufficient ... MySQL NDB Cluster supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
--diff-default Command-Line Format --diff-default Print only configuration parameters that have non-default values. This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgmd.html
The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request it. Management clients can connect to the management server and check the cluster's status. All ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If multiple attributes are defined with the same name, attempts to retrieve the attribute value have an undefined result. Have a tee file enabled and pager set to less, and you are able to browse the results using the less program and still have ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-releases.html
Behavior: Apart from new features in innovation releases, behavior changes are also expected as code is refactored, deprecated functionality is removed, and when MySQL is modified to behave more in line with SQL Standards. Behavior changes can have ... The MySQL release model is divided into two main tracks: LTS (Long-Term Support) and ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
To kill threads belonging to other users, the connected user must have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). Slow queries The number of queries that have taken more than long_query_time seconds. You can use it to check ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
CHECK constraints cannot refer to columns that have the AUTO_INCREMENT attribute, nor can the AUTO_INCREMENT attribute be added to existing columns that are used in CHECK constraints. MySQL supports an extension for optionally specifying the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Increasing the number of background threads for read or write operations, if you have a high-end I/O subsystem that is not fully utilized by the default values. InnoDB log files have often been kept small to avoid long startup times after a crash.