We are using
MySQL Version 5.1.73. Database is getting huge number of connections around 600 at one time.
Aborted Connections are getting increased from
Global Status variables. So I enabled
log_warnings=2 and when I checked MySQL log file, I observed huge number of below warnings:
[Warning] Aborted connection 21352666 to db: 'DBName' user: 'UserName' host: 'xx.xx.xx.xx' (Got an error reading communication packets)
I searched in Google and increased
max_allowed_packet to 250 MB.
DB Size is 700 MB. Innodb_log_file_size is 50 MB.
We also observed error like
'lost connection to MYSQL server at 'reading authorization packet' system error 0' in application log files.
Why are we getting these warnings and errors and what to do to avoid them?