Bug #77778 tuning the log_lock contention for IO_THREAD and SQL_THREAD in rpl_slave.cc
Submitted: 19 Jul 2015 5:57 Modified: 31 Mar 2017 17:24
Reporter: Fangxin Flou (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.6.25 OS:Any
Assigned to: CPU Architecture:Any
Tags: binlog, slave

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:

[19 Jul 2015 5:58] Fangxin Flou
Patch file for log_lock optimization.

Attachment: mysql-5.6.25-slave-lockless.txt (text/plain), 20.51 KiB.

[19 Jul 2015 7:17] Fangxin Flou
fix a bug of the patch

Attachment: mysql-5.6.25-slave-lockless.txt (text/plain), 20.54 KiB.

[20 Jul 2015 11:31] Fangxin Flou
keep on tuning the log_lock

Attachment: mysql-5.6.25-slave-lockless.txt (text/plain), 22.56 KiB.