mysql 5.7.14
centos 5.5 32位。
发现很多的 [Note] Aborted connection (Got an error reading communication packets)
php 都写了 mysql_close();
请问有解决此 这种问题的吗 ?谢谢!
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
skip-name-resolve
skip-host-cache
max_connections=500
max_allowed_packet = 512M
#connect_timeout = 60
#net_read_timeout = 120
slow_query_log=1
log_queries_not_using_indexes=0
long_query_time=2
slow-query-log-file=/var/slow.log
slave_compressed_protocol=1
default-time-zone = '+8:00'