Detailed ping command package and analysis of mysql protocol
- 黄舟Original
- 2017-03-07 14:01:131687browse
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
| Type | Name | Description |
|---|---|---|
| int5bdf4c78156c7953567bb5a0aef2fc53 | payload length | Stored according to the least significant byte first, 3-byte payload and 1-byte sequence number combination Into the message header |
| intf35d6e602fd7d0f0edfa6f7d103c1b57 | sequence number | |
| payload | Message body, the length is the previously specified payload length |
Payload
1 [0e] COM_PINGMore details: http://dev.mysql.com/doc/internals/en/com-ping.htmlping Command package class
/**
*
* @author seaboat
* @date 2016-09-25
* @version 1.0
* email: 849586227@qq.com
* blog: http://www.php.cn/;/pre>
* ping command packet.
*/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";
}
}
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 (www.php.cn)! email: 849586227@qq.com*
blog: http://www.php.cn/;/pre> *ping command packet.
*/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"; } }
Statement：
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