Rackspace MariaDB memory sizing

Follow

Brian Merrifield

• August 09, 2020 15:45

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

0

• Official comment

  

  Ashraf Sharif

  • August 10, 2020 04:29

  Hi 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:

  • https://severalnines.com/database-blog/mysql-performance-cheat-sheet
  • https://severalnines.com/database-blog/mysql-configuration-tuning-performance

  Regards,
  Ashraf

  Comment actions Permalink

Please sign in to leave a comment.