Aborted Connect
Aborted Connect表示尝试连接到MySQL服务器失败的次数。这个状态变量可以结合host_cache表和其错误日志一起来分析问题。 引起这个状态变量激增的原因如下:
1、客户端没有权限但是尝试访问MySQL数据库
2、客户端输入的密码有误
3、连接数据包不包含正确的信息
4、超过连接时间限制,主要是这个系统变量connect_timeout控制(mysql默认是10s,基本上,除非网络环境极端不好,一般不会超时。)
If a client is unable even to connect, the server increments the Aborted_connects status variable. Unsuccessful connection attempts can occur for the following reasons:
1.A client attempts to access a database but has no privileges for it.
2.A client uses an incorrect password.
3.A connection packet does not contain the right information.
4. It takes more than connect_timeout seconds to obtain a connect packet. See Section 5.1.7, “Server System Variables”.官方说明
Aborted Clients
Aborted Clients表示由于客户端没有正确关闭连接而中止的连接数。
1、 客户端程序在退出之前未调用mysql_close()正确关闭MySQL连接
2、 客户端休眠的时间超过了系统变量wait_timeout和interactive_timeout的值,导致连接被MySQL进程终止
3、 客户端程序在数据传输过程中突然结束
1.The client program did not call mysql_close() before exiting.
2.The client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server. See Section 5.1.7, “Server System Variables”.
3. The client program ended abruptly in the middle of a data transfer.官方解释