From owner-freebsd-ports-bugs@freebsd.org Tue Dec 13 12:05:22 2016 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 6C5EAC721DB for ; Tue, 13 Dec 2016 12:05:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 5AF6C684 for ; Tue, 13 Dec 2016 12:05:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id uBDC5LvG093623 for ; Tue, 13 Dec 2016 12:05:22 GMT (envelope-from bugzilla-noreply@freebsd.org) 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 Date: Tue, 13 Dec 2016 12:05:21 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: needs-qa X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: pete@twisted.org.uk X-Bugzilla-Status: Open X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback+ X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Dec 2016 12:05:22 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D214566 --- Comment #5 from pete@twisted.org.uk --- Ok, I narrowed this down a lot more. I can now get it to be slow using a po= rt of 5.7.12. This version is slow: svn co svn://svn.freebsd.org/ports/head/databases/mysql57-server -r 415407 = slow This version is OK svn co https://svn0.eu.freebsd.org/ports/branches/2016Q2/databases/mysql57-server = -r 428416 ok The slow one is mysql 5.7.12_1 as opposed to 5.7.12 - note they are being checked out from different branches above. I haven't got very far with this yet, but from a quick diff it appears that the big change was to start using openssl from ports instead of base. All my machines replicate using SSL. I haven't tried a build using system SSL yet, but as I am looking at the 'seconds behind master' value to see the lag, then it is not that the actual pulling of the log files is slow. So what else is SSL used for within mysql= ? --=20 You are receiving this mail because: You are the assignee for the bug.=