Public bug reported: == Comment: #0 - Daniel Black ---Problem Description--- MySQL-5.6/5.7: default log-tc-size too small on POWER - 3 * ( 64K page size) minimum needed
---uname output--- Linux p87 4.4.0-62-generic #83-Ubuntu SMP Wed Jan 18 14:09:19 UTC 2017 ppc64le ppc64le ppc64le GNU/Linux Machine Type = Any P8 ---Steps to Reproduce--- Perform a large number of XA transactions without a binary log configured. Its usually triggered in the MTR test run. As Power's page size is 64K by default the assumption that 3*8K was sufficient applies to x86 but not Power. Userspace tool common name: MySQL-5.7 The userspace tool has the following bit modes: both Userspace rpm: MySQL-5.7 Userspace tool obtained from project website: na Oracle have corrected this in 8.0 https://bugs.mysql.com/bug.php?id=80818 (https://github.com/mysql/mysql- server/commit/62b80f7d9db06d0edecf5a277e6a7fc489d806d5). A 5.7 backport is here https://bugs.mysql.com/bug.php?id=87175. Alternately (and more minimally) Alexey's patch in https://bugs.mysql.com/bug.php?id=80818 is sufficient (though replace 65535 -> 65536 in patch). --- Work arounds -- Set log-tc-size=196k or larger in my.cnf at startup. ** Affects: dbf2mysql (Ubuntu) Importance: Undecided Assignee: Ubuntu on IBM Power Systems Bug Triage (ubuntu-power-triage) Status: New ** Tags: architecture-ppc64le bugnameltc-156947 severity-high targetmilestone-inin--- ** Tags added: architecture-ppc64le bugnameltc-156947 severity-high targetmilestone-inin--- ** Changed in: ubuntu Assignee: (unassigned) => Ubuntu on IBM Power Systems Bug Triage (ubuntu-power-triage) ** Package changed: ubuntu => dbf2mysql (Ubuntu) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1706291 Title: MySQL-5.7: default log-tc-size too small on POWER. 3 * ( 64K page size) minimum needed To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/dbf2mysql/+bug/1706291/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
