Rackspace MariaDB memory sizing
Hello, I inherited a MariaDB instance hosted on Rackspace, with what appears to be very low memory. The servers running MariaDB have 2GB-4GB of memory. I find this low, when our MS SQL servers have 96GB of RAM. Even my Android Galaxy S20+ phone has 12GB of memory. Is the low memory, possibly a cause for our website slowness? Is MariaDB a memory intensive SQL DB? Thanks, Brian
It depends on how big your total database size is. If it's very small and can fit into the buffer pool, you should not be limited by the RAM size. Commonly in MySQL and InnoDB, one would set 50-70% of RAM for the buffer pool. I'd advise you to check the innodb_buffer_pool_size and compare it with your database size for a starter. Then, start to tune your MySQL/MariaDB.
Check out the following resources to help you out with the tuning:
Please sign in to leave a comment.