The MySQL Protocol is the network protocol that is used between a MySQL server and a client. This is called the “classic” protocol as there is now a newer protobuf based protocol called X Protocol. However the “classic” protocol is used by many database drivers, applications, etc. and also by MySQL Replication.
The MySQL Protocol has the option to compress network traffic. Most client libraries don’t enable this by default as this increases CPU usage.
Initially this was added in MySQL 3.22 (based on historical release notes) and was based on zlib.
Then in MySQL 8.0.18 a …[Read more]