New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Webstacks That Run on LES servers
Any webstacks that run on LES/Inception hosting servers without swapping?
Anthony does 128mb/256mb servers.
I'm running nginx, mariadb 10.1, memcached and php5.6-fpm on dacentec's 512MB ovz server and it's swapping already with only 2 active wordpress installs.
total used free shared buffers cached Mem: 512M 483M 28M 71M 0B 342M -/+ buffers/cache: 140M 371M Swap: 256M 110M 145M
I'm not an expert by any means, so I'm only doing minimal/no tweaks on default settings. It seems mysql is eating most of my ram. I used php5fpm in static mode with 2pools with 2 children each, but now I'm putting them into on-demand instead with max 2 children only with a 10s timeout window.
Comments
Disabling "performance schema" https://mariadb.com/blog/starting-mysql-low-memory-virtual-machines
and disabling InnoDB if your WordPress doesn't use it http://lowendbox.com/blog/reducing-mysql-memory-usage-for-low-end-boxes/
should free up a lot of RAM.
For further advice you should post the output of
top
sorted by memory usage (shift-M)how much traffic is it?
Wordpress by default uses mysql's default db storage engine, which is innodb from reading this: http://markmaunder.com/2011/06/23/wordpress-myisam-vs-innodb-mysql/.
How bad is MyISAM's table locking?
Anyway, here's TOP:
New projects, so not much in the first 2 months, then possibly daily 100-300 visitors.
I was thinking about using some of LES servers as analytics server. Dacentec New York to digitalocean london is 90ms.
Looks like you are using the default memory hungry MariaDB configuration. You should really optimize it and do what @rm_ said. I'm using Wordpress with MyISAM and it's working pretty good under MariaDB 10.0 (stable, your 10.1 is dev).
WordPress uses whatever you set as default in your config file. Your sites should run fine with MyISAM as the default engine.
Post your my.cnf here.
Okay, this is .my.cnf from ubuntu 14.04 I run with serverpilot with digitalocean london:
.my.cnf:
Top output:
free -h
Dacentec's OVZ server:
my.cnf:
TOP output:
free -h
Setting Php5-fpm to ondemand pushed down memory usage a bit, but it's still swapping.
Your buffers are way too high and you're using InnoDB. Disable it, use MyISAM instead. Check out the links @rm_ posted.
Add this and it should be good.
Nobody mentioned commenting innodb lines out and I wondered why the hell trying to ignore innodb didn't let mysql to restart.