Detailed ping command package and analysis of mysql protocol

git

https://github.com/sea-boat/mysql-protocol

Overview

The mysql client can use the ping command to check the status of the server. Normally, an ok packet will be returned.

mysql communication message structure

Payload

1              [0e] COM_PING

/**
 * 
 * @author seaboat
 * @date 2016-09-25
 * @version 1.0
 * <pre class="brush:php;toolbar:false"><b>email: </b>849586227@qq.com

*

<b>blog: </b>//m.sbmmt.com/;/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";
    }

}

Copy after login

The above is the detailed content of the ping command package and analysis of the mysql protocol. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!