# MySQL: Error reading communication packets

**URL:** <https://forums.percona.com/t/mysql-error-reading-communication-packets/2653>\
**Category:** Other MySQL® Questions\
**Created:** [April 27, 2013, 8:03am UTC](https://forums.percona.com/t/mysql-error-reading-communication-packets/2653 "2013-04-27T08:03:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajibmp](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@rajibmp](https://forums.percona.com/u/rajibmp)\
**Post date:** [April 27, 2013, 8:03am UTC](https://forums.percona.com/t/mysql-error-reading-communication-packets/2653/1 "2013-04-27T08:03:46Z")

</div>

I get this warning in mysql

> [@](#):
>
> [Warning] Aborted connection 21 to db: ‘MyDB’ user: ‘MyUser’ host: ‘localhost’ (Got an error reading communication packets)

I have been through few topics in google and according to some suggestion I increased the max\_allowed\_packet from 128 to 512 to 1024 still the same behaviour.

I am using Drupal 7, and yes there are lots of blob data types, but 1024 Mb of max\_allowed\_packet should be enough in my opinion.

Any other workaround how to overcome this warning ?

My mysql config looks like this:

```auto
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1024M
table_open_cache = 128
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 192K
# Query cache disabled
thread_cache_size = 8
myisam-recover = BACKUP
max_connections = 100
thread_concurrency = 10
tmp_table_size = 128M
max_heap_table_size = 128M
log_error = /var/log/mysql/mysql-error.log
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2

log_warnings = 2

server-id = 1
binlog-format = row
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 1
log_bin = mysql-bin
log-slave-updates
relay-log=mysqld-relay-bin
expire_logs_days = 10
max_binlog_size = 100M

innodb_data_home_dir = /var/db/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/db/mysql
innodb_buffer_pool_size = 8G
character-set-server = utf8
#innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 2047M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 8
innodb_lock_wait_timeout = 50
innodb_flush_method = O_DIRECT

[mysqldump]
quick
quote-names
max_allowed_packet = 16M
default-character-set = utf8

[mysql]
default-character-set = utf8

[myisamchk]
key_buffer_size = 32M
sort_buffer_size = 32M

[mysqlhotcopy]
interactive-timeout

[mysqld_save]
syslog

```

My application uses only InnoDB, but there are few database like mysql, which came with the standard mysql installations are only the ones which uses MyISAM engine type, I guess that should not be my concern though.

As you can see I have replication too, the warning is the same one in replicated server too, whose config is identical as this.

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [April 29, 2013, 10:43am UTC](https://forums.percona.com/t/mysql-error-reading-communication-packets/2653/2 "2013-04-29T10:43:15Z")

</div>

Could you check network link statistics? I don’t think it’s a configuration issue.

---

<div class="post-metadata">

**Author:** ![rajibmp](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@rajibmp](https://forums.percona.com/u/rajibmp)\
**Post date:** [April 30, 2013, 5:02am UTC](https://forums.percona.com/t/mysql-error-reading-communication-packets/2653/3 "2013-04-30T05:02:32Z")

</div>

what to check in network link statistics, as I can check it, but I don’t know what to look for.