mysql version Server version: 5.6.22-71.0-log Percona Server (GPL), Release 71.0, Revision 726
recently turned on
set global log_warnings=3
and under the mysql-error.log noticing a lot of
2015-12-01 09:22:51 13094 [Warning] Aborted connection 530023 to db: 'dbxxxx' user: 'userxxxxx' host: 'hostxxxx' (Got an error reading communication packets)
2015-12-02 02:15:59 13094 [Warning] Aborted connection 530023 to db: 'dbxxxx' user: 'userxxxxx' host: 'hostxxxx' (Got timeout reading communication packets)
here is what the my.cnf looks like
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[isamchk]
key_buffer_size = 16M
[mysqld]
basedir = /usr
bind-address = 0.0.0.0
binlog_format = MIXED
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
datadir = /var/lib/mysql/data
expire_logs_days = 3
group_concat_max_len = 4096
innodb_buffer_pool_size = 189269272429
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_lock_wait_timeout = 180
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
innodb_log_group_home_dir = /var/lib/mysql/innodb_logs/
key_buffer_size = 32M
log_bin = /var/lib/mysql/bin_logs/mysql-bin
log_bin_trust_function_creators = 1
log_error = /var/lib/mysql/mysql-error.log
log_queries_not_using_indexes = 1
long_query_time = 18
lower_case_table_names = 1
max_allowed_packet = 134217728
max_binlog_size = 100M
max_connect_errors = 1000000
max_connections = 1250
max_heap_table_size = 32M
myisam-recover = FORCE,BACKUP
open_files_limit = 65535
pid-file = /var/lib/mysql/mysql.pid
port = 3306
query_cache_limit = 1M
query_cache_size = 0
query_cache_type = 0
server_id = 110103725
skip-external-locking
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/mysql-slow.log
socket = /var/lib/mysql/mysql.sock
sql_mode = ANSI_QUOTES,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ssl = false
ssl-ca = /etc/mysql/cacert.pem
ssl-cert = /etc/mysql/server-cert.pem
ssl-key = /etc/mysql/server-key.pem
symbolic-links = 0
sync_binlog = 1
table_definition_cache = 4096
table_open_cache = 4096
thread_cache_size = 50
thread_stack = 256K
tmp_table_size = 32M
tmpdir = /var/lib/mysql/tmp/
transaction-isolation = READ-COMMITTED
user = mysql
[mysqld_safe]
log_error = /var/lib/mysql/mysql-error.log
nice = 0
numa_interleave = 1
pid_file = /var/lib/mysql/mysql.pid
socket = /var/lib/mysql/mysql.sock
[mysqldump]
max_allowed_packet = 16M
quick
quote-names
has any one experienced anything like this before, and if yes, i would appreciate if i can be pointed in that direction.
thanks in advance,