Question

How much memory should I start with using Mysql (innodb) in a LAMP stack ?

  • Posted November 28, 2013

I’m developing a DB management system for an organization. I don’t expect many users. A max of 500, simultaneously, only about 20.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

It wouldn’t help, but it will make your site faster as long as your is configured to use it.

Hi Kamal and Pablo <br>If memcache caches objects in memory rather than on disk, how would that help me if I start to run out of memory? <br>

<blockquote>I’ll take a look at ‘memcache’ I Imagine with the SSD’s, caching memory to disk may not be as sluggish as magnetic drives. </blockquote> <br>Memcache(d) caches objects in memory and not on disk.

<b>“Doesn’t the standard setup have a designated amount of swap?”</b> <br> <br>No, you have to add it yourself. <i>See</i> <a href=“https://www.digitalocean.com/community/articles/how-to-add-swap-on-centos-6”>How To Add Swap on CentOS 6</a>.

Hi Pablo <br> I am familiar with swap but not with memcache.Doesn’t the standard setup have a designated amount of swap ? Can I change it, if necessary ? <br> I’ll take a look at ‘memcache’ I Imagine with the SSD’s, caching memory to disk may not be as sluggish as magnetic drives. <br>I took the initiative of ordering the 1 GB droplet.With 1GB to start, hopefully, I’ll be alright for awhile. As I build the system I’ll just keep track of my memory usage. <br>Thanks for the reply. <br>Ralper <br>

Are you going to use <code>memcache</code> and <code>swap</code>? If so, it’s prob. okay to start with a 500MB droplet, given that DigitalOcean makes it easy to scale up to a droplet with more memory, if needed.