CiviCRM Community Forums (archive)

I am new to VPS hosting and I would love to hear some opinions on VPS sizing and/or performance tips.
(I have run internal Linux hardware servers before but with 1GB of RAM or more.)

Site: 1000 page views/mth, in campaign time about double of that.
Administration: 2 Drupal content editors making about 1 edit per day if that.
CiviCRM: Once weekly report pulling, once monthly mailing list, webform integration with low # of submits.

I have a 384MB OpenVZ based VPS as I have read many anecdotal posts about running Drupal on 256MB VPS but I am constantly running out of memory.
I am using Apache2 at the moment. I have tried using both mod_php with mpm_prefork and mod_fcgid with mpm_worker. My Apache settings for each are down below.

Part 2:
Is there any info on getting the memory usage of InnoDB down? I can't find any posts on it.
All the low memory tuning articles say is turn on "skip-innodb". My MySQL process RSS is 27MB to 31MB.

<IfModule mpm_prefork_module>
StartServers       1
MinSpareServers    2
MaxSpareServers    4
MaxClients        10
    MaxRequestsPerChild   2000
</IfModule>


<IfModule mpm_worker_module>
StartServers       1
MinSpareThreads    2
MaxSpareThreads    6
    ThreadLimit          16
    ThreadsPerChild      8
MaxClients        8
    MaxRequestsPerChild   0
</IfModule>


Hi Coleman,

Thanks for your input. It is really nice to get another estimate. We ended up moving the site to to 512MB Xen VPS and it seems to be adequate so far and we were able to raise the MaxClients setting a bit. It is still somewhat high on RAM usage but its not crashing. I think the difference between OpenVZ and Xen - having swap space - may be the most critical element rather than 384MB vs. 512MB.

No, so far we are getting away without having another language installed.
I was unsure whether I needed additional languages so I had asked in this post http://forum.civicrm.org/index.php/topic,24237.0.html.
I ended getting all my webforms done without installing another CiviCRM language - using only Drupal multilanguages.
I have not yet tested using mailing lists with email templates in multiple languages without actually installing languages.