Date: Mon, 28 Nov 2016 17:42:50 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 214566] databases/mysql57-server: After version 5.7.12 cannot keep up with replication Message-ID: <bug-214566-13-VXTUzOvLCd@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-214566-13@https.bugs.freebsd.org/bugzilla/> References: <bug-214566-13@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D214566 --- Comment #2 from pete@twisted.org.uk --- I did some more experimenting with this today. have upgraded a machine from 10.3 to 11.0 to test. The problem still exists. I also changed the mysql filesystem from ZFS to UFS - again, the problem st= ill exists. Finally, on the slae, I tried remoiving lots of my custom tweaks to buffer sizes and log optiuons to go back tothe defaults. Again the problem still exists. In the test environment I have four machines, one a master, and three slave= s. All machines are using innodb, I can attach the slave config, or give you a login on the slave machine where I have reproduced the problem. Everything works fine with 5.7.12, upgrading a slave to anything after that and it slo= ws down drasticly - a few table inserts can cause it to be several seconds beh= ind. mysql is installed using 'pkg add' it was upgraded using 'pkg upgrade', and= I ran mysql_upgrade after doing this. I have shown its not a ZFS issue, but I am suspicious that it is a FreeBSD issue as if it affected other systems then surely I wouldn't be the only one affected. I will try this with a Linux machine this week though and if it turns out n= ot to be a FreeBSD issue then this can obviously be closed. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-214566-13-VXTUzOvLCd>