Square Wheels Posted September 8, 2016 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.
IveLeft... Posted September 8, 2016 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 ?
Square Wheels Posted September 8, 2016 Author 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
Square Wheels Posted September 8, 2016 Author 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
IveLeft... Posted September 8, 2016 Posted September 8, 2016 If its managed then get them to dig deeper and find the root of the problem Square Wheels 1
Hexsplosions Posted September 8, 2016 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.
ASTRAPI Posted September 8, 2016 Posted September 8, 2016 It looks like it needs some tunning so it will not use all of your ram
Square Wheels Posted September 9, 2016 Author 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?
ASTRAPI Posted September 9, 2016 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.....
sobrenome Posted March 28, 2020 Posted March 28, 2020 For IPS 4.4 and about 300 online users, how much ram on a VPS would be fine theoreticaly?
Makoto Posted March 28, 2020 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
Recommended Posts