Comment 0 for bug 1706291

== 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.