Statistics command package and analysis of mysql protocol

git

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

Overview

The mysql client queries the internal statistics of the server through the statistics command.

mysql communication message structure

Payload

1              [09] COM_STATISTICS

/**
 * 
 * <pre class="brush:php;toolbar:false"><b>statistics command packet.</b>

* @author *

seaboat

*

<b>email: </b>849586227@qq.com

*

<b>blog: </b>http://www.php.cn/;/pre>
 * @version 1.0
 * @see http://www.php.cn/
 */public class StatisticsPacket extends MySQLPacket {

    public byte payload;    
    @Override
    public int calcPacketSize() {        
    return 1;
    }    
    @Override
    protected String getPacketInfo() {        
    return "MySQL Statistics Packet";
    }    
    @Override
    public void read(byte[] data) {
        MySQLMessage mm = new MySQLMessage(data);
        packetLength = mm.readUB3();
        packetId = mm.read();
        payload = mm.read();
    }    @Override
    public void write(ByteBuffer buffer) {        
    int size = calcPacketSize();
        BufferUtil.writeUB3(buffer, size);
        buffer.put(packetId);
        buffer.put(COM_STATISTICS);
    }

}

Copy after login

The above is the statistics command package and analysis content of the mysql protocol. For more related content, please pay attention to the PHP Chinese website (www.php.cn )!