Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Compiling MySQL on 2GB Pi 4B?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo on ARM
View previous topic :: View next topic  
Author Message
n1ese
Tux's lil' helper
Tux's lil' helper


Joined: 29 Sep 2019
Posts: 82

PostPosted: Tue Apr 14, 2020 6:25 pm    Post subject: Compiling MySQL on 2GB Pi 4B? Reply with quote

Anyone successful in compiling MySQL on a Pi 4B with 2GB? I had toned down my MAKEOPTS enough to compile most things. Despite the error message, I think I am failing because of memory. According to htop, mem and swap pegged out at 100% just before failing.

Do I try dropping down to -j2 on MAKEOPTS?

Code:
MAKEOPTS="-j3"
EMERGE_DEFAULT_OPTS="--jobs=1"


Code:
[ 74%] Building CXX object sql/CMakeFiles/sql_main.dir/auth/sql_user_table.cc.o
cd /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql-8.0.19_build/sql && /usr/bin/aarch64-unknown-linux-gnu-g++ -DHAVE_CONFIG_H -DHAVE_LIBEVENT2 -DHAVE_OPENSSL -DHAVE_TLSv13 -DLZ4_DISABLE_DEPRECATE_WARNINGS -DMYSQL_COMPONENT -DMYSQL_SERVER -DRAPIDJSON_NO_SIZETYPEDEFINE -DRAPIDJSON_SCHEMA_USE_INTERNALREGEX=0 -DRAPIDJSON_SCHEMA_USE_STDREGEX=1 -DUNISTR_FROM_CHAR_EXPLICIT=explicit -DUNISTR_FROM_STRING_EXPLICIT=explicit -D_FILE_OFFSET_BITS=64 -D_GNU_SOURCE -D_USE_MATH_DEFINES -D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS -I/var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql-8.0.19_build -I/var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql-8.0.19_build/include -I/var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql -I/var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/include -isystem /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/extra/rapidjson/include -isystem /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/extra/libedit/editline -isystem /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/extra/zstd/lib -isystem /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/include/boost_1_70_0/patches -isystem /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/boost/boost_1_70_0   -march=armv8-a+crc -mtune=cortex-a72 -ftree-vectorize -O2 -pipe -felide-constructors -fno-strict-aliasing -Wall -Wextra -Wformat-security -Wvla -Wundef -Wmissing-format-attribute -Woverloaded-virtual -Wcast-qual -Wimplicit-fallthrough=2 -Wstringop-truncation -Wlogical-op -DDBUG_OFF -DNDEBUG -fPIC   -o CMakeFiles/sql_main.dir/auth/sql_user_table.cc.o -c /var/tmp/portage/dev-db/mysql-8.0.19-r1/work/mysql/sql/auth/sql_user_table.cc
{standard input}: Assembler messages:
{standard input}:21473: Warning: end of file not at end of a line; newline inserted
aarch64-unknown-linux-gnu-g++: fatal error: Killed signal terminated program cc1plus
compilation terminated.
Back to top
View user's profile Send private message
n1ese
Tux's lil' helper
Tux's lil' helper


Joined: 29 Sep 2019
Posts: 82

PostPosted: Tue Apr 14, 2020 9:01 pm    Post subject: Reply with quote

Looking like it is not possible on a 2GB Pi 4. I reduced MAKEOPTS to-j2 and made it a bit farther in the build but memory and swap are pegged at 100% once again. Load average showing little individual core usage but numbers of 6.81 4.62 3.79.
Back to top
View user's profile Send private message
Hu
Administrator
Administrator


Joined: 06 Mar 2007
Posts: 22716

PostPosted: Wed Apr 15, 2020 2:06 am    Post subject: Reply with quote

How much swap do you have configured?
Back to top
View user's profile Send private message
n1ese
Tux's lil' helper
Tux's lil' helper


Joined: 29 Sep 2019
Posts: 82

PostPosted: Wed Apr 15, 2020 9:01 am    Post subject: Reply with quote

Hu wrote:
How much swap do you have configured?

Sakaki's image is configured for 1GB swap.
Back to top
View user's profile Send private message
n1ese
Tux's lil' helper
Tux's lil' helper


Joined: 29 Sep 2019
Posts: 82

PostPosted: Wed Apr 15, 2020 6:12 pm    Post subject: Reply with quote

Success! Had to back way down and set MAKEOPTS=-j1 and man it took a long time to compile.
Back to top
View user's profile Send private message
NeddySeagoon
Administrator
Administrator


Joined: 05 Jul 2003
Posts: 54586
Location: 56N 3W

PostPosted: Wed Apr 15, 2020 8:05 pm    Post subject: Reply with quote

n1ese,

Well done!

I have an arm64 binhost you can use if it helps.
_________________
Regards,

NeddySeagoon

Computer users fall into two groups:-
those that do backups
those that have never had a hard drive fail.
Back to top
View user's profile Send private message
n1ese
Tux's lil' helper
Tux's lil' helper


Joined: 29 Sep 2019
Posts: 82

PostPosted: Thu Apr 16, 2020 1:12 am    Post subject: Reply with quote

Neddy, thanks. After all this MySQL was giving me issues so I switched to MariaDB and it works like a champ and compiled much faster. :D
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo on ARM All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum