Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
By default, members that find themselves in a minority due to a network partition do not automatically leave the group. Setting a timeout means you do not need to pro-actively monitor for servers that are in a minority group after a network ...You ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure.html
Members that have not failed might lose contact with part, but not all, of the replication group due to a network partition. For example, in a group of 5 servers (S1, S2, S3, S4, S5), if there is a disconnection between (S1, S2) and (S3, S4, S5) ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...| ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. For example, you may want to distribute different sales data to different departments to help spread the load during data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. The Transportable Tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
The second OVER clause partitions rows by country, producing a sum per partition (per country). As an example of one of those nonaggregate window functions, this query uses ROW_NUMBER(), which produces the row number of each row within its partition. By default, partition rows are unordered and row numbering is ...However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
For window function usage information and examples, and definitions of terms such as the OVER clause, window, partition, frame, and peer, see Section 14.20.2, “Window Function Concepts and Syntax”. PERCENT_RANK() Percentage rank value RANK() ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Support for user-defined partitioning in NDB Cluster is restricted to [LINEAR] KEY partitioning. Using any other partitioning type with ENGINE=NDB or ENGINE=NDBCLUSTER in a CREATE TABLE statement results in an error. For details, see User-defined ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
(See Section 2.3.25, “The NdbTransaction Class”.) Types The Ndb class does not define any public typesbut does define three data structures, which are listed here: EventBuffermemoryUsage Key_part_ptr PartitionSpec. See Section 1.5, ... This ...