0

My memory usage hangs around 25% (swap is generally 1%) on my dedicated server and load is around 2-5.

My host recommended that I upgrade from 2GB of ram to 4GB so that I can increase my innodb_buffer from the default 16MB to 2GB. My innodb table size is 2GB.

My question is, given that ram usage is 25% does it make sense to upgrade ram? Queries are hanging sometimes, so I'm thinking that a bigger innodb_buffer could decrease load on the database, just not sure if I really need to upgrade my ram first.

mk1000
  • 255
  • 1
  • 3
  • 4

1 Answers1

5

I would recommend making the buffer larger, but still within your existing memory footprint, and see what the performance increase is.

By the way, I can't argue enough for having metrics to look at and graph when you change your settings. Humans have enough cognitive biases that we need to look at hard numbers, rather than go by "oh, it feels faster"

Matt Simmons
  • 20,396
  • 10
  • 68
  • 116
  • +1, try using what you've got before buying more. – Chris S May 02 '10 at 19:42
  • Ok, I experiment with increasing it now and see how it handles. Still, curious what a general range for accepted memory usage would be. For instance, should the server handle fine if memory usage is at 70%? – mk1000 May 02 '10 at 20:36
  • Yes, it should, but memory is only one metric. How's the load (and how many cores do you have)? – Matt Simmons May 02 '10 at 20:56
  • +1 for having "metrics to look at and graph" boy is that an understatement. I wouldn't change anything until you've had enough time to do a baseline of all the basics (cpu/disk/mem) and have something to compare your changes to – Jim B May 03 '10 at 16:04