Bug #75570 semi-sync replication performance degrades with a high number of threads
Submitted: 21 Jan 2015 7:52 Modified: 27 Apr 2015 8:27
Reporter: Rene' Cannao' Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.6.20 OS:Linux
Assigned to: CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[21 Jan 2015 7:54] Rene' Cannao'
output of pt-pmp

Attachment: semisync_3000threads.tar.gz (application/x-gzip, text), 106.04 KiB.

[21 Jan 2015 19:52] Rene' Cannao'
master config file

Attachment: bug75570_master_config.txt (text/plain), 15.66 KiB.

[21 Jan 2015 19:52] Rene' Cannao'
slave config file

Attachment: bug75570_slave_config.txt (text/plain), 15.66 KiB.

[16 Feb 2015 13:39] Rene' Cannao'
master config file

Attachment: glovar_master.txt (text/plain), 13.94 KiB.

[16 Feb 2015 13:40] Rene' Cannao'
slave config

Attachment: glovar_slave.txt (text/plain), 13.95 KiB.

[19 Feb 2015 12:59] Umesh Shastry
test results

Attachment: 75570_results.txt (text/plain), 6.76 KiB.

[19 Feb 2015 15:19] Rene' Cannao'
sysbench results

Attachment: 75570_sysbench.txt (text/plain), 10.31 KiB.

[9 Mar 2015 10:37] Venkatesh Duggirala
MySQL 5.6 Preview Patch

Attachment: bug75570-mysql-5.6-patch.diff (text/x-patch), 9.60 KiB.