mysql

installing mysql on my vps resulted in it starting and eating the entire ram (>300MB), which was quite annoying to fix (mysql was enabled in systemd so it was starting after reboot)

you could say it was kinda my fault and you'd be correct (i've made this blunder twice in the span of few months)

comments

/c/34 by /u/oo8dev @ 2025-01-27 22:14:44

oh, sorry, I forgot to add my footer.

𝗦𝗲𝗻𝘁 𝗳𝗿𝗼𝗺 𝗺𝘆 𝗢𝗱𝗿𝗼𝗶𝗱 𝗠𝟭

/c/33 by /u/oo8dev @ 2025-01-27 22:13:13

No problem with that. Even android smartphones do that too, to preserve internal storage flash wear. Process RAM is highly compressible by its nature in most scenarios.

/c/32 by /u/ezioleq @ 2025-01-27 14:17:53

ZRAM on a server seems a bit stinky, but I'm not an SysOps

/c/31 by /u/oo8dev @ 2025-01-27 13:19:04

i have many containers on my self-hosted mini-server, each of them has some kind of database, mostly mariadb too. Maybe it uses a little bit of ram, but most of it is static and can be easily swapped by the OS. Nothing to worry about tbh.

You can easily d̶o̶w̶n̶l̶o̶a̶d̶ ̶t̶h̶e̶ ̶r̶a̶m̶ enable zram on your KVM/QEMU vps by doing this:
modprobe zram
echo lz4 > /sys/block/zram0/comp_algorithm
echo 16G > /sys/block/zram0/disksize
mkswap --label zram0 /dev/zram0
swapon --priority 100 /dev/zram0

works 99% of the time. You can execute it in a script directly at startup.

𝗦𝗲𝗻𝘁 𝗳𝗿𝗼𝗺 𝗺𝘆 𝗢𝗱𝗿𝗼𝗶𝗱 𝗠𝟭

/c/30 by /u/ezioleq @ 2025-01-27 11:00:06

default mysql installation is a bit resource consuming, so yeah, you have to fiddle with some configs to make it more memory efficient and then it will run even on 321 MB RAM VPS