CODEWITHSUNDEEP
mariadbmariadb-connect-engine
user2848031
user2848031

Reputation: 227

Maria DB recommended RAM,disk,core capacity?

I am not able to find maria DB recommended RAM,disk,number of Core capacity. We are setting up initial level and very minimum data volume. So just i need maria DB recommended capacity.

Appreciate your help!!!

Upvotes: 6

Views: 25563

Answers (3)

Senthil
Senthil

Reputation: 171

MariaDB or MySQL both actually use very less memory. About 50 MB to 150 MB is the range I found in some of my servers. These servers are running a few databases, having a handful of tables each and limited user load. MySQL documentation claims in needs 2 GB. That is very confusing to me. I understand why MariaDB does not specify any minimum requirements. If they say 50 MB there are going to be a lot of folks who will want to disagree. If they say 1 GB then they are unnecessarily inflating the minimum requirements. Come to think of it, more memory means better cache and performance. However, a well designed database can do disk reads every time without any performance issues. My apache installs (on the same server) consistently use up more memory (about double) than the database.

Upvotes: 0

Rick James
Rick James

Reputation: 142248

1 CPU core is more than enough for most MySQL/MariaDB installations.

512MB of RAM is tight, but probably adequate if only MariaDB is running. But you would need to aggressively shrink various settings in my.cnf. Even 1GB is tiny.

1GB of disk is more than enough for the code and minimal data (I think).

Please experiment and report back.

There are minor differences in requirements between Operating system, and between versions of MariaDB.

Turn off most of the Performance_schema. If all the flags are turned on, lots of RAM is consumed.

20 years ago I had MySQL running on my personal 256MB (RAM) Windows box. I suspect today's MariaDB might be too big to work on such tiny machine. Today, the OS is the biggest occupant of any basic machine's disk. If you have only a few MB of data, then disk is not an issue.

Look at it this way -- What is the smallest smartphone you can get? A few GB of RAM and a few GB of "storage". If you cut either of those numbers in half, the phone probably cannot work, even before you add apps.

Upvotes: 2

Alfa Bravo
Alfa Bravo

Reputation: 1991

Seeing that over the last few years Micro-Service architecture is rapidly increasing, and each Micro-Service usually needs its own database, I think this type of question is actually becoming more appropriate.

I was looking for this answer seeing that we were exploring the possibility to create small databases on many servers, and was wondering for interest sake what the minimum requirements for a Maria/MySQL DB would be...

Anyway I got this helpful answer from here that I thought I could also share here if someone else was looking into it...

When starting up, it (the database) allocates all the RAM it needs. By default, it will use around 400MB of RAM, which isn’t noticible with a database server with 64GB of RAM, but it is quite significant for a small virtual machine. If you add in the default InnoDB buffer pool setting of 128MB, you’re well over your 512MB RAM allotment and that doesn’t include anything from the operating system.

Upvotes: 7

Related Questions