Slave Compression

Anyone know how to verify if compression is working between replicated servers?

I was pushing about 1.3MB between master -> slave, I added the following to my.ini file:

slave_compressed_protocol = 1

I expected to see a large reduction in the amount of data being transferred, but it did not seem to make any difference at all.

I did some googling to see how to confirm if the compression is actually activated but I came up empty.

Anyone know how to confirm if compression is really engaged?

Did you restart MySQL after changing the setting?

You can see the value of all settings with the query


. Filter with LIKE (