'localhost' (Got an error reading communication packets)

Ghani8856

Registered
May 29, 2020
2
0
1
United States
cPanel Access Level
Root Administrator
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

Registered
May 29, 2020
2
0
1
United States
cPanel Access Level
Root Administrator
my.cnf configuration

Code:
[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
 
Last edited by a moderator: