Square Wheels Posted September 8, 2016 Share Posted September 8, 2016 It seems my site was using all of it's RAM and getting shut down regularly. My former plan had 1GB of RAM, I now have 2. The host said: the OOM killer terminated the most abusive process (mysql) multiple times. In the last two days:Sep 7 10:26:12 host kernel: [4472565.449607] Out of memory in UB 117: OOM killed process 17498 (mysqld) score 0 vm:822116kB, rss:322840kB, swap:268948kBSep 7 10:39:12 host kernel: [4473346.015083] Out of memory in UB 117: OOM killed process 5514 (mysqld) score 0 vm:803460kB, rss:521108kB, swap:0kBSep 7 11:12:08 host kernel: [4475320.328454] Out of memory in UB 117: OOM killed process 5885 (mysqld) score 0 vm:803432kB, rss:533396kB, swap:0kBSep 7 12:03:10 host kernel: [4478380.964060] Out of memory in UB 117: OOM killed process 6802 (mysqld) score 0 vm:802464kB, rss:531932kB, swap:0kBSep 7 13:01:13host kernel: [4481862.501184] Out of memory in UB 117: OOM killed process 8171 (mysqld) score 0 vm:802704kB, rss:538772kB, swap:76kBSep 8 07:10:39 host kernel: [4547194.277983] Out of memory in UB 117: OOM killed process 9454 (mysqld) score 0 vm:817972kB, rss:284844kB, swap:304688kB I have no idea what any of this means. This is the plan I am on now: SSD 2 VPS 2 CPU Cores 2 GB RAM 60 GB SSD Storage 4 TB Data Transfer Should this be sufficient for a small site? I only have a few hundred members, maybe 20 on at a time. Link to comment Share on other sites More sharing options...
IveLeft... Posted September 8, 2016 Share Posted September 8, 2016 Yes it should be ok, but lots of things could affect this, not enough info..... Apache ? Nginx ? MariaDB ? MySql ? Versions ? Any Caching ? Type of VPS (KVM, OpenVZ etc) ? Any optimisation done ? Mysql tuner ? Has it always been ok ? Just started ? Anything changed recently ? Link to comment Share on other sites More sharing options...
Square Wheels Posted September 8, 2016 Author Share Posted September 8, 2016 14 minutes ago, Cloud 9 said: Yes it should be ok, but lots of things could affect this, not enough info..... Apache ? Nginx ? MariaDB ? MySql ? Versions ? Any Caching ? Type of VPS (KVM, OpenVZ etc) ? Any optimisation done ? Mysql tuner ? Has it always been ok ? Just started ? Anything changed recently ? I don't know where to find most of that info. Apache ? Don't know Nginx ? Don't know MariaDB ? No MySql ? Yes Versions ? PHP 5.6.16, MySQL 5.6.28 Any Caching ? XCache is checked off, but also greyed out. I can't select anything aside from No Caching Type of VPS (KVM, OpenVZ etc) ? Where do I find this? Any optimisation done ? How would I know? Mysql tuner ? No idea Has it always been ok ? Not really. I was with a different host and they had a hard time managing it. I moved to this host and it was a lot better. Just started ? No, it seems I am always using around 1GB of RAM Anything changed recently ? Nothing Link to comment Share on other sites More sharing options...
IveLeft... Posted September 8, 2016 Share Posted September 8, 2016 Is it a managed VPS or ? CPanel / WHM ? Link to comment Share on other sites More sharing options...
Square Wheels Posted September 8, 2016 Author Share Posted September 8, 2016 Just now, Cloud 9 said: Is it a managed VPS or ? CPanel / WHM ? Is it a managed VPS or ? It's a VPS that they help with / do most of the real work (clearly I'm server clueless) CPanel / WHM ? DirectAdmin Link to comment Share on other sites More sharing options...
IveLeft... Posted September 8, 2016 Share Posted September 8, 2016 If its managed then get them to dig deeper and find the root of the problem Square Wheels 1 Link to comment Share on other sites More sharing options...
Hexsplosions Posted September 8, 2016 Share Posted September 8, 2016 I have a managed VPS with 1GB of RAM and roughly 30 users on during peak times. It's more than adequate for that. I'd get your host to look more into it, or drop me a PM and I will provide the details of my host for you to check out. Link to comment Share on other sites More sharing options...
ASTRAPI Posted September 8, 2016 Share Posted September 8, 2016 It looks like it needs some tunning so it will not use all of your ram Link to comment Share on other sites More sharing options...
Square Wheels Posted September 9, 2016 Author Share Posted September 9, 2016 14 hours ago, ASTRAPI said: It looks like it needs some tunning so it will not use all of your ram Is this something I would do or ask the host? Link to comment Share on other sites More sharing options...
ASTRAPI Posted September 9, 2016 Share Posted September 9, 2016 If you know what do do then you can go ahead if not ask your host if they provide that for you..... It is not something that someone can let you know and just add it there as optimization is specific to each user and each server.... Also if yo are on shared server then only the provider can do that..... Link to comment Share on other sites More sharing options...
sobrenome Posted March 28, 2020 Share Posted March 28, 2020 For IPS 4.4 and about 300 online users, how much ram on a VPS would be fine theoreticaly? Link to comment Share on other sites More sharing options...
Makoto Posted March 28, 2020 Share Posted March 28, 2020 1 hour ago, sobrenome said: For IPS 4.4 and about 300 online users, how much ram on a VPS would be fine theoreticaly? Would largely depend on the size of your site / database. Ideally, you want enough RAM to store your entire database in memory as a starting point. Then you need to calculate the maximum amount of memory MySQL can use for your max connections limit. Tools like mysqltuner.pl can help with this. You also need to account for how much memory your web server and PHP will consume. sobrenome 1 Link to comment Share on other sites More sharing options...
Recommended Posts