MySQL Got an error reading communication packets

 Possible reasons for the "Got an error reading communication packets" messages:

Deploying a new application or making changes to an existing application.
Reducing the value one of the following timeout options: interactive_timeout, net_read_timeout, net_write_timeout, wait_timeout.
Increasing the error log verbosity:
To log_error_verbosity = 3 in MySQL 5.7 and later.
To log_warnings = 2 in MySQL 5.6 and earlier.
Upgrading to MySQL Server 5.7.

log_error_verbosity

Property Value
Command-Line Format --log-error-verbosity=#
System Variable log_error_verbosity
Scope Global
Dynamic Yes
SET_VAR Hint Applies No
Type Integer
Default Value (>= 8.0.4) 2
Default Value (<= 8.0.3) 3
Minimum Value 1
Maximum Value 3



$ mysql --login-path=root -e "show variables like '%log_error_verbosity%';"
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| log_error_verbosity | 3 |
+---------------------+-------+
mysql> set global log_error_verbosity=2;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'log_error_verbosity';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| log_error_verbosity | 2 |
+---------------------+-------+
1 row in set (0.00 sec)

Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows