MySQL Forums
Forum List  »  Source, Builds, Binaries

Re: MySQL 8.0.16 on Fedora/PPC64LE : I see issues, inc. hangs
Posted by: Terje Røsten
Date: August 20, 2019 02:33AM

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.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.