Litopia

My fella is a programmer and in the next room. If it's a question that can be relayed vocally, I may be able to help?

MySQL & MariaDB, are supposed to be identical. With our 4GB server MariaDB remorselessly eats up memory, real and virtual, then stops running bringing everything down. Described here and I’ve implemented their “fix”. Don’t know if it will work yet. Suggestions welcome p.

He hasn't heard of MariaDB, I'm afraid. He just said to look at this, if you haven't yet: MariaDB Memory Allocation

I'll take a read of the problem and see if I can get back to you.

This is a bandage for the issue of storage and retrieval performance. The crash is bound to happen on a small virtual server (as soon as RAM runs out it will crash), and RAM fills with pages of record indexes to speed up the data lookup process. That's a pretty standard performance feature of MySQL dbs. What you're losing is the added speed those indexes provide. Will it be noticeable? Time will tell.

Should note that I've never used MariaDB but have configured quite a few databases, including MySQL.

Thanks so much… I’ve taken the plunge and transitioned from Centos 7 to AlmaLinux… and presto, the problem seems to have disappeared! Fingers crossed for a few hours...