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/replication-features-max-allowed-packet.html
max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including replicas. If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is ...Row-based replication sends all columns and column values for updated rows from the source to the replica, including values of columns that were not actually changed by the ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
Example: Suppose that the block size for a given variable is given as 4096, and you set the value of the variable to 100000 (we assume that the variable's maximum value is greater than this number). In some cases, the stated maximum for a variable ... The MySQL server maintains many system variables that affect its ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
For example, you might change the port that memcached listens on, reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log. InnoDB Startup Options ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), and NDB$MAX_DELETE_WIN(); additionally, in NDB 8.0.30 and later, NDB$MAX_INS() and NDB$MAX_DEL_WIN_INS()) implement this user-defined column as a “timestamp” ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html
ndb_config can also provide an offline dump of all configuration parameters which can be used, along with their default, maximum, and minimum values and other information. --config_from_node=# Command-Line Format --config-from-node=# Type Numeric ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
--master-retry-count=count Command-Line Format --master-retry-count=# Deprecated Yes Type Integer Default Value 86400 Minimum Value 0 Maximum Value (64-bit platforms) 18446744073709551615 Maximum Value (32-bit platforms) 4294967295 The number of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If an event cannot be split, the maximum size can be exceeded. --max-binlog-dump-events=N Command-Line Format --max-binlog-dump-events=# Type Integer Default Value 0 This option is used internally by the MySQL test suite for replication testing and ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Max datafile length How long the table data file can become, in bytes. Max keyfile length How long the table index file can become, in bytes. When a table has just been reorganized with myisamchk, the values are very high (very near theoretical ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...