== 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.
== 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/ 62b80f7d9db06d0 edecf5a277e6a7f c489d806d5). 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.