[VestaCP] MariaDB 10.2.14 (Got timeout reading communication packets)

hassaandev

I am seen warning messages in my logs of MariaDB server. These are there, I have tried many things like I have optimize and repair all of my databases but warning are still there.

2018-04-19 22:50:14 139673358411520 [Warning] Aborted connection 473891 to db: 'admin_******' user: 'admin_******' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:52:43 139672739514112 [Warning] Aborted connection 474608 to db: 'admin_****** user: 'admin_****** host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:53:31 139672741635840 [Warning] Aborted connection 474834 to db: 'admin_******' user: 'admin_******' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:54:16 139672739514112 [Warning] Aborted connection 475117 to db: 'admin_******' user: 'admin_******' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:55:49 139672740726528 [Warning] Aborted connection 475696 to db: 'admin_******' user: 'admin_******' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:55:53 139672740120320 [Warning] Aborted connection 475717 to db: 'admin_******ine' user: 'admin_******ine' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:56:43 139673235744512 [Warning] Aborted connection 476011 to db: 'admin_******lin' user: 'admin_******lin' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:56:57 139673235138304 [Warning] Aborted connection 476095 to db: 'admin_******ine' user: 'admin_******ine' host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:57:20 139672742545152 [Warning] Aborted connection 476186 to db: 'admin_****** user: 'admin_****** host: 'localhost' (Got timeout reading communication packets)

2018-04-19 22:57:51 139673235441408 [Warning] Aborted connection 476340 to db: 'admin_******ine' user: 'admin_******ine' host: 'localhost' (Got timeout reading communication packets)

My `my.cnf`

    skip-external-locking

    key_buffer_size = 256M

    max_allowed_packet = 500M

    table_open_cache = 256

    sort_buffer_size = 1M

    read_buffer_size = 1M

    read_rnd_buffer_size = 4M

    myisam_sort_buffer_size = 64M

    thread_cache_size = 8

    query_cache_size= 16M

    thread_concurrency = 8

    innodb_file_per_table

    max_connections=500

    wait_timeout=60

    interactive_timeout=60

    long_query_time=5

I am using CentOS 7 with 8 GB of RAM.

Can someone help me?

Giedrius

Hey hassaandev,

this could have few reasons and al of ti requires some testing and monitoring. You can read about this situation and possible reason here:

https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/