Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 7 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
ERROR 4092 (HY000): Column can't be added with ALGORITHM=INSTANT as after this max possible row size crosses max permissible row size. The maximum number of columns in the internal representation of the table cannot exceed 1022 after column addition ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). --max-record-length=len Command-Line Format --max-record-length=len Type ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-event-buffer.html
Event buffer logging reports in the cluster log use the format shown here: Node node_id: Event buffer status (object_id): used=bytes_used (percent_used% of alloc) alloc=bytes_allocated (percent_alloc% of max) max=bytes_available ... NDB uses one or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. Keep in mind that using MAX_ROWS to set the number of partitions per table is deprecated, and you should use PARTITION_BALANCE instead; see ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--ai-increment=# Command-Line Format --ai-increment=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with a hidden primary key, specify the autoincrement increment, like the auto_increment_increment system variable ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. --connect-retries Command-Line Format ...Usage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-failover.html
In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication channel. This means that the ndb_apply_status table contains information for the replica on this host as well as for any ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. This enables use of EXPLAIN plus SHOW WARNINGS to see why an index is not ...