Re: MySQL 8.0.16 on Fedora/PPC64LE : I see issues, inc. hangs

[Terje Røsten]

Hi!

Let me just add some generic advice when building and testing MySQL 8.

- create a non-root user to do everyhing e.g. called build
- as root increase some system wide settings:

In /etc/sysctl.conf set

fs.aio-max-nr = 30000000

and run

$ sysctl -p /etc/sysctl.conf

Edit /etc/security/limits.conf to something like:

* soft nofile 16384
* hard nofile 16384
* soft nproc 65536
* hard nproc 65536
* soft core unlimited
* hard core unlimited
* hard stack 10240
* soft stack 10240
* hard fsize unlimited
* soft fsize unlimited

Build and test tip for build user:

Always build outside sources, something like this:

$ mkdir build && cd build
$ cmake ..
$ make -j$(nproc)

and run MTR with mem and parallel flags:

$ cd mysql-test
$ ./mtr --quiet --mem --parallel=auto

When using a less used platform it's good to have a more or less identical x86_64 system (same compiler and toolchain) to repeat the build + test process. As found issue on less used platform might be generic.