MySQL EMuranoROLX570 Got an error reading communication packets

介绍

时常会在错误日志中见到那些报错,首先大家能够从show
GLOBAL status like
‘%Aborte%’;里面看看三种错误总是的数额,以下是复制官方文书档案的演讲。
  

 

MySQL ERROR Got an error reading communication packets,communicationerror

Aborted_connects 

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:

If these kinds of things happen, it might indicate that someone is
trying to break into your server! If the general query log is enabled,
messages for these types of problems are logged to it.

 

对于Aborted_connects错误的大概原因有:

1.客户端连接一个没有授权的数据库

2.密码错误

3.连接包信息错误

4.连接超时(默认10s)

介绍

平时会在错误日志中看出这么些报错,首先我们可以从show GLOBAL status like
‘%Aborte%’;里面看看三种错误总是的多少,以下是复制官方文书档案的讲解。   

 

Aborted_clients

If a client successfully connects but later disconnects improperly or is
terminated, the server increments
the Aborted_clients status
variable, and logs an Aborted connection message
to the error log. The cause can be any of the following:

Other reasons for problems with aborted connections or aborted clients:

  • The max_allowed_packet variable
    value is too small or queries require more memory than you have
    allocated for mysqld.
    See Section B.5.2.10, “Packet Too
    Large”
    .

  • Use of Ethernet protocol with Linux, both half and full duplex. Some
    Linux Ethernet drivers have this bug. You should test for this bug
    by transferring a huge file using FTP between the client and server
    machines. If a transfer goes in burst-pause-burst-pause mode, you
    are experiencing a Linux duplex syndrome. Switch the duplex mode for
    both your network card and hub/switch to either full duplex or to
    half duplex and test the results to determine the best setting.

  • A problem with the thread library that causes interrupts on reads.

  • Badly configured TCP/IP.

  • Faulty Ethernets, hubs, switches, cables, and so forth. This can be
    diagnosed properly only by replacing hardware.

 

对于 Aborted_clients的由来大概有

一.客户端未有实践mysql_close()关闭

二.出于总是一向未曾安歇导致时间超越wait_timeout or interactive_timeout这两个变量的值(这两个变量的超时时间是8小时)

3.客户端在程序执行过程中结束

4.max_allowed_packet包设的过小

5.网络原因

6.线程bug等

Aborted_connects 

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:

  • A client attempts to access a database but has no privileges for it.

  • A client uses an incorrect password.

  • A connection packet does not contain the right information.

  • It takes more than connect_timeout seconds to obtain a connect
    packet. See Section 5.1.4, “Server System Variables”.

If these kinds of things happen, it might indicate that someone is
trying to break into your server! If the general query log is enabled,
messages for these types of problems are logged to it.

 

对于Aborted_connects错误的大概原因有:客户端连接一个没有授权的数据库、密码错误、连接包信息错误、连接超时(默认10s)

总结

 

 

备注:

    作者:pursuer.chen

    博客:http://www.cnblogs.com/chenmh

本站点所有随笔都是原创,欢迎大家转载;但转载时必须注明文章来源,且在文章开头明显处给明链接。

《欢迎交流讨论》

Aborted_clients

If a client successfully connects but later disconnects improperly or is
terminated, the server increments the Aborted_clients status variable,
and logs an Aborted connection message to the
error log. The cause can be any of the following:

  • The client program did not call mysql_close() before exiting.

  • The client had been sleeping more
    than wait_timeout or interactive_timeout seconds without issuing
    any requests to the server. See Section 5.1.4, “Server System
    Variables”.

  • The client program ended abruptly in the middle of a data transfer.

Other reasons for problems with aborted connections or aborted clients:

  • The max_allowed_packet variable value is too small or queries
    require more memory than you have allocated for mysqld. See Section B.5.2.10, “Packet Too
    Large”.

  • Use of Ethernet protocol with Linux, both half and full duplex. Some
    Linux Ethernet drivers have this bug. You should test for this bug
    by transferring a huge file using FTP between the client and server
    machines. If a transfer goes in burst-pause-burst-pause mode, you
    are experiencing a Linux duplex syndrome. Switch the duplex mode for
    both your network card and hub/switch to either full duplex or to
    half duplex and test the results to determine the best setting.

  • A problem with the thread library that causes interrupts on reads.

  • Badly configured TCP/IP.

  • Faulty Ethernets, hubs, switches, cables, and so forth. This can be
    diagnosed properly only by replacing hardware.

 

对于 Aborted_clients的原由大致有:客户端从未推行mysql_close()关闭、由于再三再四向来没有关闭导致时间超越wait_timeout or interactive_timeout这两个变量的值(这两个变量的超时时间是8小时)、客户端在程序执行过程中结束、max_allowed_packet包设的过小、网络原因、线程bug等

总结

 

 

备注:

    作者:pursuer.chen

    博客:http://www.cnblogs.com/chenmh

本站点所有随笔都是原创,欢迎大家转载;但转载时必须注明文章来源,且在文章开头明显处给明链接。

《欢迎交流讨论》

http://www.bkjia.com/Mysql/1156880.htmlwww.bkjia.comtruehttp://www.bkjia.com/Mysql/1156880.htmlTechArticleMySQL E奇骏RO中华V Got an error reading communication
packets,communicationerror 介绍
平日会在错误日志中观察这些报错,首先我们得以从show GLOBAL status like
‘%Abor…

发表评论

电子邮件地址不会被公开。 必填项已用*标注

网站地图xml地图