Mysql Protocol ping command package and analysis details and instances, mysqlping

Mysql Protocol ping command package and analysis details and instances, mysqlping

Ping Command package of mysql protocol and Explanation

Preface:

The MySQL client can use the ping command to check the status of the server. Normally, an OK packet is returned.

Mysql communication packet structure

Type	Name	Description
Int <3>	Payload length	Stored according to the least significant byte first, 3 bytes of payload and 1 byte serial number are combined into the report Header
Int <1>	Serial number
String	Payload	Style. The length is the payload length specified earlier.

Ping Command package

Payload

[0e] COM_PING

More details: http://dev.mysql.com/doc/internals/en/com-ping.html

Ping Command package

/** *  * @author seaboat * @date 2016-09-25 * @version 1.0 * <pre><b>email: </b>849586227@qq.com</pre> * <pre><b>blog: </b>http://blog.csdn.net/wangyangzhizhou</pre> * <p>ping command packet.</p> */public class PingPacket extends MySQLPacket {  // payload length is 1,packet id is 0,payload is 0e  public static final byte[] PING = new byte[] { 1, 0, 0, 0, 14 };  @Override  public int calcPacketSize() {    return 1;  }  @Override  protected String getPacketInfo() {    return "MySQL Ping Packet";  }}

Source code download: http://xiazai.jb51.net/201701/yuanma/mysql-protocol-master (jb51.netw..rar

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!