Re: Got timeout writing communication packets
MySQL Error logs:
2021-08-05T20:21:37.774914Z 3172280 [Note] Aborted connection 3172280 to db: 'mysqldb' user: 'mysqluser' host: 'hostname.internal' (Got an error reading communication packets)
2021-08-05T20:21:37.774917Z 3172269 [Note] Aborted connection 3172269 to db: 'mysqldb' user: 'mysqluser' host: 'hostname.internal' (Got an error reading communication packets)
2021-08-06T02:52:43.505674Z 3193972 [Note] Aborted connection 3193972 to db: 'mysqldb' user: 'mysqluser' host: 'hostname.internal' (Got timeout writing communication packets)
2021-08-06T05:13:44.963211Z 3198056 [Note] Aborted connection 3198056 to db: 'mysqldb' user: 'mysqluser' host: 'hostname.internal' (Got timeout writing communication packets)
innodb_buffer_pool_size size is 120G allocated on total memory of 188G
innodb_buffer_pool_reads values around 500 to 600 during the issue query running in db.
Subject
Written By
Posted
Re: Got timeout writing communication packets
August 06, 2021 03:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.