semisync replication is slow and incompatible with slave_compressed_protocol
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
The QPS drops from around 300 QPS to around 30 QPS when
slave_compresse
pt-heartbeat --database heartbeat --table heartbeat --update --create-table
--daemonize --interval 0.01
The state on the master is "Waiting for semi-sync ACK from slave"
master my.cnf settings
plugin-load = rpl_semi_
rpl_semi_
rpl_semi_
rpl_semi_
rpl_semi_
slave_compresse
slave my.cnf settings
plugin-load = rpl_semi_
rpl_semi_
rpl_semi_
rpl_semi_
rpl_semi_
slave_compresse
tags: | added: performance |
See upstream bug https:/ /bugs.mysql. com/bug. php?id= 85382