We just recently upgraded our MySQL installation on a debian box.
mysqld version:
mysqld Ver 5.7.12-5 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release ‘5’, Revision ‘a2f663a’)
The MySQL server keeps hanging after every 30 minutes or so. The mysqld process doesn’t die though. Not seeing any information of use in the syslog other than this in massive amounts:
Jun 7 10:25:09 host mysqld[1235]: Error in accept: Socket operation on non-socket
Would appreciate some insights on what to try as to finding the cause of this hanging. Thanks.
Here are some fine tuning settings in my.cnf:
max_allowed_packet = 64M
thread_stack = 256K
thread_cache_size = 8
max_connections = 10000
max_connect_errors = 10000
connect_timeout = 30
wait_timeout = 86400