MySQL :: MySQL 8.4 Reference Manual

Search Results

Displaying 21 to 28 of 28 total results

« Previous
1
2
3
Next »

6.5.4 mysqldump — A Database Backup Program

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

Note The value of this option is specific to mysqldump and should not be confused with the MySQL server's max_allowed_packet system variable; the server value cannot be exceeded by a single packet from mysqldump, regardless of any setting for the ...

13.5 The JSON Data Type

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

It is important to keep in mind that the size of any JSON document stored in a JSON column is limited to the value of the max_allowed_packet system variable. The JSON data type provides these advantages over storing JSON-format strings in a string ...

B.3.2.7 MySQL server has gone away

https://dev.mysql.com/doc/refman/8.4/en/gone-away.html

If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 64MB. This section also covers the related Lost ...

7.1.9.2 Dynamic System Variables

https://dev.mysql.com/doc/refman/8.4/en/dynamic-system-variables.html

Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...

B.3.4.6 Deleting Rows from Related Tables

https://dev.mysql.com/doc/refman/8.4/en/deleting-from-related-tables.html

If the total length of the DELETE statement for related_table is more than the default value of the max_allowed_packet system variable, you should split it into smaller parts and execute multiple DELETE statements. You probably get the fastest ...

14.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html

The number of values in the IN() list is only limited by the max_allowed_packet value. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less ...

B.3.2.9 Communication Errors and Aborted Connections

https://dev.mysql.com/doc/refman/8.4/en/communication-errors.html

Other reasons for problems with aborted connections or aborted clients: The max_allowed_packet variable value is too small or queries require more memory than you have allocated for mysqld. If connection problems occur such as communication errors ...

7.4.4.5 Binary Log Transaction Compression

https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html

When binary log transaction compression is enabled, the max_allowed_packet and replica_max_allowed_packet limits for the server still apply, and are measured on the compressed size of the Transaction_payload_event, plus the bytes used for the event ... MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a ...