0

On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day:

2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading communication packets

My question is how can I know which packets are these? How can I solve this or gain more information about the problem?

2
  • i doubt that there is a simple solution ti that problem, but you can look here percona.com/blog/2016/05/16/… for a more detailed anaylysis
    – nbk
    Aug 23, 2021 at 16:16
  • In your my.cnf or my.ini in [mysqld] section, use of log_warnings=2 will provide additional details related to the cause. This is a dynamic varaible and from MySQL Command Promt, SET GLOBAL log_warnings=2; will record additional information in your error log without a stop/start of the instance. Aug 24, 2021 at 2:38

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.