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

November 28, 2013 2.8k views
I'm developing a DB management system for an organization. I don't expect many users. A max of 500, simultaneously, only about 20.
6 Answers
Are you going to use memcache and swap? 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.
Hi Pablo
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 ?
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.
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.
Thanks for the reply.
Ralper
"Doesn't the standard setup have a designated amount of swap?"

No, you have to add it yourself. See How To Add Swap on CentOS 6.
by Etel Sverdlov
Linux swaps allow a system to harness more memory than was originally physically available. Here's how to set up a linux swap file on CentOS 6
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.

Memcache(d) caches objects in memory and not on disk.
Hi Kamal and Pablo
If memcache caches objects in memory rather than on disk, how would that help me if I start to run out of memory?
It wouldn't help, but it will make your site faster as long as your is configured to use it.
Have another answer? Share your knowledge.