MySQL :: MySQL 8.4 Reference Manual

Search Results

Displaying 11 to 20 of 28 total results

https://dev.mysql.com/doc/refman/8.4/en/error-lost-connection.html

If the cause is none of those just described, you may be experiencing a problem with BLOB values that are larger than max_allowed_packet, which can cause this error with some clients. Sometime you may see an ER_NET_PACKET_TOO_LARGE error, and that ...Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs ...

14.8 String Functions and Operators

https://dev.mysql.com/doc/refman/8.4/en/string-functions.html

The file must be readable by the server and its size less than max_allowed_packet bytes. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to ...

13.3.4 The BLOB and TEXT Types

https://dev.mysql.com/doc/refman/8.4/en/blob.html

You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program. For example, both mysql and mysqldump enable you to change the client-side ... A BLOB is ...

7.1.5 Server System Variable Reference

https://dev.mysql.com/doc/refman/8.4/en/server-system-variable-reference.html

The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...

13.7 Data Type Storage Requirements

https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html

In addition, MySQL imposes a limit on the size of any JSON document stored in a JSON column such that it cannot be any larger than the value of max_allowed_packet. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type ...

7.1.4 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

7.6.6.3 Using Version Tokens

https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html

Length of values is constrained by the value of the max_allowed_packet system variable. Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario ...

22.5.6.2 X Plugin Options and System Variables

https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html

mysqlx_max_allowed_packet Command-Line Format --mysqlx-max-allowed-packet=# System Variable mysqlx_max_allowed_packet Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 67108864 Minimum Value 512 Maximum Value 1073741824 ...

6.2.2.2 Using Option Files

https://dev.mysql.com/doc/refman/8.4/en/option-files.html

Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a ...

14.19.1 Aggregate Function Descriptions

https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html

The value can be set higher, although the effective maximum length of the return value is constrained by the value of max_allowed_packet. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY ...

Displaying 11 to 20 of 28 total results