Question

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

Posted November 28, 2013 4.1k 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.

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.

×
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.
Submit an Answer