Home > Database > Mysql Tutorial > body text

processInfo command package and analysis of mysql protocol

黄舟
Release: 2017-03-07 13:44:04
Original
1380 people have browsed it

git

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

Overview

The mysql client queries the active processes on the server through the processInfo command.

mysql communication message structure

##string payloadMessage body, the length is the previously specified payload length
Type Name Description
int<3> payload length Stored according to the least significant byte first, 3-byte payload and 1-byte sequence number combination Into the message header
int<1> sequence number
processInfo command package

Payload

1              [0a] COM_PROCCESS_INFO
Copy after login

More details: http://dev.mysql.com/doc/internals/en/com-process-info.htm

processInfo command package class

/**
 * 
 * <pre class="brush:php;toolbar:false"><b>process info 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 ProcessInfoPacket extends MySQLPacket {

    public byte payload;    @Override
    public int calcPacketSize() {        return 1;
    }    @Override
    protected String getPacketInfo() {        return "MySQL Process Info 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_PROCESS_INFO);
    }

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



source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template