I want to know about --compress or -C in MySQL how does it work?
Answer No: 78
This is one of the MySQL connection options. This option causes data sent between the client and the server to be compressed before transmission and uncompressed upon receipt. In profit, it reduces the number of bytes sent over the connection, which can be helpful on slow networks. However, there is an additional computational overhead for both the client and server to perform compression and un-compression.