PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Note If you are replicating tables with very large columns (such as TEXT or BLOB columns), --ndb-log-updated-only can also be useful for reducing the size of the binary logs and avoiding possible replication failures due to exceeding ...Conflict ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
This enables users to set sort_buffer_size to larger values to speed up larger sorts, without concern for excessive memory use for small sorts. (This benefit may not occur for multiple concurrent sorts on Windows, which has a weak multithreaded ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
performance_schema_accounts_size Command-Line Format --performance-schema-accounts-size=# System Variable performance_schema_accounts_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value -1 (signifies autoscaling; do not ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic No SET_VAR Hint Applies ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
IndexStatTriggerScale: Scale down IndexStatTriggerPct by this amount, multiplied by base 2 logarithm of index size, for large index. BackupMaxWriteSize: Maximum size of file system writes made by backup (in bytes). BackupWriteSize: Default size of ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. group_replication_communication_max_message_size: Maximum message size for Group Replication communications, larger messages ...Innodb_redo_log_capacity_resized: Redo log capacity after the last completed capacity resize ... Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Limits on Transaction Size If an individual transaction results in message contents which are large enough that the message cannot be copied between group members over the network within a 5-second window, members can be suspected of having failed, ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
Because --ndb-log-empty-epochs=1 causes the size of the ndb_binlog_index table to increase independently of the size of the binary log, users should be prepared to manage the growth of this table, even if they expect the cluster to be idle a large ...This is generally not recommended, although it may be useful to disable transaction support within a given client session when that session is used to import one or more dump files with large transactions; this allows a multi-row insert to be executed in parts, rather than as a single ...--ndb-blob-read-batch-bytes=bytes Command-Line Format ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ...This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Beginning with NDB 8.0.30, a column comment can also be used to control the inline size of a blob ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
For example: [mysqld] innodb_data_home_dir= innodb_data_file_path=/dev/hdd1:3Graw;/dev/hdd2:2Graw The partition must be at least as large as the size that you specify. The size and number of system tablespace data files is defined by the ... The ...