Driver Compression Enablement

[kvolmar]

Is there a way to enable compression when using the Driver rather than the Client?

[kvolmar]

Specifically I've seen

go-mysql/client/conn.go

Lines 124 to 128 in 7c31dc4

	if c.ccaps&CLIENT_COMPRESS > 0 {
	c.Conn.Compression = MYSQL_COMPRESS_ZLIB
	} else if c.ccaps&CLIENT_ZSTD_COMPRESSION_ALGORITHM > 0 {
	c.Conn.Compression = MYSQL_COMPRESS_ZSTD
	}

. Where is ccaps set and is there a way to configure them when using the Driver?

[lance6716]

Specifically I've seen

go-mysql/client/conn.go

Lines 124 to 128 in 7c31dc4

	if c.ccaps&CLIENT_COMPRESS > 0 {
	c.Conn.Compression = MYSQL_COMPRESS_ZLIB
	} else if c.ccaps&CLIENT_ZSTD_COMPRESSION_ALGORITHM > 0 {
	c.Conn.Compression = MYSQL_COMPRESS_ZSTD
	}

. Where is ccaps set and is there a way to configure them when using the Driver?

go-mysql/client/conn.go

Lines 177 to 180 in 7c31dc4

	// SetCapability enables the use of a specific capability
	func (c *Conn) SetCapability(cap uint32) {
	c.ccaps |= cap
	}

[kvolmar]

Thank you @lance6716.

A few more questions:

I am currently using the go-sql-driver/mysql and interested in migrating to go-mysql-org/go-mysql specifically for the driver. I am evaluating the feasibility of using the database/sql library with your driver and enabling compression. I'm currently importing the driver with side effects and able to write to MySQL, but without compression. Are the compression settings configurable with env vars or in the DSN?

[lance6716]

Sorry I think this library does not have this way to configurate compression. Welcome to help us implement it, related files should be under driver folder.

[dvilaverde]

@kvolmar this has been implemented, can you close this issue?