The official documentation for
MySQL Connector/J has the answer. Setting the
useCompression connection property to
true enables zlib compression between client and server.
You can set this property when creating a new resource name:
From the menu, open a connection, click "New", then "Next", give the source a name, and select "MySQL(Connector/J)" as the type. Specify the host info, user, password, database, and when prompted for connection properties, click "Add Property", and set the property name to
useCompression and the value to
I've seen speedups of 70% when transferring large amounts of data (your mileage may vary).
Alternatively, client/server compression can be set programmatically using
WriteDataSource["testSQL", "MySQL(Connector/J)", URL -> "main/test",
Username -> "user", Password -> "password", Location -> "System",