'localhost' (Got an error reading communication packets)

Ghani8856

• May 29, 2020 07:23

A very strange problem "139640672130816 [Warning] Aborted connection 4975 to db: 'infingers_wp377' user: 'infingers_wp377' host: 'localhost' (Got an error reading communication packets)" facing on our eCommerce websites. We are running corn each minute to fetch products.

• 

  Ghani8856

  • May 29, 2020 12:29

  my.cnf configuration [client-server] !includedir /etc/my.cnf.d [mysqld] log-error = /var/lib/mysql/vmi357337.hostname.net.err performance-schema = ON innodb_buffer_pool_size = 2G max_allowed_packet = 256M open_files_limit = 10000 innodb_file_per_table = 1 query_cache_type = 0 query_cache_limit = 1M query_cache_min_res_unit = 2k query_cache_size = 0 tmp_table_size = 64M max_heap_table_size = 64M max_connections = 200 wait_timeout = 7200 interactive_timeout = 7200 join_buffer_size = 1M tmp_table_size = 128M max_heap_table_size = 128M table_open_cache = 8000 table_definition_cache = 14760 innodb_log_file_size = 256M innodb_buffer_pool_instances = 2 bind-address=127.0.0.1 slow_query_log_file=/var/lib/mysql/slow.log
  

  0
• 

  cPanelLauren

  • May 30, 2020 21:07

  Is anything of note added to the MySQL error logs? Also some quick reading on the error showed this: MySQL Error Reading Communication Packets

  0

Please sign in to leave a comment.