PDF (US Ltr)
- 40.2Mb
PDF (A4)
- 40.3Mb
Man Pages (TGZ)
- 262.1Kb
Man Pages (Zip)
- 367.7Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/program-variables.html
For example, mysql has a max_allowed_packet variable that controls the maximum size of its communication buffer. To set the max_allowed_packet variable for mysql to a value of 16MB, use either of the following commands: mysql ... Many MySQL programs ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The packet message buffer is initialized to net_buffer_length bytes, but can grow up to max_allowed_packet bytes when needed. When you change the message buffer size by changing the value of the max_allowed_packet variable, you should also change ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. Both the client and the server have their own max_allowed_packet variable, so if ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
The minimum required max_allowed_packet value is therefore 2MB on the donor and the recipient MySQL server instances. Use the following query to check your max_allowed_packet setting: mysql> SHOW VARIABLES LIKE 'max_allowed_packet'; The following ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
replica_max_allowed_packet: Maximum size, in bytes, of packet that can be sent from replication source server to replica; overrides max_allowed_packet. slave_max_allowed_packet: Maximum size, in bytes, of packet that can be sent from replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
replica_max_allowed_packet Command-Line Format --replica-max-allowed-packet=# System Variable replica_max_allowed_packet Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1073741824 Minimum Value 1024 Maximum Value ... This ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
The following list indicates these and which system variables control their size: A stack (thread_stack) A connection buffer (net_buffer_length) A result buffer (net_buffer_length) The connection buffer and result buffer each begin with a size equal ... MySQL allocates buffers and caches to improve performance of database ...